DBVERIFY is a utility of Oracle , that can be used to perform a physical structure integrity check against database files. Note that the database should be off line before performing a DBVERIFY. But it will work with online data files also,but its not recommended. DBVERIFY is invoked using dbv command.It should be called from ORACLE_HOME/bin directory. To access help on DB_VERIFY type: dbv help=y To perform a simple DBVIRIFY use below command.Output will be written to the dbv.log file. >dbv file=/u01/oracle/product/10.2.0/oradata/orcl/users01.dbf logfile=dbv.log Note that this is only a verification tool to get a idea about data files,whether they are corrupted or not.You'll have to follow other methods to recover corrupted data files. Exmples: dbv example of a datafile with no corruption. (Pages are data blocks) DBVERIFY: Release 11.2.0.2.0 - Production on Tue Mar 13 15:41:47 2012 Copyright (c) 1982, 2009, Oracle and/or its ...
Exploring the intersection of technology and management, I share insights on databases, middleware, applications, and IT strategy to help professionals navigate complex systems with clarity and efficiency.