Restore until scn and recover to perform complete recovery

(1) Taking the backuppiece with checkpoint scn 1484619 to restore database from.

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
217     Full    643.52M    DISK        00:01:31     22-may-2014 05:20:03
        BP Key: 248   Status: AVAILABLE  Compressed: NO  Tag: TAG20140522T051830
        Piece Name: +DATA/cvrman/backupset/2014_05_22/nnndf0_tag20140522t051830_0.313.848207917
  List of Datafiles in backup set 217
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 1484619    22-may-2014 05:18:32 +DATA/cvrman/datafile/system.256.847354793
  4       Full 1484619    22-may-2014 05:18:32 +DATA/cvrman/datafile/users.259.847354795

(2) Restore database..until scn 1484619
restore database until scn 1484619;

 restore database until scn 1484619;

Starting restore at 22-may-2014 12:26:15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=27 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=23 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=22 device type=DISK
flashing back control file to SCN 1484619

skipping datafile 1; already restored to file +DATA/cvrman/datafile/system.256.847354793
skipping datafile 4; already restored to file +DATA/cvrman/datafile/users.259.847354795
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 00003 to +DATA/cvrman/datafile/undotbs1.318.848201233
channel ORA_DISK_1: restoring datafile 00005 to +DATA/cvrman/datafile/example_new.dbf
channel ORA_DISK_1: reading from backup piece /SHARED/backup1/9hp8grvi_1_1
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 00002 to +DATA/cvrman/datafile/sysaux.257.847354793
channel ORA_DISK_2: restoring datafile 00006 to +DATA/cvrman/datafile/tbs1_new.dbf
channel ORA_DISK_2: reading from backup piece /SHARED/backup1/9gp8grvi_1_1
channel ORA_DISK_1: piece handle=/SHARED/backup1/9hp8grvi_1_1 tag=KEEP_SYS_180
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_DISK_2: piece handle=/SHARED/backup1/9gp8grvi_1_1 tag=KEEP_SYS_180
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:26
Finished restore at 22-may-2014 12:26:51

(3) Recover database

RMAN> recover database;

Starting recover at 22-may-2014 12:38:29
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5

starting media recovery

archived log for thread 1 with sequence 5 is already on disk as file +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_5.312.847802453
archived log for thread 1 with sequence 6 is already on disk as file +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.332.847836579
archived log for thread 1 with sequence 7 is already on disk as file +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_7.288.847857575
archived log for thread 1 with sequence 8 is already on disk as file +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_8.306.847862997
archived log for thread 1 with sequence 9 is already on disk as file +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_9.326.847862997
archived log for thread 1 with sequence 10 is already on disk as file +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_10.300.847862997
archived log for thread 1 with sequence 1 is already on disk as file +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_1.302.847882835
archived log for thread 1 with sequence 2 is already on disk as file +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_2.277.847923139
archived log for thread 1 with sequence 3 is already on disk as file +DATA/cvrman/archivelog/2014_05_19/thread_1_seq_3.303.848008895
archived log for thread 1 with sequence 4 is already on disk as file +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_4.305.848051929
archived log for thread 1 with sequence 5 is already on disk as file +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331
archived log for thread 1 with sequence 6 is already on disk as file +DATA/cvrman/archivelog/2014_05_21/thread_1_seq_6.274.848152857
archived log for thread 1 with sequence 7 is already on disk as file +DATA/cvrman/archivelog/2014_05_21/thread_1_seq_7.278.848181757
archived log for thread 1 with sequence 8 is already on disk as file +DATA/cvrman/archivelog/2014_05_22/thread_1_seq_8.344.848215595
archived log for thread 1 with sequence 9 is already on disk as file +DATA/cvrman/onlinelog/group_3.266.847355299
archived log file name=+DATA/cvrman/archivelog/2014_05_17/thread_1_seq_5.312.847802453 thread=1 sequence=5
archived log file name=+DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.332.847836579 thread=1 sequence=6
archived log file name=+DATA/cvrman/archivelog/2014_05_18/thread_1_seq_7.288.847857575 thread=1 sequence=7
archived log file name=+DATA/cvrman/archivelog/2014_05_18/thread_1_seq_8.306.847862997 thread=1 sequence=8
archived log file name=+DATA/cvrman/archivelog/2014_05_18/thread_1_seq_9.326.847862997 thread=1 sequence=9
archived log file name=+DATA/cvrman/archivelog/2014_05_18/thread_1_seq_10.300.847862997 thread=1 sequence=10
archived log file name=+DATA/cvrman/archivelog/2014_05_18/thread_1_seq_1.302.847882835 thread=1 sequence=1
archived log file name=+DATA/cvrman/archivelog/2014_05_18/thread_1_seq_2.277.847923139 thread=1 sequence=2
archived log file name=+DATA/cvrman/archivelog/2014_05_19/thread_1_seq_3.303.848008895 thread=1 sequence=3
archived log file name=+DATA/cvrman/archivelog/2014_05_20/thread_1_seq_4.305.848051929 thread=1 sequence=4
archived log file name=+DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331 thread=1 sequence=5
archived log file name=+DATA/cvrman/archivelog/2014_05_21/thread_1_seq_6.274.848152857 thread=1 sequence=6
media recovery complete, elapsed time: 00:00:52
Finished recover at 22-may-2014 12:39:26

(4) Open the database

RMAN> sql "alter database open";

sql statement: alter database open