sábado, 28 de abril de 2012

MySQL Enterprise Backup - Parte II

Postado por Emerson às 19:42 Marcadores: 0 comentários

Olá pessoal.

Continuando a série de posts sobre o MySQL Enterprise Backup, hoje irei demonstrar como criar um usuário com privilégios necessários para efetuar backups e efetuar backup full do banco de dados.

Instalando o MySQL em Ambiente Oracle Enterprise Linux
Instalando o MySQL Enterprise Backup

Com o MySQL Enterprise Backup é possível fazer backups dos seguintes modos:

Hot backups(Online)  - São executados enquanto o banco de dados está online.Esse tipo de backup não bloqueia operações de banco de dados normais, captura até mesmo as mudanças que ocorrem enquanto o backup está acontecendo.
Incremental Backup - Backup apenas das alterações de dados desde o ultimo backup full(completo).
Cold Backups -  Enquanto o banco de dados é interrompido.
Point Time Recovery (PITR) - Recuperação dos dados em um estado consistente exatamente como estava em uma determinada data e hora.(Uma hora antes por exemplo).

Entre os citados os hot backups são os mais utilizados, para evitar a interrupção do serviço, normalmente você executar um backup como de um escravo de replicação, o que pode ser interrompido sem derrubar todo o aplicativo ou site.

1 - Criando e configurando usuario de backup.

Por default não é necessário a criação do usuário, o usuário root poderia ser setado para essa operação, porém o DBA deve preocupar-se sempre com as questões de segurança do seu ambiente de banco de dados.
Os privilégios mínimos para o usuário do MySQL que mysqlbackup conecta como são:

 * RELOAD - Em todos os bancos de dados e tabelas;
 * CREATE,INSERT e DROP -  Nas tabelas mysql.ibbackup_binlog_marker, mysql.backup_progress e mysql.backup_history.
 * SUPER  - Usado para otimizar o bloqueio e minimizar os inconvenientes para processamento de dados.
Esse privilégio só é necessário para fazer backup de servidores MySQL 5.5 e superiores.
 * CREATE TEMPORARY TABLES  - Esse privilégio só é necessário para fazer backup de servidores MySQL 5.5 e superiores.
 * REPLICATION CLIENT - Para recuperar a posição do log binário, que é armazenada com o backup.

 Então vamos a prática:

[root@mysql-master ~]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.2-m5-log MySQL Community Server (GPL)


Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> GRANT RELOAD ON *.* TO dba@localhost;
Query OK, 0 rows affected (0.00 sec)


mysql> GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker TO 'dba'@'localhost';
Query OK, 0 rows affected (0.10 sec)


mysql> GRANT CREATE, INSERT, DROP ON mysql.backup_progress TO 'dba'@'localhost';
Query OK, 0 rows affected (0.00 sec)


mysql> GRANT CREATE, INSERT, DROP ON mysql.backup_history TO 'dba'@'localhost';
Query OK, 0 rows affected (0.00 sec)


mysql> GRANT REPLICATION CLIENT ON *.* TO 'dba'@'localhost';
Query OK, 0 rows affected (0.02 sec)


mysql> GRANT SUPER ON *.* TO 'dba'@'localhost';
Query OK, 0 rows affected (0.00 sec)


mysql> GRANT CREATE TEMPORARY TABLES ON mysql.* TO 'dba'@'localhost';
Query OK, 0 rows affected (0.04 sec)


mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)


mysql>

Este ultimo comando FLUSH PRIVILEGES serve para que todas alterações referentes a ao acesso do servidor tenham efeito;

2 - Designando o local do Backup.

Todas as operações relacionadas a backup ou criar novos arquivos ou arquivos de referência existentes debaixo de um diretório específico  que contém dados de backup. Escolha o diretório de antecedência, em um sistema de arquivos com armazenamento suficiente.
(Pode até ser montado remotamente de um servidor diferente.) Você especifica o caminho para esse diretório com a opção --backup-dir para invocações  muitos do comando mysqlbackup.

Depois de estabelecer um cronograma regular de backup com trabalhos automatizados, é preferível manter cada backup dentro de um subdiretório timestamped  sob o diretório principal de backup. Para fazer o comando mysqlbackup criar esses subdiretórios automaticamente, especifique a opção --with-timestamp  cada vez que você executar mysqlbackup.

Para as operações de um tempo de backup, por exemplo, quando a clonagem de um banco de dados para configurar um slave de replicação, você pode especificar um novo diretório de cada vez, ou especificar a opção --force de mysqlbackup para substituir os arquivos antigos de backup.

3 - Efetuando o backup full 

Neste exemplo irei especificar algumas opções necessárias na linha de comando para fins de ilustração, porém essas configurações podem ser feitas no arquivo  e configuração do MySQL afim de padronizar o procedimento de backup.O diretorio padrão dos binários do MySQL Enterprise Backup encontra-se em /opt/mysql/meb-3.7/bin/.Então vamos ao que interessa;

[root@mysql-master backup]# /opt/mysql/meb-3.7/bin/mysqlbackup --user=dba  --with-timestamp --backup-dir=/backup backup-and-apply-log
MySQL Enterprise Backup version 3.7.0 [2011/12/19]
Copyright (c) 2003, 2011, Oracle and/or its affiliates. All Rights Reserved.


INFO: Starting with following command line ...
 /opt/mysql/meb-3.7/bin/mysqlbackup --user=dba --with-timestamp
        --backup-dir=/backup backup-and-apply-log


INFO: Got some server configuration information from running server.


IMPORTANT: Please check that mysqlbackup run completes successfully.
            At the end of a successful 'backup-and-apply-log' run mysqlbackup
            prints "mysqlbackup completed OK!".


--------------------------------------------------------------------
                       Server Repository Options:
--------------------------------------------------------------------
  datadir                          =  /var/lib/mysql/
  innodb_data_home_dir             =
  innodb_data_file_path            =  ibdata1:10M:autoextend
  innodb_log_group_home_dir        =  /var/lib/mysql/
  innodb_log_files_in_group        =  2
  innodb_log_file_size             =  5242880


--------------------------------------------------------------------
                       Backup Config Options:
--------------------------------------------------------------------
  datadir                          =  /backup/2012-04-28_22-43-51/datadir
  innodb_data_home_dir             =  /backup/2012-04-28_22-43-51/datadir
  innodb_data_file_path            =  ibdata1:10M:autoextend
  innodb_log_group_home_dir        =  /backup/2012-04-28_22-43-51/datadir
  innodb_log_files_in_group        =  2
  innodb_log_file_size             =  5242880


 mysqlbackup: INFO: Unique generated backup id for this is 13356638315973228
 mysqlbackup: INFO: Uses posix_fadvise() for performance optimization.
 mysqlbackup: INFO: System tablespace file format is Antelope.
 mysqlbackup: INFO: Found checkpoint at lsn 146245791.
 mysqlbackup: INFO: Starting log scan from lsn 146245632.
