Ask the Expert

Data file errors after Windows upgrade

I have migrated R/3 Enterprise with an Oracle 9i database from Windows 2000 to Windows 2003. I have done a routine file system backup/restore and recreated the control file.

I got my database up and running, but with the error: "BLOCK CORRUPTION ERRORS" in some data files. What should I do?

    Requires Free Membership to View

Do the same corruptions occur in the original database? You can use DBVERIFY to verify database consistency. Instead of using a file system backup/restore, you should do the backup/restore using database tools such as RMAN. RMAN reads and writes Oracle blocks. It will report block corruption right away.

Indexes can be easily dropped and re-created. Block corruptions in data is less easy to solve. You might try to export the table, but in most cases, the data in the corrupted blocks is lost. Have a look in OSS NOTE 23345: Consistency check for Oracle and OSS NOTE 36548: Block corruptions.

This was first published in July 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: