Kbase P11728: Faulty hardware caused corruption and all backups have the same corruption
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/03/2005 |
|
Status: Verified
SYMPTOM(s):
SYSTEM ERROR: Attempt to read block 12117760 which does not exist. (210)
SYSTEM ERROR: Incomplete microtransaction. (2255)
All available backups have the same corruption.
Running dbrpr and idxcheck failed to identify all the corruption.
CAUSE:
Faulty hardware.
FIX:
Replace the bad hardware and clean up the corrupt database.
All tables in this database have a unique transaction number field.
Steps followed in this unique case:
1. Dump the tables to identify each table with bad records.
2. Export all the records from any problem table.
3. When it fails, select the next unique number to identify the record.
4. Continue this process until all bad records are identified.
5. Use the idxfix utility to remove the bad records.
6. Once all tables are dumped successfully, rebuild the indexes