oracle: DBVERIFY检测数据文件

dbv可以用来检测数据文件的物理坏块问题.

1.检测数据文件

[oracle@test1 ~]$ dbv file=/dbdata/oradata/orcl11r2/users01.dbf 

DBVERIFY: Release 11.2.0.3.0 - Production on Fri Jun 15 10:45:40 2018

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

DBVERIFY - Verification starting : FILE = /dbdata/oradata/orcl11r2/users01.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 269760
Total Pages Processed (Data) : 219408
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 8798
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 3011
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 38543
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 2491979 (0.2491979)

2.检查裸设备的数据文件

[oracle@test1 ~]$ dbv file=/tmp/link_raw1.dbf end=12544

DBVERIFY: Release 11.2.0.3.0 - Production on Fri Jun 15 10:50:00 2018

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

DBVERIFY - Verification starting : FILE = /tmp/link_raw1.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 12544
Total Pages Processed (Data) : 504
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 60
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 137
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 11843
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 2491979 (0.2491979)

3.检查asm的数据文件

[oracle@test2 ~]$ dbv file=+DATA1/rac11g/datafile/example.672.972330799 userid=system/oracle

DBVERIFY: Release 11.2.0.3.0 - Production on Fri Jun 15 10:51:37 2018

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

DBVERIFY - Verification starting : FILE = +DATA1/rac11g/datafile/example.672.972330799


DBVERIFY - Verification complete

Total Pages Examined         : 44240
Total Pages Processed (Data) : 6594
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 1148
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 2841
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 33657
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 0 (0.0)
---最大的block scn为什么是0 ???

4.检查特定的段

SQL> select t.ts#, s.header_file, s.header_block from v$tablespace t, dba_segments s where s.segment_name='T1' and t.name = s.tablespace_name;

       TS# HEADER_FILE HEADER_BLOCK
---------- ----------- ------------
	 4	     4	       1802
[oracle@test1 ~]$ dbv userid=test/test SEGMENT_ID=4.4.1802

DBVERIFY: Release 11.2.0.3.0 - Production on Fri Jun 15 10:59:23 2018

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

DBVERIFY - Verification starting : SEGMENT_ID = 4.4.1802


DBVERIFY - Verification complete

Total Pages Examined         : 1152
Total Pages Processed (Data) : 1126
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 25
Total Pages Processed (Seg)  : 1
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 0
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 2491928 (0.2491928)