120428 22:43:51 mysqlbackup: INFO: Copying log...
120428 22:43:51 mysqlbackup: INFO: Log copied, lsn 146245791.
          We wait 1 second before starting copying the data files...
120428 22:43:52 mysqlbackup: INFO: Copying /var/lib/mysql/ibdata1 (Antelope file format).
 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
120428 22:44:18 mysqlbackup: INFO: Starting to lock all the tables....
120428 22:44:18 mysqlbackup: INFO: All tables are locked and flushed to disk
 mysqlbackup: INFO: Opening backup source directory '/var/lib/mysql/'
120428 22:44:18 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/var/lib/mysql/'
 mysqlbackup: INFO: Backing up the database directory 'base01'
 mysqlbackup: INFO: Backing up the database directory 'base02'
 mysqlbackup: INFO: Backing up the database directory 'base03'
 mysqlbackup: INFO: Backing up the database directory 'base04'
 mysqlbackup: INFO: Backing up the database directory 'base05'
 mysqlbackup: INFO: Backing up the database directory 'base06'
 mysqlbackup: INFO: Backing up the database directory 'base07'
 mysqlbackup: INFO: Backing up the database directory 'base08'
 mysqlbackup: INFO: Backing up the database directory 'base09'
 mysqlbackup: INFO: Backing up the database directory 'base10'
 mysqlbackup: INFO: Backing up the database directory 'base11'
 mysqlbackup: INFO: Backing up the database directory 'base12'
 mysqlbackup: INFO: Backing up the database directory 'base13'
 mysqlbackup: INFO: Backing up the database directory 'base14'
 mysqlbackup: INFO: Backing up the database directory 'base15'
 mysqlbackup: INFO: Backing up the database directory 'base16'
 mysqlbackup: INFO: Backing up the database directory 'base17'
 mysqlbackup: INFO: Backing up the database directory 'base18'
 mysqlbackup: INFO: Backing up the database directory 'base19'
 mysqlbackup: INFO: Backing up the database directory 'base20'
 mysqlbackup: INFO: Backing up the database directory 'base21'
 mysqlbackup: INFO: Backing up the database directory 'base22'
 mysqlbackup: INFO: Backing up the database directory 'certificacao'
 mysqlbackup: INFO: Backing up the database directory 'mysql'
 mysqlbackup: INFO: Backing up the database directory 'performance_schema'
 mysqlbackup: INFO: Backing up the database directory 'replication01'
 mysqlbackup: INFO: Backing up the database directory 'teste_slave'
 mysqlbackup: INFO: Backing up the database directory 'testerepli1'
 mysqlbackup: INFO: Copying innodb data and logs during final stage ...
 mysqlbackup: INFO: A copied database page was modified at 146245791.
          (This is the highest lsn found on page)
          Scanned log up to lsn 146247636.
          Was able to parse the log up to lsn 146247636.
          Maximum page number for a log record 7494
120428 22:46:05 mysqlbackup: INFO: All tables unlocked
 mysqlbackup: INFO: All MySQL tables were locked for 107.000 seconds
120428 22:46:05 mysqlbackup: INFO: Full backup completed!
 mysqlbackup: INFO: MySQL binlog position: filename mysql-bin.000003, position 612355039
 mysqlbackup: INFO: Backup created in directory '/backup/2012-04-28_22-43-51'
120428 22:46:05 mysqlbackup: INFO:  ibbackup_logfile's creation parameters:
          start lsn 146245632, end lsn 146247636,
          start checkpoint 146245791.
InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Setting log file size to 0 5242880
Setting log file size to 0 5242880
120428 22:46:06 mysqlbackup: INFO: We were able to parse ibbackup_logfile up to
          lsn 146247636.
ibbackup: Last MySQL binlog file position 0 612355039, file name ./mysql-bin.000003
120428 22:46:06 mysqlbackup: INFO: The first data file is '/backup/2012-04-28_22-43-51/datadir/ibdata1'
          and the new created log files are at '/backup/2012-04-28_22-43-51/datadir/'
 mysqlbackup: INFO: System tablespace file format is Antelope.
120428 22:46:06 mysqlbackup: INFO: Full backup prepared for recovery successfully!


-------------------------------------------------------------
   Parameters Summary
-------------------------------------------------------------
   Start LSN                  : 146245632
   End LSN                    : 146247636
-------------------------------------------------------------


mysqlbackup completed OK!
[root@mysql-master backup]#

Observem que eu adicionei mais um comando o backup-and-apply-log, esse comando realiza backup para o diretório de backup e também realiza a operação de aplicar-log instantâneo no backup. O resultado disso é a cópia de segurança, que está pronto para restauração. Este comando produz sempre backup em modo não compactado.


Pronto! E isso ai galera espero que gostem!

Emerson Martins
DBA Jr

Referencias:
http://dev.mysql.com

segunda-feira, 2 de abril de 2012

Instalando o MySQL Enterprise Backup 3.7

Postado por Emerson às 20:08 Marcadores: 2 comentários
Olá pessoal !


Instalando o MySQL em ambiente Oracle Linux


Anteriormente instalamos o Oracle MySQL Server 5.6.
Hoje irei mostrar como instalar o MySQL Enterprise Backup.Uma ferramenta que faz parte dos produtos oferecidos pela Oracle.

MySQL Enterprise Backup


O MySQL Enterprise Backup é uma ferramenta que realiza as operações de backup online para bancos de dados MySQL. 
Uma arquitetura projetada para a realização backups eficientes e confiáveis de tabelas criadas pelo mecanismo de armazenamento InnoDB. Para completar, ele também pode fazer backup de tabelas MyISAM e outros mecanismos de armazenamento.


Além de executar Hot backup sem bloqueios dos backups que estão sendo executados, os backups completos pode ser realizada em todos os dados InnoDB, sem interromper as consultas ou atualizações.
Backups incrementais e parciais também são suportados, onde apenas os dados que foram alterados a partir de um backup anterior.

1 - Efetuar download do arquivo no site.(Necessário cadastro)
https://edelivery.oracle.com/


2 - Descompactar o arquivo.

[root @oralinux  tmp]# unzip mysqlenterprisebackup.zip
  inflating: meb-3.6-rhel5.i386.rpm

3 - Efetuar a instalação do arquivo rpm.
[root@oralinux u01]# rpm -Uvh meb-3.6-rhel5.i386.rpm

Preparando...               ########################################### [100%]
   1:meb                    ########################################### [100%]
[root@oralinux u01]#


4 - Acessando o MySQL Enterprise Backup
[root@oralinux bin]# ls -lah

total 940K
drwxr-xr-x 2 root root 4,0K Abr  2 22:19 .
drwxr-xr-x 3 root root 4,0K Abr  2 22:19 ..
lrwxrwxrwx 1 root root   11 Abr  2 22:19 ibbackup -> mysqlbackup
lrwxrwxrwx 1 root root   11 Abr  2 22:19 innobackup -> mysqlbackup
-rwxr-xr-x 1 root root 927K Jul 20  2011 mysqlbackup
[root@oralinux bin]#



mysql/meb-3.6/bin/mysqlbackup --help

