% rman target=sys/sys@DB2DUP catalog=rman/rman@rman
Recovery Manager: Release 11.2.0.3.0 – Production on Fri Feb 22 16:26:03 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DB2DUP (DBID=3523769914)
connected to recovery catalog database
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> restore controlfile;
Starting restore at 22-FEB-13 16:27:40
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /zpool_tmp/DB_BACKUP/ora_df808071817_s23_s1
channel ORA_DISK_1: piece handle=/zpool_tmp/DB_BACKUP/ora_df808071817_s23_s1 tag=TAG20130222T162316
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/ora112/oradata/DB2DUP/control01.ctl
Finished restore at 22-FEB-13 16:27:48
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> recover database;
Starting recover at 22-FEB-13 16:28:31
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK
starting media recovery
archived log for thread 1 with sequence 6 is already on disk as file /u01/app/ora112/oradata/DB2DUP/redo03a.log
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/redo03a.log thread=1 sequence=6
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:29:14
RMAN> alter database open resetlogs;
database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete