RMAN detect corruption

You can validate your database using Oracle Recovery Manager command BACKUP VALIDATE.
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
No backup is created. If there are block corruptions you can find them in the dictionary view
V$DATABASE_BLOCK_CORRUPTION .
By default the execution of “backup validate” only check physical corruption. You must add the
CHECK LOGICAL clause if you want control logical corruption.
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
Oracle Recovery Manager can validate the contents of backup files using the RESTORE VALIDATE ;
this command can be use to control the integrity of your backup.
RMAN> RESTORE DATABASE VALIDATE;
RMAN> RESTORE ARCHIVELOG ALL VALIDATE;
The restore validate simulates the restore command but do not execute it.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *