使用RMAN验证备份的有效性
--验证控制文件和参数文件: RMAN> restore validate controlfile; Starting restore at 22-JUL-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=36 device type=DISK channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_5_1 channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_5_1 tag=TAG20140722T095956 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: validation complete, elapsed time: 00:00:02 Finished restore at 22-JUL-14 RMAN> restore validate spfile; Starting restore at 22-JUL-14 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_6_1 channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_6_1 tag=TAG20140722T095956 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: validation complete, elapsed time: 00:00:02 Finished restore at 22-JUL-14 --验证全备份 一般会很慢 RMAN> restore validate database; Starting restore at 22-JUL-14 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_4_1 channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_4_1 tag=TAG20140722T095956 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: validation complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_3_1 channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_3_1 tag=TAG20140722T095956 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: validation complete, elapsed time: 00:00:15 Finished restore at 22-JUL-14 RMAN>