RMAN> startup force nomount
Oracle instance started
Total System Global Area 3541934080 bytes
Fixed Size 2164392 bytes
Variable Size 2483034456 bytes
Database Buffers 1040187392 bytes
Redo Buffers 16547840 bytes
RMAN> set dbid 3523769914
executing command: SET DBID
database name is “DB2DUP” and DBID is 3523769914
RMAN> set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/zpool_tmp/DB_BACKUP/autobackup_%F’;
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
RMAN> restore controlfile from autobackup;
Starting restore at 22-FEB-13 16:08:59
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130222
channel ORA_DISK_1: AUTOBACKUP found: /zpool_tmp/DB_BACKUP/autobackup_c-3523769914-20130222-00
channel ORA_DISK_1: restoring control file from AUTOBACKUP /zpool_tmp/DB_BACKUP/autobackup_c-3523769914-20130222-00
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/u01/app/ora112/oradata/DB2DUP/control01.ctl
Finished restore at 22-FEB-13 16:09:05
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> recover database;
Starting recover at 22-FEB-13 16:11:03
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK
starting media recovery
archived log for thread 1 with sequence 7 is already on disk as file /u01/app/ora112/oradata/DB2DUP/redo01a.log
archived log file name=/u01/app/ora112/oradata/DB2DUP/redo01a.log thread=1 sequence=7
media recovery complete, elapsed time: 00:00:02
Finished recover at 22-FEB-13 16:11:47
RMAN> alter database open resetlogs;
database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete