Preview the restore operation

1.Preview supports 3 modes namely

     (a) normal
    (b) summary
    (c) recall


(a) Normal mode:-

restore tablespace example
from tag="KEEP_SYS_180"
preview ;

output:-

RMAN> restore tablespace example
2> from tag="KEEP_SYS_180"
3> preview ;

Starting restore at 21-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=59 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=54 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=49 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=30 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=50 device type=DISK


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
190     Full    70.30M     DISK        00:01:11     17-MAY-14
        BP Key: 221   Status: AVAILABLE  Compressed: NO  Tag: KEEP_SYS_180
        Piece Name: /SHARED/backup1/9hp8grvi_1_1
        Keep: BACKUP_LOGS        Until: 13-NOV-14
  List of Datafiles in backup set 190
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1246246    17-MAY-14 +DATA/cvrman/datafile/example.308.847525493
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

List of Archived Log Copies for database with db_unique_name CVRMAN
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
82      1    5       A 17-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_5.312.847802453

83      1    6       A 17-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.332.847836579

85      1    7       A 17-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_7.288.847857575

95      1    8       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_8.306.847862997

96      1    9       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_9.326.847862997

94      1    10      A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_10.300.847862997

97      1    1       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_1.302.847882835

98      1    2       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_2.277.847923139

99      1    3       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_19/thread_1_seq_3.303.848008895

100     1    4       A 19-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_4.305.848051929

101     1    5       A 20-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331

Media recovery start SCN is 1246246
Recovery must be done beyond SCN 1246246 to clear datafile fuzziness
Finished restore at 21-MAY-14

(b) summary mode:

restore tablespace example
from tag="KEEP_SYS_180"
preview summary;

output:-

RMAN> restore tablespace example
from tag="KEEP_SYS_180"
preview summary;2> 3>

Starting restore at 21-MAY-14
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


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
190     B  F  A DISK        17-MAY-14       1       1       NO         KEEP_SYS_180

List of Archived Log Copies for database with db_unique_name CVRMAN
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
82      1    5       A 17-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_5.312.847802453

83      1    6       A 17-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.332.847836579

85      1    7       A 17-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_7.288.847857575

95      1    8       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_8.306.847862997

96      1    9       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_9.326.847862997

94      1    10      A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_10.300.847862997

97      1    1       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_1.302.847882835

98      1    2       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_2.277.847923139

99      1    3       A 18-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_19/thread_1_seq_3.303.848008895

100     1    4       A 19-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_4.305.848051929

101     1    5       A 20-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331

Media recovery start SCN is 1246246
Recovery must be done beyond SCN 1246246 to clear datafile fuzziness
Finished restore at 21-MAY-14

(3) Recall mode:- It is used only for restoring from remote storage.