René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

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.

Links