400.Which of the following methods can be used to detect block corruption?
A. ANALYZE operations
B. dbv
C. SQL queries that access the potentially corrupt block
D. RMAN
E. All of the above
Answer: E
http://blog.csdn.net/rlhua/article/details/20620053
比较详尽的示例:
http://blog.csdn.net/seertan/article/details/8501398
另dbv工具例子:
[oracle@db01 log]$ dbv file=/u01/app/oracle/oradata/inst1/users01.dbf
DBVERIFY: Release 11.2.0.4.0 - Production on Thu Mar 10 16:00:51 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/inst1/users01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 640
Total Pages Processed (Data) : 91
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 39
Total Pages Failing (Index): 0
Total Pages Processed (Other): 492
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 18
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 958468 (0.958468)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2055064/ ,如需转载,请注明出处,否则将追究法律责任。