Shulou(Shulou.com)06/01 Report--

1. Fault performance:

1. The ORACLE database cannot be started or does not work properly.

2. ORACLE ASM storage destruction.

3. The ORACLE data file is missing.

4. The ORACLE data file is partially damaged.

5. ORACLE DUMP file is corrupted.

II. Solutions

◆ detection

1. Detect whether there is a hardware fault, such as a hardware fault, and switch to hardware processing.

2. Check whether the fault performance is the same as the user description in a read-only way

◆ recovery

1. Backup: make a full mirror of the fault storage in a read-only manner (see appendix)

2. Perform data analysis and recovery operations in the backup.

3. Usually, the recovered data will be temporarily stored on another bank.

◆ acceptance

Verify the recovered data and confirm its correctness. If confirmed, pay fee-> hand over original media and recovered data-> issue invoice (receipt) and report.

If the data recovery result can not be recognized, return the original media without service charge, and the report can be issued free of charge.

Third, the possibility of data recovery

The ★ ORACLE database does not start or does not work properly:

If the above faults occur suddenly, the recoverability is usually very high. From the bottom of the technology, if the SYSTEM table is not damaged, the data is easier to recover; if the SYSTEM table is damaged, the data needs to manually check the table structure, which is time-consuming to recover.

★ ORACLE ASM storage corruption:

For example, if the ASM is reset, or some of the equipment members that make up the ASM fail, there is no large amount of new data written after the error, and the data can usually be well recovered.

Missing ★ ORACLE data file:

No matter whether the ORACLE data file is deleted, formatted or lost for unknown reasons, as long as there is no new data write, no matter what operating system it is, the data file can be recovered through the data organization rules within ORACLE, but the name of the data file may need to be checked manually.

★ ORACLE data file is partially corrupted:

For example, if the ORACLE data file is partially damaged (such as overwriting), through complex data extraction and reorganization, the undamaged data records can usually be recovered and new tables can be added, but it will be quite time-consuming.

The ★ ORACLE DUMP file is corrupt:

The ORACLE DUMP file is damaged, the damaged part is removed, and the rest can be appended to the data table normally.

4. Data recovery time

The storage space below 1TB (not the data capacity to be recovered) can usually be completed within 2 working days, and the recovery cycle will usually increase with the increase of storage capacity above 1TB.

If the data table is very large, it will take a lot of time to extract and collate the data, depending on the specific situation.

[database data recovery Tips]

In response to software failures, ★ should minimize storage operations after data loss. Sometimes, even if you turn on the computer and do nothing, it may further aggravate the disaster. If conditions permit, it is best to make a full backup of the disk or storage volume after damage.

For hardware failures, ★ should power up as little as possible after the equipment does not work properly to avoid further damage to the equipment.

How to avoid

Make a good backup plan and avoid single storage backup as much as possible. if the data is very important, you can consider remote backup.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.