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;...