Usage:
  mysqlbackup [STD-OPTIONS]
              [CONNECTION-OPTIONS]
              [SERVER-REPOSITORY-OPTIONS]
              [BACKUP-REPOSITORY-OPTIONS]
              [--compress] [--compress-level=LEVEL]
              [--include=REGEXP] [--with-timestamp] [--slave-info]
              [--databases=LIST] [--databases-list-file=PATH]
              [--suspend-at-end] [--sleep=MS]
              [--exec-when-locked='utility arg1 arg2 ...']
              [--incremental --start-lsn=LSN --incremental-backup-dir=PATH]
              [--only-known-file-types] [--only-innodb]
              [--no-history-logging] [--no-locking]
              [--backup-dir=PATH]
              [--comments=STRING]
              [--comments-file=PATH]
              [--backup-image=IMAGE]
              [--sbt-database-name=NAME]
              [--sbt-lib-path=PATH]
              backup | backup-and-apply-log | backup-to-image

  mysqlbackup [STD-OPTIONS]
              [--limit-memory=MB] [--uncompress] [--backup-dir=PATH]
              apply-log

  mysqlbackup [STD-OPTIONS]
              [--incremental-backup-dir=PATH] [--backup-dir=PATH]
              [--limit-memory=MB]
              apply-incremental-backup

  mysqlbackup [STD-OPTIONS]
              [SERVER-REPOSITORY-OPTIONS]
              [--backup-dir=PATH]
              copy-back

  mysqlbackup [STD-OPTIONS]
              [--backup-image=IMAGE] [--backup-dir=PATH]
              image-to-backup-dir

  mysqlbackup [STD-OPTIONS]
              [--backup-dir=PATH] [--backup-image=IMAGE]
              backup-dir-to-image
  mysqlbackup [STD-OPTIONS]
              [--backup-image=IMAGE] [--backup-dir=PATH]
              image-to-backup-dir

  mysqlbackup [STD-OPTIONS]
              [--backup-dir=PATH] [--backup-image=IMAGE]
              backup-dir-to-image

  mysqlbackup [STD-OPTIONS]
              [--backup-image=IMAGE] [--src-entry=PATH]
              list-image

  mysqlbackup [STD-OPTIONS]
              [--backup-image=IMAGE]
              [--backup-dir=PATH]
              [--src-entry=PATH] [--dst-entry=PATH]
              extract

 Standard Options [STD-OPTIONS]:
 -------------------------------
  Following standard options may be given as the first argument(s):
    --print-defaults --no-defaults --defaults-file=PATH
    --defaults-extra-file=PATH --defaults-group-suffix=string

  Other standard options are:
  --help          Display this help.
  --version       Display version information.
  --verbose       Print more verbose information.
  --debug         Print debug information.
  --force         By default, both backup and restore operation will refuse
                  to overwrite data/log files. The --force option can be
                  used to force overwriting the destination file.
.....


Pronto! A instalação estar concluída.


Nos demais posts irei demonstrar como configurar os arquivos para fazer backup através do MySQL Enterprise Backup.



Até a proxima!


Emerson Martins 




Fonte:
http://www.mysql.com/

quinta-feira, 15 de dezembro de 2011

Efetuando um Restore/Recover após perda de um Datafile.

Postado por Emerson às 09:02 Marcadores: 2 comentários

Olá pessoal!

No post anterior mostramos como fazer backup do seu banco de dados em modo archivelog implementado num script.
Hoje iremos mostrar uma simulação de falha simples e utilizando o backup para  fazer um restore  com os arquivos de backup feitos anteriormente.

Simulação de Falha
Problema:
Supondo que houve uma "queda de Energia brusca as 4:00 da manhã", e o SO ao reiniciar o banco de dados informando que houve perda ou corrupção de um datafile.


1. Primeiro passo e verificar que você tenha um backup válido!
Com RMAN é possível fazer validação do seu backup, é uma das vantagens de usar ferramenta nativa.


RMAN> list backup summary;
List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
39      B  0  A DISK        02-DEC-11       1       1       NO         HOT_DB_BK_LEVEL0
40      B  0  A DISK        02-DEC-11       1       1       NO         HOT_DB_BK_LEVEL0
41      B  0  A DISK        02-DEC-11       1       1       NO         HOT_DB_BK_LEVEL0
42      B  0  A DISK        02-DEC-11       1       1       NO         HOT_DB_BK_LEVEL0
43      B  0  A DISK        02-DEC-11       1       1       NO         HOT_DB_BK_LEVEL0
44      B  A  A DISK        02-DEC-11       1       1       NO         HOT_BKP_ARCHIVES
45      B  A  A DISK        02-DEC-11       1       1       NO         HOT_BKP_ARCHIVES
46      B  F  A DISK        02-DEC-11       1       1       NO         HOT_BKP_CONTROLFILE


Validando o backup através do RMAN:


RMAN> backup validate database archivelog all;


Starting backup at 02-DEC-11
using channel ORA_DISK_1
specification does not match any archived log in the repository
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/DB11G/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/DB11G/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/DB11G/
USER01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/DB11G/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/DB11G/users01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:06
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              14499        90882           2140858
  File Name: /u01/app/oracle/oradata/DB11G/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              60583
  Index      0              13131
  Other      0              2667


File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2    OK     0              20061        87082           2140874
  File Name: /u01/app/oracle/oradata/DB11G/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              22200
  Index      0              17847
  Other      0              26932


File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              1            58881           2140874
  File Name: /u01/app/oracle/oradata/DB11G/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0
  Index      0              0
  Other      0              58879


File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4    OK     0              805          11040           1161539
  File Name: /u01/app/oracle/oradata/DB11G/users01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              9940
  Index      0              2
  Other      0              293


File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     0              3713         72089           2062124
  File Name: /u01/app/oracle/oradata/DB11G/
USER01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              52337
  Index      0              12486
  Other      0              3552


channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE       OK     0              2
Control File OK     0              612
Finished backup at 02-DEC-11
RMAN>

Podemos observar que em STATUS todos encontram-se OK!

2. Determinar a localização e o nome de um arquivo de dados para renomear ou excluir, nesse caso vamos renomear.
[oracle@oralinux DB11G]$ pwd
/u01/app/oracle/oradata/DB11G
[oracle@oralinux DB11G]$ ls -lah
total 2,8G
drwxr-x--- 2 oracle oinstall 4,0K Nov 26 14:03 .
drwxr-x--- 3 oracle oinstall 4,0K Nov 21 19:42 ..
-rw-r----- 1 oracle oinstall 9,6M Dez  2 13:57 control01.ctl
-rw-r----- 1 oracle oinstall  51M Dez  2 13:57 redo01.log
-rw-r----- 1 oracle oinstall  51M Dez  2 13:43 redo02.log
-rw-r----- 1 oracle oinstall  51M Dez  2 13:43 redo03.log
-rw-r----- 1 oracle oinstall 681M Dez  2 13:57 sysaux01.dbf
-rw-r----- 1 oracle oinstall 711M Dez  2 13:57 system01.dbf
-rw-r----- 1 oracle oinstall  33M Dez  2 13:21 temp01.dbf
-rw-r----- 1 oracle oinstall 461M Dez  2 13:57 undotbs01.dbf
-rw-r----- 1 oracle oinstall 564M Dez  2 13:57 ?USER01.dbf
-rw-r----- 1 oracle oinstall  87M Dez  2 13:57 users01.dbf
[oracle@oralinux DB11G]$
3. Parar o banco de dados.

