SQL | ADVANCE SQL | PLSQL | DBA | Linux

Wednesday, 19 July 2017

rman backup validate and restore validate

RMAN BACKUP VALIDATE and RESTORE VALIDATE :-The RMAN BACKUP VALIDATE and RESTORE VALIDATE commands are useful for recovery plan testing.


BACKUP VALIDATE:-BACKUP VALIDATE command reads all of the specified files but does not produce any output files. All of the data blocks in the input files are validated.

RESTORE VALIDATE:-RESTORE VALIDATE command reads all of the backup files that would be needed to restore the specified objects, but the objects are not actually restored to disk. All of the data blocks in the backup files are validated. RESTORE VALIDATE automatically chooses which backup files to restore from. For example, the command RESTORE VALIDATE DATABASE ensures that every file in the database, a valid backup exists, can be read, and contains valid data


Examples:-
1) Check for physical corruption of files to be backed up.
BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

2) Check for physical and logical corruption of files to be backed up.
BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

3) Check for physical corruption of files to be restored.
RESTORE VALIDATE DATABASE;

4) Check for physical and logical corruption of files to be restored.
RESTORE VALIDATE CHECK LOGICAL DATABASE;

RESTORE CONTROLFILE VALIDATE CHECK LOGICAL;

RESTORE DATABASE VALIDATE CHECK LOGICAL;

RESTORE ARCHIVELOG FROM TIME ‘SYSDATE-1’ UNTIL TIME ‘SYSDATE’ validate;

RESTORE CONTROLFILE VALIDATE CHECK LOGICAL;

rman backup validate and restore validate

RMAN BACKUP VALIDATE and RESTORE VALIDATE :-The RMAN BACKUP VALIDATE and RESTORE VALIDATE commands are useful for recovery plan testing. BA...