Oracle DBVERIFY Command

DBVERIFY is an external command-line utility that performs a physical data structure integrity check. It can be used on offline or online databases, as well on backup files. You use DBVERIFY primarily when you need to ensure that a backup database (or datafile) is valid before it is restored, or as a diagnostic aid when you have encountered data corruption problems.

Because DBVERIFY can be run against an offline database, integrity checks are significantly faster.

dbv help=yes


dbv file='D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF' blocksize=8192



DBVERIFY: Release 9.2.0.1.0 - Production on Thu Jan 1 15:13:45 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE =

D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF



DBV-00200: Block, dba 4245143, already marked corrupted



DBVERIFY - Verification complete



Total Pages Examined : 55040

Total Pages Processed (Data) : 38573

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 4901

Total Pages Failing (Index): 0

Total Pages Processed (Other): 1631

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 9935

Total Pages Marked Corrupt : 0

Total Pages Influx : 0