Recovering database past controlfile SCN
Scenario Restore the database and recover up to the last available archived log sequence.Auto Controlfile backup is generated before sometime disaster happened (lost all controlfiles, datafiles and redologfiles).After the autobackup of controlfile generation there had been few archive logs generated but not backed up. Steps Restore the controlfile Restore the datafiles Catalogue the archived logs manually of which controlfile is not aware of recover the database open the database with resetlogs Connect to rman and set dbid RMAN> restore controlfile from '/u02/bkp/TESTCLONE/bkpcontrl_c-1057140170-20130324-01' Starting restore at 25-MAR-2013 14:32:10 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=358 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u04/oracle/TESTclonedata/cntrl01.dbf output file name=/u04/oracle/TESTclonedata/cntrl02