Recuperando Banco de Dados Oracle com RMAN non-ASM

fevereiro 3, 2012 - Backup, Erros, Oracle Database, Scripts, Segurança - Tagged: asm, backup, dados, database, LRM-00109, ORA-01078, oracleasm, pfile, recover, recovering, recuperação, restauração, restore, rman, script, shutdown, spfile, startup - no comments

O objetivo deste artigo é explicar como recuperar o Banco de Dados Oracle numa possível perda dos arquivos do Banco de Dados por falhas que podem ocorrer.

OBS: Vamos recuperar o banco de dados Oracle através do “Backup Físico”.
Vou rodar o script de inicialização do Server Oracle (Instância + Banco de Dados).
Script Inicializacao Desligamento Database.

[oracle@serveroracle ~]$ . liga_serveroracle.sh

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 02-FEB-2012 21:04:09

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting /oraprd01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /oraprd01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oraprd01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.104)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.104)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date                02-FEB-2012 21:04:09
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oraprd01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oraprd01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.104)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dbprod" has 1 instance(s).
  Instance "dbprod", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Feb 2 21:04:53 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  1277824 bytes
Variable Size             545259648 bytes
Database Buffers          524288000 bytes
Redo Buffers                2916352 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Release 10.2.0.5.0 - Production
[oracle@serveroracle ~]$

Vamos conectar no Banco de Dados e verificar as informações do mesmo.

