Use RESTORE... PREVIEW when planning your restore and recovery operation, to ensure that all required backups are available

RESTORE... PREVIEW

Creates a detailed report of every backup to be used in the requested RESTORE operation. Some examples are;

RMAN> RESTORE DATABASE PREVIEW;
RMAN> RESTORE TABLESPACE users PREVIEW;
RMAN> RESTORE DATAFILE 3 PREVIEW;
RMAN> RESTORE ARCHIVELOG FROM LOGSEQ 200 PREVIEW;
RMAN> RESTORE ARCHIVELOG FROM TIME 'SYSDATE-7' PREVIEW;
RMAN> RESTORE ARCHIVELOG FROM SCN 234546 PREVIEW

RESTORE... PREVIEW output is in the same format as the output of the LIST command.

RESTORE... PREVIEW SUMMARY

Use the RESTORE... PREVIEW SUMMARY option to suppress much of the detail.

RMAN> RESTORE DATABASE PREVIEW SUMMARY;
RMAN> RESTORE TABLESPACE users PREVIEW SUMMARY;
RMAN> RESTORE DATAFILE 3 PREVIEW SUMMARY;
RMAN> RESTORE ARCHIVELOG FROM SCN 234546 PREVIEW SUMMARY

RESTORE... PREVIEW output is in the same format as the output of the LIST command.

RESTORE... PREVIEW RECALL

RESTORE... PREVIEW RECALL can be used with any RESTORE operation, in cases a restore fails due to a needed backup being stored remotely.

RMAN> restore archivelog ALL preview;

The "List of remote backup files" at the end of the output identifies the backups that are stored remotely. In such a case, using RESTOREARCHIVELOG ALL PREVIEW RECALL initiates recall for the remote backups

RMAN> restore archivelog ALL preview recall;

You can append RECALL to any RESTORE... PREVIEW command, as in these examples:

RMAN> RESTORE TABLESPACE users PREVIEW RECALL;
RMAN> RESTORE DATAFILE 3 PREVIEW RECALL;
Go to top
JSN Boot template designed by JoomlaShine.com