Tuesday 8 October 2013

How to check block corruption in oracle;

 dbv

[oracle@adcp ~]$ dbv

DBVERIFY: Release 11.2.0.1.0 - Production on Tue Oct 8 11:56:03 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Keyword     Description                    (Default)
----------------------------------------------------
FILE        File to Verify                 (NONE)
START       Start Block                    (First Block of File)
END         End Block                      (Last Block of File)
BLOCKSIZE   Logical Block Size             (8192)
LOGFILE     Output Log                     (NONE)
FEEDBACK    Display Progress               (0)
PARFILE     Parameter File                 (NONE)
USERID      Username/Password              (NONE)
SEGMENT_ID  Segment ID (tsn.relfile.block) (NONE)
HIGH_SCN    Highest Block SCN To Verify    (NONE)
            (scn_wrap.scn_base OR scn) 

 

[oracle@adcp ~]$ dbv file='/oracle_data/u01/app/oracle/product/11.2.0/db_1/adcp/users01.dbf'

DBVERIFY: Release 11.2.0.1.0 - Production on Tue Oct 8 11:56:13 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /oracle_data/u01/app/oracle/product/11.2.0/db_1/adcp/users01.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 4194302
Total Pages Processed (Data) : 2585414
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 420235
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 46888
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 1141765
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 105994890 (0.105994890)
[oracle@adcp ~]$


DBMS_REPAIR: CHECK_OBJECT: This option check block corruption for a particular table or index. It not only detects block corruption but also suggests repair options.
DB_VERIFY: It detects block corruption for a database which is in offline mode.
ANALYZE TABLE: This command is used with VALIDATE STRUCTURE option to analyze the structure of index, table or cluster. It confirm with message if the structure of object is ok and show error message if corruption is detected.
DB_BLOCK_CHECKING:

No comments:

Post a Comment