Monday, January 16, 2012

How to Validate the Restore of Backups

RESTORE VALIDATE and VALIDATE BACKUPSET commands check whether you can restore from your backups.

---------------------------------------------------------
Examples:

RESTORE CONTROLFILE VALIDATE;
RESTORE TABLESPACE SYSTEM VALIDATE;
RESTORE ARCHIVELOG ALL VALIDATE;
---------------------------------------------------------
---------------------------------------------------------
Examples:

VALIDATE BACKUPSET 1121,1122;
---------------------------------------------------------

No comments:

Post a Comment