Wednesday, May 21, 2014

Preview and Validate the RMAN restore operation

1.Preview and Validate the restore operation of a datafile
restore datafile 3 validate 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 Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
71      3    A 17-MAY-14       1246567    17-MAY-14
        Name: +DATA/cvrman/datafile/undotbs1.342.847802951
        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 1246567
Recovery must be done beyond SCN 1246567 to clear datafile fuzziness

channel ORA_DISK_1: scanning datafile copy +DATA/cvrman/datafile/undotbs1.342.847802951
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

channel ORA_DISK_1: scanning archived log +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.332.847836579
channel ORA_DISK_2: scanning archived log +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_7.288.847857575
channel ORA_DISK_3: scanning archived log +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_8.306.847862997
channel ORA_DISK_4: scanning archived log +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_9.326.847862997
channel ORA_DISK_5: scanning archived log +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_10.300.847862997
channel ORA_DISK_3: scanning archived log +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_1.302.847882835
channel ORA_DISK_4: scanning archived log +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_2.277.847923139
channel ORA_DISK_5: scanning archived log +DATA/cvrman/archivelog/2014_05_19/thread_1_seq_3.303.848008895
channel ORA_DISK_2: scanning archived log +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_4.305.848051929
channel ORA_DISK_1: scanning archived log +DATA/cvrman/archivelog/2014_05_20/thread_1_seq_5.272.848095331
Finished restore at 21-MAY-14


No comments: