Sometimes RMAN backup files might get corrupted. Sometimes disk block corruption might happen. So it is better we do validate the database backups more frequently in order to make sure it is recoverable.
The following commands will help us on validating the backups. While executing these commands, we would get the output similar to what we would get when performing an actual backup. If there are no errors displayed in the output, then the RMAN backups are in good condition.
RESTORE DATABASE VALIDATE;
RESTORE ARCHIVELOG ALL VALIDATE;
No comments:
Post a Comment