I have Oracle 9i installed on my Sun SPARC machine. Yesterday I ran the dbverify utility on one of the database files:
$dbv file=/u01/app/oracle/users01.dbf
When 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           : 0
Either the datafile is corrupt or there is some other problem. Please explain it to me in detail. I would really appreciate it.

    Requires Free Membership to View

Oracle's dbverify utility has determined that 9,603 blocks of the 12,803-block datafile are corrupt. This is not good. While you may be able to start your database, accessing data stored in these blocks will probably give you an error.

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.

This was first published in October 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: