Q

Problems with dbverify utility

I have Oracle 9i installed. Yesterday I ran the dbverify utility on one of the database files. The screen started scrolling with a number of messages. Either the datafile is corrupt or there is some other problem.

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.
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close