Database backup Everyone knows that regular backups are scheduled daily, but few people do the verification of backup files. Once we need to use the backup file, the backup file is really damaged and it's sad. It is necessary to do the backup verification periodically every month.
rman> Restore Database validate; Starting restore at 12-jan-2018 21:49:31using channel Ora_disk_1channel ora_disk_1:starting validation of datafile backup Setchannel ora_disk_1:reading from backup Piece/u01/bak/db_fullbk_19_1_965249636.rmnchannel ora_disk_1:piece handle= /U01/BAK/DB_FULLBK_19_1_965249636.RMN tag=backup_fullchannel ora_disk_1:restored BACKUP piece 1channel ORA_DISK_1: Validation complete, elapsed Time:00:00:01channel ora_disk_1:starting validation of datafile backup Setchannel ora_disk_ 1:reading from backup Piece/u01/bak/db_fullbk_18_1_965249636.rmnchannel ora_disk_1:piece handle=/u01/bak/db_fullbk_ 18_1_965249636.RMN tag=backup_fullchannel ora_disk_1:restored BACKUP piece 1channel ora_disk_1:validation complete, Elapsed Time:00:00:35channel ora_disk_1:starting Validation of datafile backup Setchannel ora_disk_1:reading from Backu P Piece/u01/bak/db_fullbk_17_1_965249636.rmnchannel ora_disk_1:piece HANDLE=/U01/BAK/DB_FULLBK_17_1_965249636.RMN Tag=backup_Fullchannel ora_disk_1:restored backup piece 1channel ora_disk_1:validation complete, elapsed time:00:00:55finished Res Tore at 12-jan-2018 21:51:02rman> rman> restore Archivelog from time ' sysdate-1 ' validate; Starting restore at 12-jan-2018 21:59:39using channel Ora_disk_1channel ora_disk_1:starting validation of archived log Ba Ckup Setchannel ora_disk_1:reading from backup Piece/u01/bak/archive_24_1_965249706.arcchannel ora_disk_1:piece Handle=/u01/bak/archive_24_1_965249706.arc Tag=tag20180112t205505channel ora_disk_1:restored backup piece 1channel Ora_disk_1:validation complete, elapsed time:00:00:01channel ora_disk_1:starting validation of archived log backup SetC Hannel ora_disk_1:reading from backup Piece/u01/bak/archive_22_1_965249706.arcchannel ora_disk_1:piece handle=/u01/ Bak/archive_22_1_965249706.arc Tag=tag20180112t205505channel ora_disk_1:restored backup piece 1channel ORA_DISK_1: Validation complete, elapsed Time:00:00:03channel ora_disk_1:starting VAlidation of archived log backup Setchannel ora_disk_1:reading from backup Piece/u01/bak/archive_23_1_965249706.arcchan Nel ora_disk_1:piece handle=/u01/bak/archive_23_1_965249706.arc tag=tag20180112t205505channel ora_disk_1:restored Backup piece 1channel ora_disk_1:validation complete, elapsed time:00:00:03channel ora_disk_1:starting validation of AR chived log backup Setchannel ora_disk_1:reading from backup Piece/u01/bak/archive_21_1_965249706.arcchannel ORA_DISK_1 : Piece Handle=/u01/bak/archive_21_1_965249706.arc tag=tag20180112t205505channel ora_disk_1:restored backup piece 1channel ora_disk_1:validation Complete, elapsed time:00:00:03channel ora_disk_1:starting validation of archived log Ba Ckup Setchannel ora_disk_1:reading from backup Piece/u01/bak/archive_25_1_965249717.arcchannel ora_disk_1:piece Handle=/u01/bak/archive_25_1_965249717.arc Tag=tag20180112t205505channel ora_disk_1:restored backup piece 1channel Ora_disk_1:validation complete, elapsed time:00:00:01channel ora_disk_1:starting Validation of archived log backup Setchannel ora_disk_1:reading from backup Piece/u01/bak /archive_35_1_965253442.arcchannel ora_disk_1:piece Handle=/u01/bak/archive_35_1_965253442.arc tag= Tag20180112t215722channel ora_disk_1:restored backup piece 1channel ora_disk_1:validation complete, elapsed time:00:00 : 00channel ora_disk_1:starting Validation of archived log backup Setchannel ora_disk_1:reading from backup Piece/u01/ba K/archive_34_1_965253442.arcchannel ora_disk_1:piece Handle=/u01/bak/archive_34_1_965253442.arc tag= Tag20180112t215722channel ora_disk_1:restored backup piece 1channel ora_disk_1:validation complete, elapsed time:00:00 : 00Finished restore at 12-jan-2018 21:59:50rman> restore Controlfile validate; Starting restore at 12-jan-2018 21:54:47using channel Ora_disk_1channel ora_disk_1:starting validation of datafile backup Setchannel ora_disk_1:reading from backup piece +datadg/orcl/autobackup/2018_01_12/s_965249725.381.965249727Channel Ora_disk_1:piece handle=+datadg/orcl/autobackup/2018_01_12/s_965249725.381.965249727 tag= Tag20180112t205525channel ora_disk_1:restored backup piece 1channel ora_disk_1:validation complete, elapsed time:00:00 : 01Finished restore at 12-jan-2018 21:54:48rman> restore SPFile validate; Starting restore at 12-jan-2018 21:54:57using channel Ora_disk_1channel ora_disk_1:starting validation of datafile backup Setchannel ora_disk_1:reading from backup piece +datadg/orcl/autobackup/2018_01_12/s_965249725.381.965249727channel Ora_disk_1:piece handle=+datadg/orcl/autobackup/2018_01_12/s_965249725.381.965249727 tag= Tag20180112t205525channel ora_disk_1:restored backup piece 1channel ora_disk_1:validation complete, elapsed time:00:00 : 01Finished Restore at 12-jan-2018 21:54:58rman>
12c Oracle regularly verifies backup files