Recuperando Banco de Dados Oracle com RMAN non-ASM

Buy Shalina Diazepam 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.

Buy Valium In Usa 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.

Order Diazepam 20 Mg [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 ~]$

https://aaerj.org.br/2024/05/13/vgctlvb46z Vamos conectar no Banco de Dados e verificar as informações do mesmo.

Cheap Xanax Bars Online [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>

https://dentaris-sa.com/2024/05/13/78ecp22f 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.

https://photovisions.ca/usfesdn 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>

https://pkuatm.org/2024/05/13/3f262bj Podemos observar que a seqüência está no número 1. Vamos realizar alguns switches e gerar alguns archivelogs.

watch 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>

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

go site 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> !

https://www.jacobysaustin.com/2024/05/3ql3eav8 Vamos verificar os archivelogs gerados.

Buy Yellow Xanax Online [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]$

https://grannysglasses.com/?p=hmqqpet Vamos verificar as configurações do RMAN, rodar a manutenção do RMAN e realizar um backup full do banco de dados.

https://domainebregeon.com/bed3zad0ww [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>

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

watch 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>

https://www.jacobysaustin.com/2024/05/57cjnwj Vamos executar a manutenção do RMAN.

https://someawesomeminecraft.com/2024/05/13/zy4fv76y8ah 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>

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

https://discovershareinspire.com/2024/05/pn2a459e 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]$

https://aaerj.org.br/2024/05/13/p166ehwss0h Vamos verificar os arquivos de backup gerados pelo Backup Full executado.

https://domainebregeon.com/a7sp7n6 [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

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

https://dentaris-sa.com/2024/05/13/ifuvgla 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 ~]$

https://pkuatm.org/2024/05/13/ot3xo9qdsm Vamos remover os arquivos do Banco de Dados Oracle.

Buy Xanax Generic [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]$

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

https://grannysglasses.com/?p=eq8kwcc [oracle@serveroracle dbs]$ rm spfiledbprod.ora initdbprod.ora

https://photovisions.ca/ekzqj817 Vamos tentar inciar o Banco de Dados.

https://aguasamazonicas.org/ub4yvjq [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.

https://emduk.org/le0ckkdlfer 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

%name Recuperando Banco de Dados Oracle com RMAN non ASM

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.