Examples of preview RMAN restore operation

RMAN> restore archivelog from sequence 1 preview;

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 Archived Log Copies for database with db_unique_name CVRMAN
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
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

Finished restore at 21-MAY-14

RMAN> restore archivelog from time "sysdate-1" preview;

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 Archived Log Copies for database with db_unique_name CVRMAN
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
101     1    5       A 20-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331

Finished restore at 21-MAY-14

2) RMAN> restore archivelog from time "sysdate-1" preview;

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 Archived Log Copies for database with db_unique_name CVRMAN
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
101     1    5       A 20-MAY-14
        Name: +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331

Finished restore at 21-MAY-14

3) restore controlfile from autobackup preview;

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

recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_1: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_21/s_848146051.276.848146053 found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140521
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_2: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_21/s_848146051.276.848146053 found in the recovery area
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20140521
channel ORA_DISK_2: skipped, AUTOBACKUP already found
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_3: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_21/s_848146051.276.848146053 found in the recovery area
channel ORA_DISK_3: looking for AUTOBACKUP on day: 20140521
channel ORA_DISK_3: skipped, AUTOBACKUP already found
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_4: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_21/s_848146051.276.848146053 found in the recovery area
channel ORA_DISK_4: looking for AUTOBACKUP on day: 20140521
channel ORA_DISK_4: skipped, AUTOBACKUP already found
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_5: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_21/s_848146051.276.848146053 found in the recovery area
channel ORA_DISK_5: looking for AUTOBACKUP on day: 20140521
channel ORA_DISK_5: skipped, AUTOBACKUP already found
Finished restore at 21-MAY-14

4.Preview restore database from image copy

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

datafile 5 not processed because file is offline
List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
74      1    A 17-MAY-14       1246558    17-MAY-14
        Name: +DATA/cvrman/datafile/system.314.847802947
        Tag: CPY_DB

73      2    A 17-MAY-14       1246561    17-MAY-14
        Name: +DATA/cvrman/datafile/sysaux.344.847802947
        Tag: CPY_DB

71      3    A 17-MAY-14       1246567    17-MAY-14
        Name: +DATA/cvrman/datafile/undotbs1.342.847802951
        Tag: CPY_DB

78      4    A 18-MAY-14       1246607    17-MAY-14
        Name: +DATA/cvrman/datafile/users.dbf
        Tag: CPY_DB

70      6    A 17-MAY-14       1246570    17-MAY-14
        Name: +DATA/cvrman/datafile/tbs1.341.847802953
        Tag: CPY_DB


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

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
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 1246558
Recovery must be done beyond SCN 1246607 to clear datafile fuzziness
Finished restore at 21-MAY-14