12c Oracle periodically validates backup files
Database backup, as we all know, is normally backed up regularly every day, but few people do the verification of backup files. Once we need to use backup files, it is sad that backup files are indeed corrupted. It is necessary to do backup verification regularly once a 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 backup 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 restore 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 backup 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 setchannel 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.arcchannel 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 archived 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 backup 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/bak/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 >
