Problem solve Get help with specific problems with your technologies, process and projects.

Help! Corruption in data files

We did a transfer of data from an old to new server, and after we few days we found some corruption in some data files, like /oracle/sapdata4/btabd_9/btabd.data9. Now the users are unable to use some transaction for some materials, it is giving error message:

"DB_RSQL-SQL_ERROR" SQL error 8103 occurred when accessing table "RSDB"

After this error we run the DBverify to check the corruption and we found more than 4 data files corrupted. After we checked all the data files we found only two tables (TST03 and RSDB) affected in all data files. We cannot restore the data from the backup because we cannot find how long the data is okay in backup tapes.

Table TST03 is a table used by TemSe (Output Management). You can easily truncate it on Oracle level without using vital business data. You can also truncate it from within transaction SP12. Table RSDB is used in material management. I would try to export the table, re-create it and import the data again. I'm not sure that it will work, but I fear that it's the only option left.
This was last published in June 2005

Dig Deeper on SAP Basis administration and NetWeaver administration

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.