[oracle@serveroracle ~]$ sqlplus sys/***** as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Feb 2 21:04:53 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.5.0 - Production

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL>

Podemos observar que o banco de dados está em modo archivelog. Este será importante para o nosso teste de recuperação do banco de dados.
Vamos verificar os redo log files.

SQL> set lines 155
col MEMBER for a45
select l.GROUP#, l.THREAD#, l.SEQUENCE#, l.ARCHIVED, l.STATUS, (l.BYTES/1024/1024) BYTES_MB, lf.MEMBER
from v$log l join v$logfile lf
on(l.GROUP#=lf.GROUP#)
where l.THREAD# = 1
order by 1
;SQL> SQL>   2    3    4    5    6

    GROUP#    THREAD#  SEQUENCE# ARC STATUS             BYTES_MB MEMBER
---------- ---------- ---------- --- ---------------- ---------- ---------------------------------------------
         1          1          1 NO  CURRENT                  80 /oraprd02/oradata/dbprod/redo001.log
         2          1          0 YES UNUSED                   80 /oraprd02/oradata/dbprod/redo002.log
         3          1          0 YES UNUSED                   80 /oraprd02/oradata/dbprod/redo003.log

SQL>

Podemos observar que a seqüência está no número 1. Vamos realizar alguns switches e gerar alguns archivelogs.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system checkpoint;

System altered.

SQL>

Vamos verificar a sequência dos redo log files novamente.

SQL> set lines 155
col MEMBER for a45
select l.GROUP#, l.THREAD#, l.SEQUENCE#, l.ARCHIVED, l.STATUS, (l.BYTES/1024/1024) BYTES_MB, lf.MEMBER
from v$log l join v$logfile lf
on(l.GROUP#=lf.GROUP#)
where l.THREAD# = 1
order by 1
;SQL> SQL>   2    3    4    5    6

    GROUP#    THREAD#  SEQUENCE# ARC STATUS             BYTES_MB MEMBER
---------- ---------- ---------- --- ---------------- ---------- ---------------------------------------------
         1          1          4 YES INACTIVE                 80 /oraprd02/oradata/dbprod/redo001.log
         2          1          5 YES INACTIVE                 80 /oraprd02/oradata/dbprod/redo002.log
         3          1          6 NO  CURRENT                  80 /oraprd02/oradata/dbprod/redo003.log

SQL> !

Vamos verificar os archivelogs gerados.

[oracle@serveroracle ~]$ ls -ltr /orabackup/dbprod/oraarchive/
[oracle@serveroracle oraarchive]$ ls -ltr
total 1776
-rw-r----- 1 oracle oinstall 1797120 Feb  2 21:05 dbprod_1_1_773532936.arc
-rw-r----- 1 oracle oinstall    1024 Feb  2 21:05 dbprod_1_2_773532936.arc
-rw-r----- 1 oracle oinstall    4096 Feb  2 21:05 dbprod_1_3_773532936.arc
-rw-r----- 1 oracle oinstall    1024 Feb  2 21:05 dbprod_1_4_773532936.arc
-rw-r----- 1 oracle oinstall    1024 Feb  2 21:05 dbprod_1_5_773532936.arc
[oracle@serveroracle oraarchive]$

Vamos verificar as configurações do RMAN, rodar a manutenção do RMAN e realizar um backup full do banco de dados.

[oracle@serveroracle oraarchive]$ rman target sys/********

Recovery Manager: Release 10.2.0.5.0 - Production on Thu Feb 2 21:07:44 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DBPROD (DBID=862715809)

RMAN>

Verificando as configurações do RMAN para o Banco de Dados.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orabackup/dbprod/fisico/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oraprd01/app/oracle/product/10.2.0/db_1/dbs/snapcf_dbprod.f'; # default

RMAN>

Vamos executar a manutenção do RMAN.

RMAN> run {
crosscheck backup;
crosscheck copy;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt obsolete;
}2> 3> 4> 5> 6> 7> 8>

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773520384_1_25_01_2012_773520384 recid=35 stamp=773520384
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773520579_1_25_01_2012_773520579 recid=36 stamp=773520580
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773520645_1_25_01_2012_773520645 recid=37 stamp=773520645
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/arch_DBPROD_773520655_1_25_01_2012_773520655 recid=38 stamp=773523102
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/c-862715809-20120125-09 recid=42 stamp=773524065
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773531494_1_25_01_2012_773531494 recid=43 stamp=773531495
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773531680_1_25_01_2012_773531680 recid=44 stamp=773531680
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773531745_1_25_01_2012_773531745 recid=45 stamp=773531745
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/arch_DBPROD_773531758_1_25_01_2012_773531758 recid=46 stamp=773532848
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/ctlf_DBPROD_773531753_1_25_01_2012_773531753 recid=47 stamp=773532849
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/c-862715809-20120125-0a recid=49 stamp=773532849
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/spf_DBPROD_773531760_1_25_01_2012_773531760 recid=50 stamp=773532849
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/dbprod/fisico/c-862715809-20120125-0b recid=51 stamp=773532960
Crosschecked 13 objects


released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_1_773524042.arc recid=105 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_2_773524042.arc recid=102 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_3_773524042.arc recid=101 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_4_773524042.arc recid=103 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_5_773524042.arc recid=100 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_6_773524042.arc recid=104 stamp=773532870
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_1_773532936.arc recid=106 stamp=774219917
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_2_773532936.arc recid=107 stamp=774219918
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_3_773532936.arc recid=108 stamp=774219922
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_4_773532936.arc recid=109 stamp=774219923
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_5_773532936.arc recid=110 stamp=774219925
Crosschecked 11 objects


released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_1_773524042.arc recid=105 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_2_773524042.arc recid=102 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_3_773524042.arc recid=101 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_4_773524042.arc recid=103 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_5_773524042.arc recid=100 stamp=773532870
validation failed for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_6_773524042.arc recid=104 stamp=773532870
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_1_773532936.arc recid=106 stamp=774219917
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_2_773532936.arc recid=107 stamp=774219918
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_3_773532936.arc recid=108 stamp=774219922
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_4_773532936.arc recid=109 stamp=774219923
validation succeeded for archived log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_5_773532936.arc recid=110 stamp=774219925
Crosschecked 11 objects


using channel ORA_DISK_1

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
105     1    1       X 25-JAN-12 /orabackup/dbprod/oraarchive/dbprod_1_1_773524042.arc
102     1    2       X 25-JAN-12 /orabackup/dbprod/oraarchive/dbprod_1_2_773524042.arc
101     1    3       X 25-JAN-12 /orabackup/dbprod/oraarchive/dbprod_1_3_773524042.arc
103     1    4       X 25-JAN-12 /orabackup/dbprod/oraarchive/dbprod_1_4_773524042.arc
100     1    5       X 25-JAN-12 /orabackup/dbprod/oraarchive/dbprod_1_5_773524042.arc
104     1    6       X 25-JAN-12 /orabackup/dbprod/oraarchive/dbprod_1_6_773524042.arc
deleted archive log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_1_773524042.arc recid=105 stamp=773532870
deleted archive log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_2_773524042.arc recid=102 stamp=773532870
deleted archive log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_3_773524042.arc recid=101 stamp=773532870
deleted archive log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_4_773524042.arc recid=103 stamp=773532870
deleted archive log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_5_773524042.arc recid=100 stamp=773532870
deleted archive log
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_6_773524042.arc recid=104 stamp=773532870
Deleted 6 EXPIRED objects


RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           35     25-JAN-12
  Backup Piece       35     25-JAN-12          /orabackup/dbprod/fisico/full_DBPROD_773520384_1_25_01_2012_773520384
Backup Set           36     25-JAN-12
  Backup Piece       36     25-JAN-12          /orabackup/dbprod/fisico/full_DBPROD_773520579_1_25_01_2012_773520579
Backup Set           37     25-JAN-12
  Backup Piece       37     25-JAN-12          /orabackup/dbprod/fisico/full_DBPROD_773520645_1_25_01_2012_773520645
Backup Set           38     25-JAN-12
  Backup Piece       38     25-JAN-12          /orabackup/dbprod/fisico/arch_DBPROD_773520655_1_25_01_2012_773520655
Backup Set           42     25-JAN-12
  Backup Piece       42     25-JAN-12          /orabackup/dbprod/fisico/c-862715809-20120125-09
Backup Set           47     25-JAN-12
  Backup Piece       47     25-JAN-12          /orabackup/dbprod/fisico/ctlf_DBPROD_773531753_1_25_01_2012_773531753
Backup Set           49     25-JAN-12
  Backup Piece       49     25-JAN-12          /orabackup/dbprod/fisico/c-862715809-20120125-0a
Backup Set           50     25-JAN-12
  Backup Piece       50     25-JAN-12          /orabackup/dbprod/fisico/spf_DBPROD_773531760_1_25_01_2012_773531760
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773520384_1_25_01_2012_773520384 recid=35 stamp=773520384
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773520579_1_25_01_2012_773520579 recid=36 stamp=773520580
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/full_DBPROD_773520645_1_25_01_2012_773520645 recid=37 stamp=773520645
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/arch_DBPROD_773520655_1_25_01_2012_773520655 recid=38 stamp=773523102
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/c-862715809-20120125-09 recid=42 stamp=773524065
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/ctlf_DBPROD_773531753_1_25_01_2012_773531753 recid=47 stamp=773532849
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/c-862715809-20120125-0a recid=49 stamp=773532849
deleted backup piece
backup piece handle=/orabackup/dbprod/fisico/spf_DBPROD_773531760_1_25_01_2012_773531760 recid=50 stamp=773532849
Deleted 8 objects

RMAN>

Vamos executar os backup full do banco de dados com o RMAN.

RMAN> run {
2> allocate channel c1 device type disk maxpiecesize 1024M;
backup as compressed backupset
3>      format='/orabackup/dbprod/fisico/full_%d_%t_%p_%D_%M_%Y_%t'
4>      tag='BKP_FULL'
5>              (database);
6> backup as compressed backupset
7> 8>   format='/orabackup/dbprod/fisico/ctlf_%d_%t_%p_%D_%M_%Y_%t'
        tag='BKP_CONTROLFILE'
                (current controlfile);
sql 'alter system switch logfile';
9> 10> backup as compressed backupset
        format='/orabackup/dbprod/fisico/arch_%d_%t_%p_%D_%M_%Y_%t'
11>     tag='BKP_ARCHIVELOG'
12> 13>                 (archivelog all delete input);
backup as compressed backupset
14> 15> 16>     format='/orabackup/dbprod/fisico/spf_%d_%t_%p_%D_%M_%Y_%t'
        tag='BKP_SPFILE'
17> 18> 19>             (spfile);
20> release channel c1;
21> }

released channel: ORA_DISK_1
allocated channel: c1
channel c1: sid=142 devtype=DISK

Starting backup at 02-FEB-12
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00002 name=/oraprd02/oradata/dbprod/undotbs01.dbf
input datafile fno=00006 name=/oraprd01/oradata/dbprod/users03.dbf
input datafile fno=00001 name=/oraprd02/oradata/dbprod/system01.dbf
input datafile fno=00003 name=/oraprd02/oradata/dbprod/sysaux01.dbf
input datafile fno=00005 name=/oraprd02/oradata/dbprod/users02.dbf
channel c1: starting piece 1 at 02-FEB-12
channel c1: finished piece 1 at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/full_DBPROD_774220188_1_02_02_2012_774220188 tag=BKP_FULL comment=NONE
channel c1: backup set complete, elapsed time: 00:02:36
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00007 name=/oraprd02/oradata/dbprod/files01.dbf
input datafile fno=00004 name=/oraprd02/oradata/dbprod/users01.dbf
input datafile fno=00008 name=/oraprd02/oradata/dbprod/files_index01.dbf
channel c1: starting piece 1 at 02-FEB-12
channel c1: finished piece 1 at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/full_DBPROD_774220344_1_02_02_2012_774220344 tag=BKP_FULL comment=NONE
channel c1: backup set complete, elapsed time: 00:00:55
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00009 name=/oraprd02/oradata/dbprod/master.dbf
channel c1: starting piece 1 at 02-FEB-12
channel c1: finished piece 1 at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/full_DBPROD_774220400_1_02_02_2012_774220400 tag=BKP_FULL comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 02-FEB-12

Starting backup at 02-FEB-12
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 02-FEB-12
channel c1: finished piece 1 at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/ctlf_DBPROD_774220403_1_02_02_2012_774220403 tag=BKP_CONTROLFILE comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 02-FEB-12

Starting Control File and SPFILE Autobackup at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/c-862715809-20120202-00 comment=NONE
Finished Control File and SPFILE Autobackup at 02-FEB-12

sql statement: alter system switch logfile

Starting backup at 02-FEB-12
current log archived
channel c1: starting compressed archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=106 stamp=774219917
input archive log thread=1 sequence=2 recid=107 stamp=774219918
input archive log thread=1 sequence=3 recid=108 stamp=774219922
input archive log thread=1 sequence=4 recid=109 stamp=774219923
input archive log thread=1 sequence=5 recid=110 stamp=774219925
input archive log thread=1 sequence=6 recid=111 stamp=774220406
input archive log thread=1 sequence=7 recid=112 stamp=774220406
channel c1: starting piece 1 at 02-FEB-12
channel c1: finished piece 1 at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/arch_DBPROD_774220407_1_02_02_2012_774220407 tag=BKP_ARCHIVELOG comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_1_773532936.arc recid=106 stamp=774219917
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_2_773532936.arc recid=107 stamp=774219918
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_3_773532936.arc recid=108 stamp=774219922
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_4_773532936.arc recid=109 stamp=774219923
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_5_773532936.arc recid=110 stamp=774219925
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_6_773532936.arc recid=111 stamp=774220406
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_7_773532936.arc recid=112 stamp=774220406
Finished backup at 02-FEB-12

Starting backup at 02-FEB-12
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 02-FEB-12
channel c1: finished piece 1 at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/spf_DBPROD_774220409_1_02_02_2012_774220409 tag=BKP_SPFILE comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-FEB-12

Starting Control File and SPFILE Autobackup at 02-FEB-12
piece handle=/orabackup/dbprod/fisico/c-862715809-20120202-01 comment=NONE
Finished Control File and SPFILE Autobackup at 02-FEB-12

released channel: c1

RMAN> exit

Recovery Manager complete.
[oracle@serveroracle oraarchive]$

Vamos verificar os arquivos de backup gerados pelo Backup Full executado.

[oracle@serveroracle oraarchive]$ cd ..
[oracle@serveroracle dbprod]$ cd fisico/
[oracle@serveroracle fisico]$ ls -ltr
total 866220
-rw-r----- 1 oracle oinstall 262635520 Jan 25 21:54 full_DBPROD_773531494_1_25_01_2012_773531494
-rw-r----- 1 oracle oinstall 161652736 Jan 25 21:55 full_DBPROD_773531680_1_25_01_2012_773531680
-rw-r----- 1 oracle oinstall   5808128 Jan 25 21:55 full_DBPROD_773531745_1_25_01_2012_773531745
-rw-r----- 1 oracle oinstall   1046016 Jan 25 21:55 arch_DBPROD_773531758_1_25_01_2012_773531758
-rw-r----- 1 oracle oinstall   7438336 Jan 25 22:16 c-862715809-20120125-0b
-rw-r----- 1 oracle oinstall 262635520 Feb  2 21:12 full_DBPROD_774220188_1_02_02_2012_774220188
-rw-r----- 1 oracle oinstall 161652736 Feb  2 21:13 full_DBPROD_774220344_1_02_02_2012_774220344
-rw-r----- 1 oracle oinstall   5808128 Feb  2 21:13 full_DBPROD_774220400_1_02_02_2012_774220400
-rw-r----- 1 oracle oinstall   1130496 Feb  2 21:13 ctlf_DBPROD_774220403_1_02_02_2012_774220403
-rw-r----- 1 oracle oinstall   7438336 Feb  2 21:13 c-862715809-20120202-00
-rw-r----- 1 oracle oinstall   1292288 Feb  2 21:13 arch_DBPROD_774220407_1_02_02_2012_774220407
-rw-r----- 1 oracle oinstall     98304 Feb  2 21:13 spf_DBPROD_774220409_1_02_02_2012_774220409
-rw-r----- 1 oracle oinstall   7438336 Feb  2 21:13 c-862715809-20120202-01
[oracle@serveroracle fisico]$ exit
exit

Vamos desligar o Banco de Dados e criar um PFILE do SPFILE corrente.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create pfile from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 10g Release 10.2.0.5.0 - Production
[oracle@serveroracle ~]$

Vamos remover os arquivos do Banco de Dados Oracle.

[oracle@serveroracle ~]$ cd /oraprd01/oradata/dbprod/
[oracle@serveroracle dbprod]$ ls -ltr
total 104576
-rw-r----- 1 oracle oinstall 106962944 Feb  2 21:21 users03.dbf
[oracle@serveroracle dbprod]$ rm *
[oracle@serveroracle dbprod]$ cd /oraprd02/oradata/dbprod/
[oracle@serveroracle dbprod]$ ls -ltr
total 2934848
-rw-r----- 1 oracle oinstall   20979712 Jan 25 22:15 temp01.dbf
-rw-r----- 1 oracle oinstall   83886592 Feb  2 21:13 redo003.log
-rw-r----- 1 oracle oinstall   83886592 Feb  2 21:13 redo001.log
-rw-r----- 1 oracle oinstall  211820544 Feb  2 21:21 users02.dbf
-rw-r----- 1 oracle oinstall  110108672 Feb  2 21:21 users01.dbf
-rw-r----- 1 oracle oinstall 1242570752 Feb  2 21:21 undotbs01.dbf
-rw-r----- 1 oracle oinstall  566239232 Feb  2 21:21 system01.dbf
-rw-r----- 1 oracle oinstall  367009792 Feb  2 21:21 sysaux01.dbf
-rw-r----- 1 oracle oinstall   83886592 Feb  2 21:21 redo002.log
-rw-r----- 1 oracle oinstall   41951232 Feb  2 21:21 master.dbf
-rw-r----- 1 oracle oinstall   10493952 Feb  2 21:21 files_index01.dbf
-rw-r----- 1 oracle oinstall  178266112 Feb  2 21:21 files01.dbf
-rw-r----- 1 oracle oinstall    7356416 Feb  2 21:21 control03.ctl
-rw-r----- 1 oracle oinstall    7356416 Feb  2 21:21 control02.ctl
-rw-r----- 1 oracle oinstall    7356416 Feb  2 21:21 control01.ctl
[oracle@serveroracle dbprod]$ rm *
[oracle@serveroracle dbprod]$ cd /oraprd01/app/oracle/product/10.2.0/db_1/dbs/
[oracle@serveroracle dbs]$ ls -ltr
total 7264
-rw-r----- 1 oracle oinstall    8385 Sep 11  1998 init.ora
-rw-r--r-- 1 oracle oinstall   12920 May  3  2001 initdw.ora
-rw-r----- 1 oracle oinstall      24 Oct  3 19:15 lkORCL
-rw-r----- 1 oracle oinstall    1536 Oct  3 19:17 orapworcl
-rw-rw---- 1 oracle oinstall    1544 Oct  3 19:58 hc_orcl.dat
-rw-r----- 1 oracle oinstall      56 Oct  4 08:28 alert_orcl.log
-rw-rw---- 1 oracle oinstall      24 Oct  4 09:10 lkDBPROD
-rw-r----- 1 oracle oinstall    1536 Dec 16 09:44 orapwdbprod
-rw-r----- 1 oracle oinstall    3584 Jan 25 21:41 spfiledbprod.ora
-rw-r----- 1 oracle oinstall 7356416 Jan 25 21:56 snapcf_dbprod.f
-rw-rw---- 1 oracle oinstall    1544 Jan 25 21:57 hc_dbprod.dat
-rw-r----- 1 oracle oinstall    1991 Jan 25 21:57 alert_dbprod.log
-rw-r--r-- 1 oracle oinstall    1294 Jan 25 21:58 initdbprod.ora
[oracle@serveroracle dbs]$

Vamos remover também o SPFILE e o PFILE para realizarmos a recuperação do Banco de Dados através do Backup Físico.

[oracle@serveroracle dbs]$ rm spfiledbprod.ora initdbprod.ora

Vamos tentar inciar o Banco de Dados.

[oracle@serveroracle dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 25 21:59:15 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oraprd01/app/oracle/product/10.2.0/db_1/dbs/initdbprod.ora'
SQL> shutdown abort
ORACLE instance shut down.
SQL>

Vamos restaurar o SPFILE do Backup Físico.

[oracle@serveroracle fisico]$ rman target sys/******

Recovery Manager: Release 10.2.0.5.0 - Production on Thu Feb 2 21:30:03 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN>

Vamos forçar a inicialização da instância com a opção “force” pois não temos nem o SPFILE e nem o PFILE disponível.
Quando o SPFILE não é disponível, RMAN inicia a instância com um arquivo de parâmetro “dummy”.

RMAN> startup force nomount;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oraprd01/app/oracle/product/10.2.0/db_1/dbs/initdbprod.ora'

starting Oracle instance without parameter file for retrival of spfile
Oracle instance started

Total System Global Area     159383552 bytes

Fixed Size                     1272552 bytes
Variable Size                 58721560 bytes
Database Buffers              96468992 bytes
Redo Buffers                   2920448 bytes

RMAN>

Vamos restaurar o SPFILE.

RMAN> restore spfile from '/orabackup/dbprod/fisico/spf_DBPROD_774220409_1_02_02_2012_774220409';

Starting restore at 02-FEB-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK

channel ORA_DISK_1: autobackup found: /orabackup/dbprod/fisico/spf_DBPROD_774220409_1_02_02_2012_774220409
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 02-FEB-12

RMAN> exit


Recovery Manager complete.
[oracle@serveroracle fisico]$

Vamos verificar o SPFILE restaurado.

[oracle@serveroracle fisico]$ cd /oraprd01/app/oracle/product/10.2.0/db_1/dbs/
[oracle@serveroracle dbs]$ ls -ltr
total 7260
-rw-r----- 1 oracle oinstall    8385 Sep 11  1998 init.ora
-rw-r--r-- 1 oracle oinstall   12920 May  3  2001 initdw.ora
-rw-r----- 1 oracle oinstall      24 Oct  3 19:15 lkORCL
-rw-r----- 1 oracle oinstall    1536 Oct  3 19:17 orapworcl
-rw-rw---- 1 oracle oinstall    1544 Oct  3 19:58 hc_orcl.dat
-rw-r----- 1 oracle oinstall      56 Oct  4 08:28 alert_orcl.log
-rw-rw---- 1 oracle oinstall      24 Oct  4 09:10 lkDBPROD
-rw-r----- 1 oracle oinstall    1536 Dec 16 09:44 orapwdbprod
-rw-r----- 1 oracle oinstall 7356416 Feb  2 21:13 snapcf_dbprod.f
-rw-r----- 1 oracle oinstall    2467 Feb  2 21:32 alert_dbprod.log
-rw-rw---- 1 oracle oinstall    1544 Feb  2 21:32 hc_dbprod.dat
-rw-r----- 1 oracle oinstall    3584 Feb  2 21:36 spfiledbprod.ora

Vamos iniciar a instância com o SPFILE restaurado com a opção “nomount”.

[oracle@serveroracle dbs]$ sqlplus sys/***** as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Feb 2 21:39:31 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.5.0 - Production

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  1277824 bytes
Variable Size             545259648 bytes
Database Buffers          524288000 bytes
Redo Buffers                2916352 bytes
SQL>

Vamos conectar novamente no RMAN para restaurar o controlfile.

[oracle@serveroracle dbs]$ rman target sys/******

Recovery Manager: Release 10.2.0.5.0 - Production on Thu Feb 2 21:42:08 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: dbprod (not mounted)

RMAN> restore controlfile from '/orabackup/dbprod/fisico/ctlf_DBPROD_774220403_1_02_02_2012_774220403';

Starting restore at 02-FEB-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/oraprd02/oradata/dbprod/control01.ctl
output filename=/oraprd02/oradata/dbprod/control02.ctl
output filename=/oraprd02/oradata/dbprod/control03.ctl
Finished restore at 02-FEB-12

RMAN>

Após restaurar o controlfile do Backup Físico vamos montar o Banco de Dados.

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN>

Após montado o Banco de Dados vamos restaurar e recuperar o Banco de Dados do Backup Físico.

RMAN> run {
2> restore database;
3> recover database;
4> }

Starting restore at 02-FEB-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oraprd02/oradata/dbprod/system01.dbf
restoring datafile 00002 to /oraprd02/oradata/dbprod/undotbs01.dbf
restoring datafile 00003 to /oraprd02/oradata/dbprod/sysaux01.dbf
restoring datafile 00005 to /oraprd02/oradata/dbprod/users02.dbf
restoring datafile 00006 to /oraprd01/oradata/dbprod/users03.dbf
channel ORA_DISK_1: reading from backup piece /orabackup/dbprod/fisico/full_DBPROD_774220188_1_02_02_2012_774220188
channel ORA_DISK_1: restored backup piece 1
piece handle=/orabackup/dbprod/fisico/full_DBPROD_774220188_1_02_02_2012_774220188 tag=BKP_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /oraprd02/oradata/dbprod/users01.dbf
restoring datafile 00007 to /oraprd02/oradata/dbprod/files01.dbf
restoring datafile 00008 to /oraprd02/oradata/dbprod/files_index01.dbf
channel ORA_DISK_1: reading from backup piece /orabackup/dbprod/fisico/full_DBPROD_774220344_1_02_02_2012_774220344
channel ORA_DISK_1: restored backup piece 1
piece handle=/orabackup/dbprod/fisico/full_DBPROD_774220344_1_02_02_2012_774220344 tag=BKP_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00009 to /oraprd02/oradata/dbprod/master.dbf
channel ORA_DISK_1: reading from backup piece /orabackup/dbprod/fisico/full_DBPROD_774220400_1_02_02_2012_774220400
channel ORA_DISK_1: restored backup piece 1
piece handle=/orabackup/dbprod/fisico/full_DBPROD_774220400_1_02_02_2012_774220400 tag=BKP_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 02-FEB-12

Starting recover at 02-FEB-12
using channel ORA_DISK_1

starting media recovery

unable to find archive log
archive log thread=1 sequence=6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/02/2012 21:48:41
RMAN-06054: media recovery requesting unknown log: thread 1 seq 6 lowscn 2212010

RMAN>

O erro ocorrido acima foi devido a falta da restauração dos archivelogs da seqüência 6.
Vamos catalogar o diretório das peças de Backup para realizarmos o restore dos archivelogs.

RMAN> catalog start with '/orabackup/dbprod/fisico/';

searching for all files that match the pattern /orabackup/dbprod/fisico/

List of Files Unknown to the Database
=====================================
File Name: /orabackup/dbprod/fisico/c-862715809-20120202-01
File Name: /orabackup/dbprod/fisico/ctlf_DBPROD_774220403_1_02_02_2012_774220403
File Name: /orabackup/dbprod/fisico/c-862715809-20120202-00
File Name: /orabackup/dbprod/fisico/spf_DBPROD_774220409_1_02_02_2012_774220409
File Name: /orabackup/dbprod/fisico/arch_DBPROD_774220407_1_02_02_2012_774220407

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /orabackup/dbprod/fisico/c-862715809-20120202-01
File Name: /orabackup/dbprod/fisico/ctlf_DBPROD_774220403_1_02_02_2012_774220403
File Name: /orabackup/dbprod/fisico/c-862715809-20120202-00
File Name: /orabackup/dbprod/fisico/spf_DBPROD_774220409_1_02_02_2012_774220409
File Name: /orabackup/dbprod/fisico/arch_DBPROD_774220407_1_02_02_2012_774220407

RMAN>

Depois do diretório das peças de Backup catalogado no RMAN, vamos restaurar os archivelogs e fazer novamente o recover do Banco de Dados.
Vamos restaurar o archivelog da seqüência 6 e recuperar o Banco de Dados.

RMAN> run {
2> restore archivelog from sequence 6 thread 1;
3> recover database;
4> }

Starting restore at 02-FEB-12
using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=6
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=7
channel ORA_DISK_1: reading from backup piece /orabackup/dbprod/fisico/arch_DBPROD_774220407_1_02_02_2012_774220407
channel ORA_DISK_1: restored backup piece 1
piece handle=/orabackup/dbprod/fisico/arch_DBPROD_774220407_1_02_02_2012_774220407 tag=BKP_ARCHIVELOG
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 02-FEB-12

Starting recover at 02-FEB-12
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 6 is already on disk as file /orabackup/dbprod/oraarchive/dbprod_1_6_773532936.arc
archive log thread 1 sequence 7 is already on disk as file /orabackup/dbprod/oraarchive/dbprod_1_7_773532936.arc
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_6_773532936.arc thread=1 sequence=6
archive log filename=/orabackup/dbprod/oraarchive/dbprod_1_7_773532936.arc thread=1 sequence=7
unable to find archive log
archive log thread=1 sequence=8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/02/2012 21:50:59
RMAN-06054: media recovery requesting unknown log: thread 1 seq 8 lowscn 2212117

RMAN>

O erro ocorrido acima foi devido a falta do archivelog da seqüência 8, porém não há o archivelog desta seqüência conforme abaixo.
Vamos abrir o Banco de Dados com a opção “resetlogs”.
Porque abrir o Banco de Dados com a opção de RESETLOGS?
Porque como houve restauração e recuperação completa do Banco de Dados através do um backup do “controlfile’, isso gera uma nova incarnação do Banco de Dados.

RMAN>  alter database open resetlogs;

database opened

RMAN> exit

Recovery Manager complete.
[oracle@serveroracle dbs]$

[oracle@serveroracle dbs]$ cd /orabackup/dbprod/oraarchive/
[oracle@serveroracle oraarchive]$ ls -ltr
total 48
-rw-r----- 1 oracle oinstall  1024 Feb  2 21:50 dbprod_1_7_773532936.arc
-rw-r----- 1 oracle oinstall 41472 Feb  2 21:50 dbprod_1_6_773532936.arc
[oracle@serveroracle oraarchive]$
[oracle@serveroracle dbs]$ exit
exit

Vamos criar o PFILE do SPFILE restaurado.

SQL> create pfile from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 10g Release 10.2.0.5.0 - Production
[oracle@serveroracle dbs]$

Vamos verificar os arquivos do Banco de Dados após a restauração e recuperação do mesmo.

[oracle@serveroracle dbs]$ ls -ltr
total 7264
-rw-r----- 1 oracle oinstall    8385 Sep 11  1998 init.ora
-rw-r--r-- 1 oracle oinstall   12920 May  3  2001 initdw.ora
-rw-r----- 1 oracle oinstall      24 Oct  3 19:15 lkORCL
-rw-r----- 1 oracle oinstall    1536 Oct  3 19:17 orapworcl
-rw-rw---- 1 oracle oinstall    1544 Oct  3 19:58 hc_orcl.dat
-rw-r----- 1 oracle oinstall      56 Oct  4 08:28 alert_orcl.log
-rw-rw---- 1 oracle oinstall      24 Oct  4 09:10 lkDBPROD
-rw-r----- 1 oracle oinstall    1536 Dec 16 09:44 orapwdbprod
-rw-r----- 1 oracle oinstall    2524 Feb  2 21:40 alert_dbprod.log
-rw-r----- 1 oracle oinstall    3584 Feb  2 21:43 spfiledbprod.ora
-rw-rw---- 1 oracle oinstall    1544 Feb  2 21:52 hc_dbprod.dat
-rw-r----- 1 oracle oinstall 7356416 Feb  2 21:53 snapcf_dbprod.f
-rw-r--r-- 1 oracle oinstall    1294 Feb  2 21:55 initdbprod.ora
[oracle@serveroracle dbs]$ ls -ltr /oraprd02/oradata/dbprod/
total 2934848
-rw-r----- 1 oracle oinstall  211820544 Feb  2 21:52 users02.dbf
-rw-r----- 1 oracle oinstall  110108672 Feb  2 21:52 users01.dbf
-rw-r----- 1 oracle oinstall 1242570752 Feb  2 21:52 undotbs01.dbf
-rw-r----- 1 oracle oinstall  566239232 Feb  2 21:52 system01.dbf
-rw-r----- 1 oracle oinstall  367009792 Feb  2 21:52 sysaux01.dbf
-rw-r----- 1 oracle oinstall   83886592 Feb  2 21:52 redo003.log
-rw-r----- 1 oracle oinstall   83886592 Feb  2 21:52 redo002.log
-rw-r----- 1 oracle oinstall   41951232 Feb  2 21:52 master.dbf
-rw-r----- 1 oracle oinstall   10493952 Feb  2 21:52 files_index01.dbf
-rw-r----- 1 oracle oinstall  178266112 Feb  2 21:52 files01.dbf
-rw-r----- 1 oracle oinstall   20979712 Feb  2 21:52 temp01.dbf
-rw-r----- 1 oracle oinstall   83886592 Feb  2 21:54 redo001.log
-rw-r----- 1 oracle oinstall    7356416 Feb  2 21:54 control03.ctl
-rw-r----- 1 oracle oinstall    7356416 Feb  2 21:54 control02.ctl
-rw-r----- 1 oracle oinstall    7356416 Feb  2 21:54 control01.ctl
[oracle@serveroracle dbs]$ ls -ltr /oraprd01/oradata/dbprod/
total 104564
-rw-r----- 1 oracle oinstall 106962944 Feb  2 21:52 users03.dbf
[oracle@serveroracle dbs]$

Vamos desligar o nosso Banco de Dados.

[oracle@serveroracle ~]$ . desliga_serveroracle.sh

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Feb 2 22:17:58 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.5.0 - Production

Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 10g Release 10.2.0.5.0 - Production

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 02-FEB-2012 22:18:32

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.104)(PORT=1521)))
The command completed successfully
[oracle@serveroracle ~]$

Pronto recuperamos o Banco de Dados através do Backup Físico do RMAN.
Mais informações veja na Documentação Oficial da Oracle. Oracle Documentation

Autor: Maycon Tomiasi

Formado em Tecnologia da Informação na FIPP (Faculdade de Informática de Presidente Prudente), Analista DBA Oracle pela Teiko Soluções em Tecnologia da Informação, residente em Blumenau/ SC, Certificado OCP 10g/11g/12c, OCS 11g Implementation, OCE 11g Performance Tuning, OCE 11g RAC & GRID e OPN Specialist. Conhecimentos em PHP.

Recuperando Banco de Dados Oracle com RMAN non-ASM

Autor: Maycon Tomiasi

Deixe um comentário Cancelar resposta

:: Entrar

:: Categorias

:: Social

:: Tweets

:: Entrar

:: Blogroll