dbv检查数据文件是否有坏块

环境:

OS:Centos 7

DB:11.2.0.4

1.ASM磁盘需要带上userid参数

[oracle@rac01 ~]$ dbv file='+DATA/slnngk/datafile/users.259.1146388217' userid=oracle/oracle

DBVERIFY: Release 11.2.0.4.0 - Production on Wed Sep 13 14:49:15 2023

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

DBVERIFY - Verification starting : FILE = +DATA/slnngk/datafile/users.259.1146388217


DBVERIFY - Verification complete

Total Pages Examined         : 640
Total Pages Processed (Data) : 15
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 2
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 590
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 33
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 0 (0.0)

2.普通文件系统

[oracle@ora11g ~]$ dbv file=/u01/app/oracle/oradata/ora11g/tps_hxl01.dbf

DBVERIFY: Release 11.2.0.4.0 - Production on Wed Sep 13 06:51:37 2023

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

DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/ora11g/tps_hxl01.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 177920
Total Pages Processed (Data) : 143365
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 15260
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1162
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 18133
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 2972329 (0.2972329)