database recovery environment:
China Unicom Hainan branch information platform, HP-UX minicomputer;
ORACLE database, volume file system is VxFS.
North Asia Data Recovery - ORACLE Data Recovery
Database Fault & Analysis:
Engineer mistakenly RMed the important ORACLE database and lost all data tables, UNDO, LOG, etc.
After consultation with the North Asian database data recovery engineer team, the user provided two sets of ORACLE database recovery solutions:
Solution 1: Analyze the regularity of the file system and rebuild the nodes of specific files. Reproduce the original file attributes (name, location, size, etc.).
Solution 2: According to the structural characteristics of the ORACLE database itself, conduct regular analysis and summary of the entire disk, and restore all ORACLE data tables, LOGs and UNDO files. Since the ORACLE database table header describes the name and size of the table in the ORACLE environment, the table name problem can also be solved.
North Asia Data Recovery - ORACLE Data Recovery
Data Recovery Process:
1, Data Recovery Engineer remotely logs in to the HP-UX system, performs DD operations on the failed volume, and outputs it to another volume.
2. Transfer to the WINDOWS platform through FTP, and express the destination disk to our data recovery center.
3. Implementation Plan 1. Using North Asia's independently developed data recovery software, successfully analyze all other file node tables except UNDO1, and extract all files according to the nodes.
4. Implementation Plan 2. All files were successfully restored. After excluding UNDO1, compared with the plan. As a result, 1 byte of data recovered by this plan was not bad. Based on this result, we can judge that except UNDO1, the other files are correct.
5. Because UNDO1 does not affect the data, and it should be correct according to the conclusion of the plan 1, data recovery has been completed at this step.
6. Assist the user to restore all recovered database data to the prepared HP-UX system, successfully start the service, and the data is intact.
North Asia Data Recovery - ORACLE Data Recovery
Data Security Tips:
UNIX and LINUX should be deleted as soon as possible after accidentally deleting it. It is best to turn off the device directly, and then do other operations after DD.