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:
[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