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.