LIDATE BACKUPSET 命令。在验证期间检测到的所有问题都会显示出来，这些问题进而会启动故障评估。如果检测到故障，则该故障会作为查找结果记录到ADR 中。可以使用LIST FAILURE命令查看资料档案库中记录的所有故障。 VALIDATE 命令支持对单个备份集和数据块进行验证。在物理损坏中，数据库根本无法识别块。在逻辑损坏中，块的内容在逻辑上不一致。默认情况下，VALIDATE 命令只检查物理损坏。也可以指定CHECK LOGICAL 检查逻辑损坏。
块损坏可分为块间损坏和块内损坏。在块内损坏中，块本身发生损坏，可以是物理损坏也可以是逻辑损坏。在块间损坏中，块与块之间发生的损坏只能是逻辑损坏。VALIDATE 命令只检查块内损坏。 示例 RMAN>
validate database; Starting validate at 21-DEC-06 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:15 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 1 OK 0 13168 85760 981642 File Name: /u01/app/oracle/oradata/orcl/system01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 60619 Index 0 9558 Other 0 2415 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 2 OK 0 22892 66720 981662 File Name: /u01/app/oracle/oradata/orcl/sysaux01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 10529 Index 0 9465 Other 0 23834
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 3 OK 0 104 7680 981662 File Name: /u01/app/oracle/oradata/orcl/undotbs01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 7576 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 4 OK 0 24 640 963835 File Name: /u01/app/oracle/oradata/orcl/users01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 43 Index 0 63 Other 0 510 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 5 OK 0 1732 12800 745885 File Name: /u01/app/oracle/oradata/orcl/example01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 4416 Index 0 1303 Other 0 5349 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation including current control file for validation including current SPFILE in backup set channel ORA_DISK_1: validation complete, elapsed time: 00:00:01 List of Control File and SPFILE =============================== File Type Status Blocks Failing Blocks Examined ------------ ------ -------------- --------------- SPFILE OK 0 2 Control File OK 0 594 Finished validate at 21-DEC-06 RMAN>
设置检测损坏的参数
设置检测损坏的参数 可以使用DB_ULTRA_SAFE 参数来简化管理。它会影响下列参数的默认值： DB_BLOCK_CHECKING，用于启动对数据库块的检查。此检查通常可防止内存和数据损坏。（默认值：FALSE，建议值：FULL） DB_BLOCK_CHECKSUM，将每个数据块写入到磁盘时，在其高速缓存标头中 |