Shita software successfully restored a large number of bad core databases for an electric power company.

Shita software successfully restored a large number of bad core databases for an electric power company. A large number of FRACTURED blocks were broken and damaged after accidental power outages, and the database does not have any form of backup. SQLselect * fromv $ database_block_corruption; FILE # BLOCK # BLOCKSCORRUPTION_CHANGE # CORRUPT

Shita software successfully restored a large number of bad core databases for an electric power company. A large number of FRACTURED blocks were broken and damaged after accidental power outages, and the database does not have any form of backup. SQL select * from v $ database_block_corruption; FILE # BLOCK # BLOCKS corrcorruption_change # CORRUPT

Shita software successfully restored a large number of bad core databases for an electric power company. A large number of FRACTURED blocks were broken and damaged after accidental power outages, and the database does not have any form of backup.

SQL> select * from v$database_block_corruption;     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO                   ---------- ---------- ---------- ------------------ ---------                            1       3119          1                  0 FRACTURED                            1     142239          1                  0 FRACTURED                            1      11567          1                  0 FRACTURED                            1      79919          1                  0 FRACTURED                            1      87535          1                  0 FRACTURED                            1      88447          1                  0 FRACTURED                            1      89871          1                  0 FRACTURED                            1      89999          1                  0 FRACTURED                            1      91295          1                  0 FRACTURED                            1      93631          1                  0 FRACTURED                            1      94383          1                  0 FRACTURED                        FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO                   ---------- ---------- ---------- ------------------ ---------                            1      94639          1                  0 FRACTURED                            1      96799          1                  0 FRACTURED                            1      96895          1                  0 FRACTURED                            1      97647          1                  0 FRACTURED                            1     108671          1                  0 FRACTURED                            1     108863          1                  0 FRACTURED                            1     110927          1                  0 FRACTURED                            1     128095          1                  0 FRACTURED                            1     134751          1                  0 FRACTURED                            1     139423          1                  0 FRACTURED                            1     139471          1                  0 FRACTURED 

The number of damaged FRACTURED blocks is about 20 thousand, and there are hundreds of Bad blocks on FILE #, that is, system. dbf.
Shi tan software engineer Biot. Wang opened the database through the Patch data dictionary and restored the vast majority of data. Database damage caused by storage power failure or other exceptions is the primary cause of such failure in the past few years, even with restrictions, you should still consider taking at least some long-cycle backup behaviors, such as logical backup or backing up specific important tables. In this example, the PRM-DUL recovery tool is not used because the database is successfully opened and most of the data is exp.

Latest PRM-DUL: http://parnassusdata.com/sites/default/files/ParnassusData_PRMForOracle_3206.zip

Free PRM-DUL License: http://www.parnassusdata.com/zh-hans/node/122?

Related posts:

1. Understand the Ora-19566 encountered by RMAN
2. Fractured block found during backing up datafile
3. 11g new features recover upload uption list
4. The software helped an e-commerce company recover the damaged ASM Diskgroup.
5. Shita software successfully used PRM to restore more than 10 million tables for a Southwest China telecom operator
6. PRM-parnassusdata recovery manager For Oracle Database Manual

Original article address: Shi tan software successfully restored a large number of bad core databases for an electric power company. Thanks to the original author for sharing.