[oracle@oralinux scripts]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 2 13:55:42 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

4. Renomear um arquivo de dados no nível do OS (simula a falha de mídia).

[oracle@oralinux DB11G]$ mv users01.dbf users01.bkp

5. Tentativa de iniciar o banco de dados.
Antes de simular uma falha de mídia, verifique se você está em um ambiente não-críticos banco de dados teste. 

[oracle@oralinux DB11G]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 2 14:42:04 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  422670336 bytes
Fixed Size                  1336960 bytes
Variable Size             322963840 bytes
Database Buffers           92274688 bytes
Redo Buffers                6094848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u01/app/oracle/oradata/DB11G/users01.dbf'
SQL>

6 - Conectar o banco de dados e colocar em Modo Mount.

[oracle@oralinux scripts]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 2 15:39:30 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database (not started)
RMAN> startup mount;
Oracle instance started
database mounted

Total System Global Area     422670336 bytes
Fixed Size                     1336960 bytes
Variable Size                322963840 bytes
Database Buffers              92274688 bytes
Redo Buffers                   6094848 bytes
RMAN>

7 -  Efetuando o restore

RMAN> restore database;

Starting restore at 02-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/DB11G/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/DB11G/
USER01.dbf
channel ORA_DISK_1: reading from backup piece /u03/rman/bkdb_47_1_768836470
channel ORA_DISK_1: piece handle=/u03/rman/bkdb_47_1_768836470 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/DB11G/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/DB11G/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u03/rman/bkdb_45_1_768836470
channel ORA_DISK_1: piece handle=/u03/rman/bkdb_45_1_768836470 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/DB11G/system01.dbf
channel ORA_DISK_1: reading from backup piece /u03/rman/bkdb_46_1_768836470
channel ORA_DISK_1: piece handle=/u03/rman/bkdb_46_1_768836470 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 02-DEC-11

8 - Efetuando o Recover 

RMAN> recover database;
Starting recover at 02-DEC-11
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:04

Finished recover at 02-DEC-11


9 - Abrindo o Banco de Dados

RMAN> alter database open;
database opened
Pronto! O banco de dados encontra-se aberto e pronto para uso.

10 - Listando o Datafile recuperado no diretório:

[oracle@oralinux DB11G]$ ls -lah
total 2,8G
drwxr-x--- 2 oracle oinstall 4,0K Dez  2 15:41 .
drwxr-x--- 3 oracle oinstall 4,0K Nov 21 19:42 ..
-rw-r----- 1 oracle oinstall 9,6M Dez  2 16:11 control01.ctl
-rw-r----- 1 oracle oinstall  51M Dez  2 16:11 redo01.log
-rw-r----- 1 oracle oinstall  51M Dez  2 15:56 redo02.log
-rw-r----- 1 oracle oinstall  51M Dez  2 15:56 redo03.log
-rw-r----- 1 oracle oinstall 681M Dez  2 16:10 sysaux01.dbf
-rw-r----- 1 oracle oinstall 711M Dez  2 16:07 system01.dbf
-rw-r----- 1 oracle oinstall  33M Dez  2 16:00 temp01.dbf
-rw-r----- 1 oracle oinstall 461M Dez  2 16:10 undotbs01.dbf
-rw-r----- 1 oracle oinstall 564M Dez  2 15:56 ?USER01.dbf
-rw-r----- 1 oracle oinstall  87M Dez  2 13:57 users01.bkp
-rw-r----- 1 oracle oinstall  87M Dez  2 15:56 users01.dbf
[oracle@oralinux DB11G]$

Observem que após o restore o backup copiou novamente o datafile renomeado anteriormente.Possibilitando o banco de dados ser usado novamente em pouco tempo.

"Lembrando que Recover é quem garante o teu emprego!"

Como falei anteriormente o RMAN é uma ferramenta poderosíssima que nos permite fazer backup, restore, recover, standby,etc. Porém é necessário testar, validar e documentar seus backups!Os problemas externos as vezes são inevitáveis porém uma boa Estratégia de Backup não te deixará nunca na mão.

É isso pessoal!
Obrigado a todos!

Emerson
DBA Jr.










quarta-feira, 7 de dezembro de 2011

Backup com RMAN em MODO ARCHIVELOG

Postado por Emerson às 06:54 Marcadores: 2 comentários
Olá galera!

No post passado falamos sobre Os modos ARCHIVELOG e NOARCHIVELOG, mostrando a diferença básica de cada modo de operação dos bancos de dados Oracle.

Hoje iremos mostrar como fazer backup do banco de dados e seus archives gerados com o RMAN(Recovery Manager).
O RMAN é uma ferramenta de backup poderosa gratuita disponibilizada pela Oracle.
Através dela é possível fazer backup dos Controlfiles, SFiles, Datafiles,Tablespaces,Archive Logs, FRA,etc, nos modos citados acima, apenas com restrições para o Modo NOARCHIVELOG, que iremos demonstrar posteriormente.

Cenário:
SO: Oracle Enterprise Linux 5
BD: Oracle 11g R2
Modo: Archivelog
Repositorio:Não

1 - Criando o script de backup online usando RMAN:
Por padrão setei as variável SCRIPTs nas minhas variáveis de ambiente do arquivo .bash_profile do oracle:
BACKUP=/u03/rman; export BACKUP
SCRIPTS=/u03/scripts; export SCRIPTS

vim hot_database_backup_disk.sh
#/usr/bin/ksh
#Script de backup Online(hot)
#Full,Archives e Controlfile
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=DB11G
RMAN_LOG_FILE=/u03/rman/hot_database_backup.`date +%y%m%d%H%M`.out


# -----------------------------------------------------------------
# Inicializando o arquivo de log.
# -----------------------------------------------------------------


echo>> $RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE


echo Script $0>> $RMAN_LOG_FILE
echo ==== started on `date` ====>> $RMAN_LOG_FILE
echo>> $RMAN_LOG_FILE


ORACLE_USER=oracle
TARGET_CONNECT_STR=sys/s


RMAN=$ORACLE_HOME/bin/rman
BACKUP_TYPE="INCREMENTAL LEVEL 0"


# ---------------------------------------------------------------------------
# Escrevendo a saida e valores das variaveis de ambiente setada neste script.
# ---------------------------------------------------------------------------
echo>> $RMAN_LOG_FILE
echo "RMAN: $RMAN">> $RMAN_LOG_FILE
echo "ORACLE_SID: $ORACLE_SID">> $RMAN_LOG_FILE
echo "ORACLE_USER: $ORACLE_USER">> $RMAN_LOG_FILE
echo "ORACLE_HOME: $ORACLE_HOME">> $RMAN_LOG_FILE
echo "BACKUP_TYPE: $BACKUP_TYPE">> $RMAN_LOG_FILE
# ---------------------------------------------------------------------------
echo >> $RMAN_LOG_FILE
CMD_STR=""


