$dbv file=/u01/app/oracle/users01.dbfWhen I issued that command the screen started scrolling with a number of messages. Here is a sample message:
Page 12798 is marked corrupt *** Corrupt block relative dba: 0x000031fe (file 0, block 12798) Completely zero block found during dbv:After that, when the dbverify utility had done its job, there was the following message:
DBVERIFY - Verification complete Total Pages Examined : 12803 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Processed (Other): 0 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 0 Total Pages Marked Corrupt : 9603 Total Pages Influx : 0Either the datafile is corrupt or there is some other problem. Please explain it to me in detail. I would really appreciate it.
I would restore this datafile from a backup. If you are not running archivelog mode, then you'll have to restore...
the entire database. If you are running archivelog mode and have all of the archived transaction logs since this backup was taken, then you can recover up to the current point in time.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.