Oracle OCP IZ0-053 Q400(資料塊校驗)

abstractcyj發表於2016-03-10

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部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2055064/,如需轉載,請註明出處,否則將追究法律責任。

相關文章