RMAN> startup force mount ;
RMAN> restore database until SCN 1124691;
Starting restore at 20-FEB-13 09:10:51
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=233 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=241 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to +BIG_DATA/db1dup/datafile/sysaux.261.807722585
channel ORA_DISK_1: restoring datafile 00003 to +BIG_DATA/db1dup/datafile/undotbs1.259.807722585
channel ORA_DISK_1: reading from backup piece +FRA/db1dup/backupset/2013_02_20/nnndf0_tag20130220t085117_0.378.807871885
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to +BIG_DATA/db1dup/datafile/system.260.807722583
channel ORA_DISK_2: restoring datafile 00004 to +BIG_DATA/db1dup/datafile/hh_test.258.807871839
channel ORA_DISK_2: reading from backup piece +FRA/db1dup/backupset/2013_02_20/nnndf0_tag20130220t085117_0.380.807871889
channel ORA_DISK_2: piece handle=+FRA/db1dup/backupset/2013_02_20/nnndf0_tag20130220t085117_0.380.807871889 tag=TAG20130220T085117
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:25
channel ORA_DISK_1: piece handle=+FRA/db1dup/backupset/2013_02_20/nnndf0_tag20130220t085117_0.378.807871885 tag=TAG20130220T085117
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 20-FEB-13 09:11:36
RMAN> recover database until SCN 1124691;
Starting recover at 20-FEB-13 09:12:13
using channel ORA_DISK_1
using channel ORA_DISK_2
starting media recovery
archived log for thread 1 with sequence 7 is already on disk as file +FRA/db1dup/archivelog/2013_02_20/thread_1_seq_7.384.807872009
archived log for thread 1 with sequence 8 is already on disk as file +FRA/db1dup/archivelog/2013_02_20/thread_1_seq_8.385.807872055
archived log for thread 1 with sequence 9 is already on disk as file +FRA/db1dup/archivelog/2013_02_20/thread_1_seq_9.386.807872157
archived log for thread 1 with sequence 10 is already on disk as file +FRA/db1dup/archivelog/2013_02_20/thread_1_seq_10.387.807872661
archived log for thread 1 with sequence 11 is already on disk as file +FRA/db1dup/archivelog/2013_02_20/thread_1_seq_11.388.807872771
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=6
channel ORA_DISK_1: reading from backup piece +FRA/db1dup/backupset/2013_02_20/annnf0_tag20130220t085146_0.383.807871911
channel ORA_DISK_1: piece handle=+FRA/db1dup/backupset/2013_02_20/annnf0_tag20130220t085146_0.383.807871911 tag=TAG20130220T085146
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+FRA/db1dup/archivelog/2013_02_20/thread_1_seq_6.390.807873167 thread=1 sequence=6
channel default: deleting archived log(s)
archived log file name=+FRA/db1dup/archivelog/2013_02_20/thread_1_seq_6.390.807873167 RECID=86 STAMP=807873167
archived log file name=+FRA/db1dup/archivelog/2013_02_20/thread_1_seq_7.384.807872009 thread=1 sequence=7
archived log file name=+FRA/db1dup/archivelog/2013_02_20/thread_1_seq_8.385.807872055 thread=1 sequence=8
archived log file name=+FRA/db1dup/archivelog/2013_02_20/thread_1_seq_9.386.807872157 thread=1 sequence=9
archived log file name=+FRA/db1dup/archivelog/2013_02_20/thread_1_seq_10.387.807872661 thread=1 sequence=10
media recovery complete, elapsed time: 00:00:08
Finished recover at 20-FEB-13 09:12:55
RMAN> alter database open resetlogs;
database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete