12c Oracle 定期验证备份文件

数据库备份大家都知道，正常也会每天都定时备份，但是很少有人去做备份文件的验证。一旦，我们需要使用备份文件，备份文件确实损坏的那就悲催了。定期每个月做一次备份验证是必要的。

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>