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 first published in June 2005