dbverify Utility

1、check datafile: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=35512.1

(1)

SQL> show parameter db_block_size
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_size                        integer     8192

(2)

SQL> select file#,name,bytes/8912 from v$datafile;
 
     FILE# NAME                                               BYTES/8912
---------- -------------------------------------------------- ----------
         1 /data1/stream/ygzhou01/datafile/system01.dbf       58829.4434
         2 /data1/stream/ygzhou01/datafile/sysaux01.dbf       51769.9102
         3 /data1/stream/ygzhou01/datafile/ygzhou01.dbf       3850387.07
         4 /data1/stream/ygzhou01/datafile/users01.dbf        23531.7774
         5 /data1/stream/ygzhou01/datafile/stream01.dbf       1176.58887
         6 /data1/stream/ygzhou01/datafile/undotbs1.dbf       3186202.66
         7 /data1/stream/ygzhou01/datafile/ygzhou02.dbf         67653.86
         8 /data1/stream/ygzhou01/datafile/block01.dbf        180606.391
         9 /data1/stream/ygzhou01/datafile/block02.dbf        1176.58887
        10 /data1/stream/ygzhou01/datafile/archivelog01.dbf   889501.185
        11 /data1/stream/ygzhou01/datafile/archivelog02.dbf   838907.864
 
     FILE# NAME                                               BYTES/8912
---------- -------------------------------------------------- ----------
        12 /data1/stream/ygzhou01/datafile/ygzhou03.dbf        1247184.2
 
12 rows selected.

(3)

datafile]$ dbv file=ygzhou01.dbf blocksize=8192 logfile=ygzhou.log feedback=500000

(4)

[oracle@swhagral6db02 datafile]$ strings ygzhou.log
DBVERIFY: Release 11.2.0.2.0 - Production on Mon Mar 5 16:34:49 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
DBVERIFY - Verification starting : FILE = /data1/stream/ygzhou01/datafile/ygzhou01.dbf
DBVERIFY - Verification complete
Total Pages Examined         : 4188800
Total Pages Processed (Data) : 733215
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 718674
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 10649
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 2726262
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 22430714 (0.22430714)
[oracle@swhagral6db02 datafile]$

 

2、check object or segment: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=139962.1

(1)

SQL> select t.ts#, s.header_file, s.header_block from v$tablespace t, dba_segments s where s.segment_name='DBVCHECK' and t.name = s.tablespace_name;
 
       TS# HEADER_FILE HEADER_BLOCK
---------- ----------- ------------
         7           3       456737

(2)

[oracle@swhagral6db02 ygzhou01]$ dbv userid=ygzhou/ygzhou segment_id=7.3.456737
 
DBVERIFY: Release 11.2.0.2.0 - Production on Mon Mar 5 16:50:38 2012
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
DBVERIFY - Verification starting : SEGMENT_ID = 7.3.456737
 
 
DBVERIFY - Verification complete
 
Total Pages Examined         : 64512
Total Pages Processed (Data) : 29598
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 30592
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 225
Total Pages Processed (Seg)  : 1
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 4096
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 15631271 (0.15631271)
[oracle@swhagral6db02 ygzhou01]$