Q

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?

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 last published in July 2005

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close