Recover Database From Db Recovery File Dest
create a dummy init$ORACLE_SID.ora
db_name=PROD db_recovery_file_dest_size=30g db_recovery_file_dest=/u01/app/oracle/frarea
create the folder or mount the disks.
run rman
startup nomount; restore spfile from autobackup; shutdown immediate; startup nomount; restore controlfile from autobackup; alter database mount; restore database; recover database; alter database open resetlogs; change controlfilecopy '/u01/app/oracle/oradata/PROD/disk1/control1.ctl' uncatalog; change controlfilecopy '/u01/app/oracle/oradata/PROD/disk2/control2.ctl' uncatalog; change controlfilecopy '/u01/app/oracle/oradata/PROD/disk3/control3.ctl' uncatalog;
log
$ !rman rman target / nocatalog Recovery Manager: Release 10.2.0.1.0 - Production on Sat Oct 31 23:15:28 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database (not started) RMAN> startup nomount; restore spfile from autobackup; shutdown immediate; startup nomount; restore controlfile from autobackup; alter database mount; restore database; recover database; alter database open resetlogs; change controlfilecopy '/u01/app/oracle/oradata/PROD/disk1/control1.ctl' uncatalog; change controlfilecopy '/u01/app/oracle/oradata/PROD/disk2/control2.ctl' uncatalog; change controlfilecopy '/u01/app/oracle/oradata/PROD/disk3/control3.ctl' uncatalog; Oracle instance started Total System Global Area 171966464 bytes Fixed Size 2019320 bytes Variable Size 113246216 bytes Database Buffers 50331648 bytes Redo Buffers 6369280 bytes RMAN> Starting restore at 31-OCT-09 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=37 devtype=DISK recovery area destination: /u01/app/oracle/frarea database name (or database unique name) used for search: PROD channel ORA_DISK_1: autobackup found in the recovery area channel ORA_DISK_1: autobackup found: /u01/app/oracle/frarea/PROD/autobackup/2009_10_31/o1_mf_s_701737278_5grjshhc_.bkp channel ORA_DISK_1: SPFILE restore from autobackup complete Finished restore at 31-OCT-09 RMAN> Oracle instance shut down RMAN> connected to target database (not started) Oracle instance started Total System Global Area 314572800 bytes Fixed Size 2020416 bytes Variable Size 134220736 bytes Database Buffers 171966464 bytes Redo Buffers 6365184 bytes RMAN> Starting restore at 31-OCT-09 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=37 devtype=DISK recovery area destination: /u01/app/oracle/frarea database name (or database unique name) used for search: PROD channel ORA_DISK_1: autobackup found in the recovery area channel ORA_DISK_1: autobackup found: /u01/app/oracle/frarea/PROD/autobackup/2009_10_31/o1_mf_s_701737278_5grjshhc_.bkp channel ORA_DISK_1: control file restore from autobackup complete output filename=/u01/app/oracle/oradata/PROD/disk1/control1.ctl output filename=/u01/app/oracle/oradata/PROD/disk2/control2.ctl output filename=/u01/app/oracle/oradata/PROD/disk3/control3.ctl Finished restore at 31-OCT-09 RMAN> database mounted released channel: ORA_DISK_1 RMAN> Starting restore at 31-OCT-09 Starting implicit crosscheck backup at 31-OCT-09 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=37 devtype=DISK Crosschecked 5 objects Finished implicit crosscheck backup at 31-OCT-09 Starting implicit crosscheck copy at 31-OCT-09 using channel ORA_DISK_1 Crosschecked 4 objects Finished implicit crosscheck copy at 31-OCT-09 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/app/oracle/frarea/PROD/autobackup/2009_10_31/o1_mf_s_701737278_5grjshhc_.bkp using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/app/oracle/oradata/PROD/disk1/system01.dbf restoring datafile 00002 to /u01/app/oracle/oradata/PROD/disk4/undotbs01.dbf restoring datafile 00003 to /u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf channel ORA_DISK_1: reading from backup piece /u01/app/oracle/frarea/PROD/backupset/2009_10_31/o1_mf_nnnd0_TAG20091031T211025_5grb9lg3_.bkp channel ORA_DISK_1: restored backup piece 1 piece handle=/u01/app/oracle/frarea/PROD/backupset/2009_10_31/o1_mf_nnnd0_TAG20091031T211025_5grb9lg3_.bkp tag=TAG20091031T211025 channel ORA_DISK_1: restore complete, elapsed time: 00:00:25 Finished restore at 31-OCT-09 RMAN> Starting recover at 31-OCT-09 using channel ORA_DISK_1 starting media recovery archive log thread 1 sequence 7 is already on disk as file /u01/app/oracle/frarea/PROD/archivelog/2009_10_31/o1_mf_1_7_5grjs5z7_.arc archive log thread 1 sequence 8 is already on disk as file /u01/app/oracle/frarea/PROD/archivelog/2009_10_31/o1_mf_1_8_5grjs6bm_.arc archive log filename=/u01/app/oracle/frarea/PROD/archivelog/2009_10_31/o1_mf_1_7_5grjs5z7_.arc thread=1 sequence=7 archive log filename=/u01/app/oracle/frarea/PROD/archivelog/2009_10_31/o1_mf_1_8_5grjs6bm_.arc thread=1 sequence=8 unable to find archive log archive log thread=1 sequence=1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/31/2009 23:17:30 RMAN-06054: media recovery requesting unknown log: thread 1 seq 1 lowscn 196420 #comment by author: the error message is not a problem. it just act as "recover database until cancel;". RMAN> database opened RMAN> uncataloged control file copy control file copy filename=/u01/app/oracle/oradata/PROD/disk1/control1.ctl recid=1 stamp=701729697 Uncataloged 1 objects RMAN> uncataloged control file copy control file copy filename=/u01/app/oracle/oradata/PROD/disk2/control2.ctl recid=2 stamp=701729711 Uncataloged 1 objects RMAN> quit Recovery Manager complete.