|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
dbverify is the database file verification utility. The executable is named
dbv file=foo_bar_df01.dbf blocksize=8192
Specifically, dbv checks for the following
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.