本文介绍如何利用Oracle的DBVERIFY工具来检测不同类型的Oracle数据文件中的物理坏块问题，包括普通数据文件、裸设备上的数据文件、ASM管理的数据文件及特定段的数据文件。
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)
扫一扫
1741
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