#Descomentar a linha abaixo se estiver usando repositorio
#$RMAN target $TARGET_CONNECT_STR catalog rman/r@rmandb << EOF
$RMAN target / <
RUN {
ALLOCATE CHANNEL ch00 TYPE disk ;
ALLOCATE CHANNEL ch01 TYPE disk ;
ALLOCATE CHANNEL ch02 TYPE disk ;
ALLOCATE CHANNEL ch03 TYPE disk ;
BACKUP
$BACKUP_TYPE
SKIP INACCESSIBLE
TAG hot_db_bk_level0
FILESPERSET 5
# formato de backup do banco
FORMAT '/u03/rman/bkdb_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
# formato backup dos archive logs
ALLOCATE CHANNEL ch00 TYPE disk;
ALLOCATE CHANNEL ch01 TYPE disk;
BACKUP
SKIP INACCESSIBLE
filesperset 20
FORMAT '/u03/rman/archives_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE disk;
BACKUP
# formato backup do controlfile
FORMAT '/u03/rman/cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
EOF



2 - Setamos permissão de execução para o script.

[oracle@oralinux scripts]$ chmod +x hot_database_backup_disk.sh


3 - executando o backup


Recovery Manager: Release 11.2.0.1.0 - Production on Fri Nov 25 09:01:25 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DB11G (DBID=237491421)

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35>
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=37 device type=DISK

allocated channel: ch01
channel ch01: SID=57 device type=DISK

allocated channel: ch02
channel ch02: SID=53 device type=DISK

allocated channel: ch03
channel ch03: SID=47 device type=DISK

Starting backup at 25-NOV-11
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/DB11G/
USER01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/DB11G/undotbs01.dbf
channel ch00: starting piece 1 at 25-NOV-11
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/DB11G/system01.dbf
channel ch01: starting piece 1 at 25-NOV-11
channel ch02: starting incremental level 0 datafile backup set
channel ch02: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/DB11G/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/DB11G/users01.dbf
channel ch02: starting piece 1 at 25-NOV-11
channel ch03: starting incremental level 0 datafile backup set
channel ch03: specifying datafile(s) in backup set
including current control file in backup set
channel ch03: starting piece 1 at 25-NOV-11
channel ch03: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/bkdb_4_1_768128494 tag=HOT_DB_BK_LEVEL0 comment=NONE
channel ch03: backup set complete, elapsed time: 00:00:55
channel ch03: starting incremental level 0 datafile backup set
channel ch03: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch03: starting piece 1 at 25-NOV-11
channel ch00: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/bkdb_1_1_768128492 tag=HOT_DB_BK_LEVEL0 comment=NONE
channel ch00: backup set complete, elapsed time: 00:02:17
channel ch03: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/bkdb_5_1_768128575 tag=HOT_DB_BK_LEVEL0 comment=NONE
channel ch03: backup set complete, elapsed time: 00:00:47
channel ch01: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/bkdb_2_1_768128492 tag=HOT_DB_BK_LEVEL0 comment=NONE
channel ch01: backup set complete, elapsed time: 00:02:37
channel ch02: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/bkdb_3_1_768128492 tag=HOT_DB_BK_LEVEL0 comment=NONE
channel ch02: backup set complete, elapsed time: 00:02:47
Finished backup at 25-NOV-11

sql statement: alter system archive log current

released channel: ch00

released channel: ch01

released channel: ch02

released channel: ch03

allocated channel: ch00
channel ch00: SID=37 device type=DISK

allocated channel: ch01
channel ch01: SID=57 device type=DISK

Starting backup at 25-NOV-11
current log archived
channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=1 sequence=23 RECID=1 STAMP=767996428
input archived log thread=1 sequence=24 RECID=2 STAMP=767996436
input archived log thread=1 sequence=25 RECID=3 STAMP=767996445
input archived log thread=1 sequence=26 RECID=4 STAMP=767996455
input archived log thread=1 sequence=27 RECID=5 STAMP=767996463
input archived log thread=1 sequence=28 RECID=6 STAMP=767996474
input archived log thread=1 sequence=29 RECID=7 STAMP=767996483
input archived log thread=1 sequence=30 RECID=8 STAMP=767996490
input archived log thread=1 sequence=31 RECID=9 STAMP=767996499
input archived log thread=1 sequence=32 RECID=10 STAMP=767996508
input archived log thread=1 sequence=33 RECID=11 STAMP=767996516
input archived log thread=1 sequence=34 RECID=12 STAMP=767996524
input archived log thread=1 sequence=35 RECID=13 STAMP=767996533
input archived log thread=1 sequence=36 RECID=14 STAMP=767996540
input archived log thread=1 sequence=37 RECID=15 STAMP=767996549
input archived log thread=1 sequence=38 RECID=16 STAMP=767996557
channel ch00: starting piece 1 at 25-NOV-11
channel ch01: starting archived log backup set
channel ch01: specifying archived log(s) in backup set
input archived log thread=1 sequence=39 RECID=17 STAMP=767996564
input archived log thread=1 sequence=40 RECID=18 STAMP=767996572
input archived log thread=1 sequence=41 RECID=19 STAMP=767996581
input archived log thread=1 sequence=42 RECID=20 STAMP=767996588
input archived log thread=1 sequence=43 RECID=21 STAMP=767996597
input archived log thread=1 sequence=44 RECID=22 STAMP=767996606
input archived log thread=1 sequence=45 RECID=23 STAMP=767996615
input archived log thread=1 sequence=46 RECID=24 STAMP=767996622
input archived log thread=1 sequence=47 RECID=25 STAMP=767996631
input archived log thread=1 sequence=48 RECID=26 STAMP=767996641
input archived log thread=1 sequence=49 RECID=27 STAMP=767996648
input archived log thread=1 sequence=50 RECID=28 STAMP=767996657
input archived log thread=1 sequence=51 RECID=29 STAMP=767996669
input archived log thread=1 sequence=52 RECID=30 STAMP=767996680
input archived log thread=1 sequence=53 RECID=31 STAMP=767996689
input archived log thread=1 sequence=54 RECID=32 STAMP=767996698
channel ch01: starting piece 1 at 25-NOV-11
channel ch00: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/archives_6_1_768128664 tag=TAG20111125T090423 comment=NONE
channel ch00: backup set complete, elapsed time: 00:03:16
channel ch00: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_23_7dtzxt9q_.arc RECID=1                                                           STAMP=767996428
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_24_7dtzy2rb_.arc RECID=2                                                           STAMP=767996436
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_25_7dtzycvt_.arc RECID=3                                                           STAMP=767996445
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_26_7dtzypgz_.arc RECID=4                                                           STAMP=767996455
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_27_7dtzyy6k_.arc RECID=5                                                           STAMP=767996463
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_28_7dtzz9fy_.arc RECID=6                                                           STAMP=767996474
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_29_7dtzzl70_.arc RECID=7                                                           STAMP=767996483
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_30_7dtzzswx_.arc RECID=8                                                           STAMP=767996490
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_31_7dv002rr_.arc RECID=9                                                           STAMP=767996499
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_32_7dv00ccx_.arc RECID=1                                                          0 STAMP=767996508
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_33_7dv00mmc_.arc RECID=1                                                          1 STAMP=767996516
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_34_7dv00vfc_.arc RECID=1                                                          2 STAMP=767996524
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_35_7dv0144t_.arc RECID=1                                                          3 STAMP=767996533
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_36_7dv01cov_.arc RECID=1                                                          4 STAMP=767996540
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_37_7dv01nrj_.arc RECID=1                                                          5 STAMP=767996549
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_38_7dv01wvh_.arc RECID=1                                                          6 STAMP=767996557
channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=1 sequence=55 RECID=33 STAMP=767996710
input archived log thread=1 sequence=56 RECID=34 STAMP=767996721
input archived log thread=1 sequence=57 RECID=35 STAMP=767996726
input archived log thread=1 sequence=58 RECID=36 STAMP=767996732
input archived log thread=1 sequence=59 RECID=37 STAMP=767996737
input archived log thread=1 sequence=60 RECID=38 STAMP=767996747
input archived log thread=1 sequence=61 RECID=39 STAMP=767996752
input archived log thread=1 sequence=62 RECID=40 STAMP=767996765
input archived log thread=1 sequence=63 RECID=41 STAMP=767996780
input archived log thread=1 sequence=64 RECID=42 STAMP=767996791
input archived log thread=1 sequence=65 RECID=43 STAMP=767996806
input archived log thread=1 sequence=66 RECID=44 STAMP=767996819
input archived log thread=1 sequence=67 RECID=45 STAMP=767996835
input archived log thread=1 sequence=68 RECID=46 STAMP=767996849
input archived log thread=1 sequence=69 RECID=47 STAMP=767996863
input archived log thread=1 sequence=70 RECID=48 STAMP=767996875
channel ch00: starting piece 1 at 25-NOV-11
channel ch01: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/archives_7_1_768128664 tag=TAG20111125T090423 comment=NONE
channel ch01: backup set complete, elapsed time: 00:03:38
channel ch01: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_39_7dv023vd_.arc RECID=1                                                          7 STAMP=767996564
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_40_7dv02c5w_.arc RECID=1                                                          8 STAMP=767996572
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_41_7dv02ngt_.arc RECID=1                                                          9 STAMP=767996581
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_42_7dv02vwv_.arc RECID=2                                                          0 STAMP=767996588
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_43_7dv034vf_.arc RECID=2                                                          1 STAMP=767996597
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_44_7dv03fg5_.arc RECID=2                                                          2 STAMP=767996606
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_45_7dv03ors_.arc RECID=2                                                          3 STAMP=767996615
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_46_7dv03xcc_.arc RECID=2                                                          4 STAMP=767996622
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_47_7dv044y0_.arc RECID=2                                                          5 STAMP=767996631
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_48_7dv04g9p_.arc RECID=2                                                          6 STAMP=767996641
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_49_7dv04pg7_.arc RECID=2                                                          7 STAMP=767996648
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_50_7dv04ydk_.arc RECID=2                                                          8 STAMP=767996657
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_51_7dv05b4r_.arc RECID=2                                                          9 STAMP=767996669
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_52_7dv05nn8_.arc RECID=3                                                          0 STAMP=767996680
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_53_7dv05xxz_.arc RECID=3                                                          1 STAMP=767996689
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_54_7dv066xl_.arc RECID=3                                                          2 STAMP=767996698
channel ch01: starting archived log backup set
channel ch01: specifying archived log(s) in backup set
input archived log thread=1 sequence=71 RECID=49 STAMP=767996890
input archived log thread=1 sequence=72 RECID=50 STAMP=767996912
input archived log thread=1 sequence=73 RECID=51 STAMP=767996929
input archived log thread=1 sequence=74 RECID=52 STAMP=767996951
input archived log thread=1 sequence=75 RECID=53 STAMP=767996967
input archived log thread=1 sequence=76 RECID=54 STAMP=767996996
input archived log thread=1 sequence=77 RECID=55 STAMP=767997017
input archived log thread=1 sequence=78 RECID=56 STAMP=767997032
input archived log thread=1 sequence=79 RECID=57 STAMP=768002476
input archived log thread=1 sequence=80 RECID=58 STAMP=768006017
input archived log thread=1 sequence=81 RECID=59 STAMP=768031239
input archived log thread=1 sequence=82 RECID=60 STAMP=768058241
input archived log thread=1 sequence=83 RECID=61 STAMP=768085208
input archived log thread=1 sequence=84 RECID=62 STAMP=768092422
input archived log thread=1 sequence=85 RECID=63 STAMP=768117665
input archived log thread=1 sequence=86 RECID=64 STAMP=768128662
input archived log thread=1 sequence=87 RECID=65 STAMP=768128663
channel ch01: starting piece 1 at 25-NOV-11
channel ch01: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/archives_9_1_768128894 tag=TAG20111125T090423 comment=NONE
channel ch01: backup set complete, elapsed time: 00:02:33
channel ch01: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_71_7dv0d6x3_.arc RECID=49 STAMP=767996890
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_72_7dv0dw0c_.arc RECID=50 STAMP=767996912
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_73_7dv0fg23_.arc RECID=51 STAMP=767996929
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_74_7dv0g30w_.arc RECID=52 STAMP=767996951
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_75_7dv0gmf9_.arc RECID=53 STAMP=767996967
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_76_7dv0hgkj_.arc RECID=54 STAMP=767996996
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_77_7dv0j5ql_.arc RECID=55 STAMP=767997017
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_78_7dv0jmnw_.arc RECID=56 STAMP=767997032
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_79_7dv5tomg_.arc RECID=57 STAMP=768002476
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_80_7dv99hcd_.arc RECID=58 STAMP=768006017
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_24/o1_mf_1_81_7dw1xo8o_.arc RECID=59 STAMP=768031239
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_24/o1_mf_1_82_7dww9gxp_.arc RECID=60 STAMP=768058241
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_24/o1_mf_1_83_7dxpn64c_.arc RECID=61 STAMP=768085208
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_24/o1_mf_1_84_7dxxoncd_.arc RECID=62 STAMP=768092422
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_25/o1_mf_1_85_7dypbdnv_.arc RECID=63 STAMP=768117665
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_25/o1_mf_1_86_7dz125rh_.arc RECID=64 STAMP=768128662
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_25/o1_mf_1_87_7dz127d5_.arc RECID=65 STAMP=768128663
channel ch00: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/archives_8_1_768128881 tag=TAG20111125T090423 comment=NONE
channel ch00: backup set complete, elapsed time: 00:03:28
channel ch00: deleting archived log(s)
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_55_7dv06l77_.arc RECID=33 STAMP=767996710
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_56_7dv06yyr_.arc RECID=34 STAMP=767996721
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_57_7dv075dw_.arc RECID=35 STAMP=767996726
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_58_7dv07cbs_.arc RECID=36 STAMP=767996732
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_59_7dv07k4c_.arc RECID=37 STAMP=767996737
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_60_7dv07tgw_.arc RECID=38 STAMP=767996747
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_61_7dv07zhs_.arc RECID=39 STAMP=767996752
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_62_7dv089n6_.arc RECID=40 STAMP=767996765
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_63_7dv08sn5_.arc RECID=41 STAMP=767996780
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_64_7dv094t9_.arc RECID=42 STAMP=767996791
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_65_7dv09m3r_.arc RECID=43 STAMP=767996806
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_66_7dv0b0q7_.arc RECID=44 STAMP=767996819
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_67_7dv0bh6p_.arc RECID=45 STAMP=767996835
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_68_7dv0by8y_.arc RECID=46 STAMP=767996849
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_69_7dv0cf3c_.arc RECID=47 STAMP=767996863
archived log file name=/u01/app/oracle/flash_recovery_area/DB11G/archivelog/2011_11_23/o1_mf_1_70_7dv0cs7b_.arc RECID=48 STAMP=767996875
Finished backup at 25-NOV-11

released channel: ch00

released channel: ch01

allocated channel: ch00
channel ch00: SID=37 device type=DISK

Starting backup at 25-NOV-11
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
including current control file in backup set
channel ch00: starting piece 1 at 25-NOV-11
channel ch00: finished piece 1 at 25-NOV-11
piece handle=/u03/rman/cntrl_10_1_768129092 tag=TAG20111125T091132 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 25-NOV-11

released channel: ch00

RMAN>

Recovery Manager complete.
[oracle@oralinux scripts]$

4 - Visualizando os arquivos gerados do na partição de backup

[oracle@oralinux rman]$ pwd
/u03/rman
[oracle@oralinux rman]$ ls -lah
total 5,6G
drwxr-xr-x 2 oracle oinstall 4,0K Nov 26 08:38 .
drwxr-xr-x 6 oracle oinstall 4,0K Nov 25 04:39 ..
-rw-r----- 1 oracle oinstall 768M Nov 25 09:07 archives_6_1_768128664
-rw-r----- 1 oracle oinstall 755M Nov 25 09:07 archives_7_1_768128664
-rw-r----- 1 oracle oinstall 750M Nov 25 09:11 archives_8_1_768128881
-rw-r----- 1 oracle oinstall 669M Nov 25 09:10 archives_9_1_768128894
-rw-r----- 1 oracle oinstall 447M Nov 26 08:36 bkdb_11_1_768213241
-rw-r----- 1 oracle oinstall 514M Nov 25 09:03 bkdb_1_1_768128492
-rw-r----- 1 oracle oinstall 9,7M Nov 26 08:35 bkdb_14_1_768213243
-rw-r----- 1 oracle oinstall  96K Nov 26 08:36 bkdb_15_1_768213373
-rw-r----- 1 oracle oinstall 601M Nov 26 08:37 bkdb_16_1_768213419
-rw-r----- 1 oracle oinstall 598M Nov 25 09:04 bkdb_2_1_768128492
-rw-r----- 1 oracle oinstall 507M Nov 25 09:04 bkdb_3_1_768128492
-rw-r----- 1 oracle oinstall 9,7M Nov 25 09:01 bkdb_4_1_768128494
-rw-r----- 1 oracle oinstall  96K Nov 25 09:03 bkdb_5_1_768128575
-rw-r----- 1 oracle oinstall 9,7M Nov 25 09:11 cntrl_10_1_768129092
-rw-rw-rw- 1 oracle oinstall  262 Nov 25 08:54 hot_database_backup.1111250854.out
-rw-rw-rw- 1 oracle oinstall  262 Nov 25 08:57 hot_database_backup.1111250857.out
-rw-rw-rw- 1 oracle oinstall  262 Nov 25 09:00 hot_database_backup.1111250900.out
-rw-rw-rw- 1 oracle oinstall  262 Nov 25 09:01 hot_database_backup.1111250901.out
-rw-rw-rw- 1 root   root      526 Nov 26 08:33 hot_database_backup.1111260833.out


Visualizando o log do backup:
[oracle@oralinux rman]$ cat hot_database_backup.1111250901.out

Script ./hot_database_backup_disk.sh
==== started on Sex Nov 25 09:01:25 BRT 2011 ====


RMAN: /u01/app/oracle/product/11.2.0/db_1/bin/rman
ORACLE_SID: DB11G
ORACLE_USER: oracle
ORACLE_HOME: /u01/app/oracle/product/11.2.0/db_1
BACKUP_TYPE: INCREMENTAL LEVEL 0

[oracle@oralinux rman]$

5 - Nossos arquivos estão prontos para serem enviado para uma mídia externa (disco bkp,fita, etc):

6 - Listando o conteudo de nossos backup via RMAN:

[oracle@oralinux rman]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Nov 26 08:46:44 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DB11G (DBID=237491421)

RMAN> list backup  summary;

using target database control file instead of recovery catalog

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1       B  0  A DISK        25-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
2       B  0  A DISK        25-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
3       B  0  A DISK        25-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
4       B  0  A DISK        25-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
5       B  0  A DISK        25-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
6       B  A  A DISK        25-NOV-11       1       1       NO         TAG20111125T090423
7       B  A  A DISK        25-NOV-11       1       1       NO         TAG20111125T090423
8       B  A  A DISK        25-NOV-11       1       1       NO         TAG20111125T090423
9       B  A  A DISK        25-NOV-11       1       1       NO         TAG20111125T090423
10      B  F  A DISK        25-NOV-11       1       1       NO         TAG20111125T091132
11      B  0  A DISK        26-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
12      B  0  A DISK        26-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
13      B  0  A DISK        26-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0
14      B  0  A DISK        26-NOV-11       1       1       NO         HOT_DB_BK_LEVEL0

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Incr 0  9.61M      DISK        00:00:27     25-NOV-11
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_4_1_768128494
  Control File Included: Ckp SCN: 1321530      Ckp time: 25-NOV-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  80.00K     DISK        00:00:40     25-NOV-11
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_5_1_768128575
  SPFILE Included: Modification time: 23-NOV-11
  SPFILE db_unique_name: DB11G

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Incr 0  513.55M    DISK        00:02:07     25-NOV-11
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_1_1_768128492
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1321528    25-NOV-11 /u01/app/oracle/oradata/DB11G/undotbs01.dbf
  5    0  Incr 1321528    25-NOV-11 /u01/app/oracle/oradata/DB11G/
USER01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Incr 0  597.66M    DISK        00:02:32     25-NOV-11
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_2_1_768128492
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1321529    25-NOV-11 /u01/app/oracle/oradata/DB11G/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  506.79M    DISK        00:02:40     25-NOV-11
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_3_1_768128492
  List of Datafiles in backup set 5
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1321530    25-NOV-11 /u01/app/oracle/oradata/DB11G/sysaux01.dbf
  4    0  Incr 1321530    25-NOV-11 /u01/app/oracle/oradata/DB11G/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       767.24M    DISK        00:03:06     25-NOV-11
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20111125T090423
        Piece Name: /u03/rman/archives_6_1_768128664

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    23      1074276    23-NOV-11 1110309    23-NOV-11
  1    24      1110309    23-NOV-11 1110969    23-NOV-11
  1    25      1110969    23-NOV-11 1111627    23-NOV-11
  1    26      1111627    23-NOV-11 1112282    23-NOV-11
  1    27      1112282    23-NOV-11 1112931    23-NOV-11
  1    28      1112931    23-NOV-11 1113604    23-NOV-11
  1    29      1113604    23-NOV-11 1114271    23-NOV-11
  1    30      1114271    23-NOV-11 1114884    23-NOV-11
  1    31      1114884    23-NOV-11 1115537    23-NOV-11
  1    32      1115537    23-NOV-11 1116202    23-NOV-11
  1    33      1116202    23-NOV-11 1116851    23-NOV-11
  1    34      1116851    23-NOV-11 1117511    23-NOV-11
  1    35      1117511    23-NOV-11 1118172    23-NOV-11
  1    36      1118172    23-NOV-11 1118822    23-NOV-11
  1    37      1118822    23-NOV-11 1119460    23-NOV-11
  1    38      1119460    23-NOV-11 1120117    23-NOV-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7       754.51M    DISK        00:03:36     25-NOV-11
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20111125T090423
        Piece Name: /u03/rman/archives_7_1_768128664

  List of Archived Logs in backup set 7
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    39      1120117    23-NOV-11 1120686    23-NOV-11
  1    40      1120686    23-NOV-11 1121339    23-NOV-11
  1    41      1121339    23-NOV-11 1121993    23-NOV-11
  1    42      1121993    23-NOV-11 1122592    23-NOV-11
  1    43      1122592    23-NOV-11 1123252    23-NOV-11
  1    44      1123252    23-NOV-11 1123911    23-NOV-11
  1    45      1123911    23-NOV-11 1124560    23-NOV-11
  1    46      1124560    23-NOV-11 1125213    23-NOV-11
  1    47      1125213    23-NOV-11 1125871    23-NOV-11
  1    48      1125871    23-NOV-11 1126520    23-NOV-11
  1    49      1126520    23-NOV-11 1127071    23-NOV-11
  1    50      1127071    23-NOV-11 1127711    23-NOV-11
  1    51      1127711    23-NOV-11 1128424    23-NOV-11
  1    52      1128424    23-NOV-11 1129068    23-NOV-11
  1    53      1129068    23-NOV-11 1129706    23-NOV-11
  1    54      1129706    23-NOV-11 1130345    23-NOV-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
8       668.43M    DISK        00:02:25     25-NOV-11
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20111125T090423
        Piece Name: /u03/rman/archives_9_1_768128894

  List of Archived Logs in backup set 8
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    71      1144270    23-NOV-11 1145203    23-NOV-11
  1    72      1145203    23-NOV-11 1146147    23-NOV-11
  1    73      1146147    23-NOV-11 1147093    23-NOV-11
  1    74      1147093    23-NOV-11 1148038    23-NOV-11
  1    75      1148038    23-NOV-11 1148892    23-NOV-11
  1    76      1148892    23-NOV-11 1149828    23-NOV-11
  1    77      1149828    23-NOV-11 1150784    23-NOV-11
  1    78      1150784    23-NOV-11 1151627    23-NOV-11
  1    79      1151627    23-NOV-11 1162193    23-NOV-11
  1    80      1162193    23-NOV-11 1172163    23-NOV-11
  1    81      1172163    23-NOV-11 1199706    24-NOV-11
  1    82      1199706    24-NOV-11 1230948    24-NOV-11
  1    83      1230948    24-NOV-11 1262774    24-NOV-11
  1    84      1262774    24-NOV-11 1278495    24-NOV-11
  1    85      1278495    24-NOV-11 1309029    25-NOV-11
  1    86      1309029    25-NOV-11 1321682    25-NOV-11
  1    87      1321682    25-NOV-11 1321720    25-NOV-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       749.38M    DISK        00:03:28     25-NOV-11
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20111125T090423
        Piece Name: /u03/rman/archives_8_1_768128881

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    55      1130345    23-NOV-11 1130992    23-NOV-11
  1    56      1130992    23-NOV-11 1131674    23-NOV-11
  1    57      1131674    23-NOV-11 1132602    23-NOV-11
  1    58      1132602    23-NOV-11 1133527    23-NOV-11
  1    59      1133527    23-NOV-11 1134466    23-NOV-11
  1    60      1134466    23-NOV-11 1135345    23-NOV-11
  1    61      1135345    23-NOV-11 1136282    23-NOV-11
  1    62      1136282    23-NOV-11 1137168    23-NOV-11
  1    63      1137168    23-NOV-11 1137981    23-NOV-11
  1    64      1137981    23-NOV-11 1138860    23-NOV-11
  1    65      1138860    23-NOV-11 1139807    23-NOV-11
  1    66      1139807    23-NOV-11 1140650    23-NOV-11
  1    67      1140650    23-NOV-11 1141551    23-NOV-11
  1    68      1141551    23-NOV-11 1142487    23-NOV-11
  1    69      1142487    23-NOV-11 1143431    23-NOV-11
  1    70      1143431    23-NOV-11 1144270    23-NOV-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Full    9.61M      DISK        00:00:02     25-NOV-11
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20111125T091132
        Piece Name: /u03/rman/cntrl_10_1_768129092
  Control File Included: Ckp SCN: 1322520      Ckp time: 25-NOV-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Incr 0  9.61M      DISK        00:01:07     26-NOV-11
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_14_1_768213243
  Control File Included: Ckp SCN: 1435210      Ckp time: 26-NOV-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Incr 0  446.88M    DISK        00:02:40     26-NOV-11
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_11_1_768213241
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1435199    26-NOV-11 /u01/app/oracle/oradata/DB11G/sysaux01.dbf
  3    0  Incr 1435199    26-NOV-11 /u01/app/oracle/oradata/DB11G/undotbs01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Incr 0  80.00K     DISK        00:00:30     26-NOV-11
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_15_1_768213373
  SPFILE Included: Modification time: 23-NOV-11
  SPFILE db_unique_name: DB11G

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Incr 0  600.00M    DISK        00:01:01     26-NOV-11
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /u03/rman/bkdb_16_1_768213419
  List of Datafiles in backup set 14
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1435376    26-NOV-11 /u01/app/oracle/oradata/DB11G/system01.dbf

RMAN>

Pronto!Em outro post iremos abordar a Restore e Recover de banco de dados através do RMAN.




Assinar: Postagens (Atom)