dbverify [dbv]

dbverify is the database file verification utility. The executable is named dbv.

dbv file=foo_bar_df01.dbf blocksize=8192

Specifically, dbv checks for the following

• A datafile headers
• Correctness of wrapper in db blocks.
• Consistency of table, index and other blocks.

It does not, however, check for index table-rows mismatch. See analyze table ... validate structure cascade instead.

It cannot be used to check the online redo log.

The database needs not be shut down in order to use dbv.

dbms_dbverify.