Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do when opening the Times due to bad block damage in the database file. I hope you will get something after reading this article. Let's discuss it together.

Fault description

The main manifestation of the failure is an error opening the database, which reads: "system01.dbf needs more recovery to maintain consistency, and the database cannot be opened." After testing the database file, we can draw the following conclusions: there are bad blocks in sysaux01.dbf and the sysaux01.dbf file is damaged. There is an urgent need to recover the data under zxfg users.

Malfunction analysis

The main reasons for the above errors are control file damage, data file corruption, SCN inconsistency between data file and control file, and so on. After further detection and analysis of the database file, we found that there are bad blocks in the sysaux01.dbf file. After repairing the number and starting the database, there are still many query errors, export and data pump tools can not be used, query alarm log, analysis error, this is due to sysaux file damage, resulting in appeal errors. The database cannot be repaired at the database level. The data files of system and user tablespaces are normal, and the underlying parsed data files can be used to recover user data.

Detection and recovery

1 use DBV to detect data files

Figure 1:

The analysis results show that 40 pages of SYSAUX01.DBF file data block (Data) failed, 29 pages of index page (Index) failed, and other files were detected normally.

2 repair the database and open the database

Figure 2:

Figure 3:

3 query database reported error, export and data pump reported error

Figure 4:

Figure 5:

Make various attempts and consult a large amount of data. This internal error in the database cannot be fixed by command.

4 low-level parsing to import ZXFG user's data into the new database

Figure 6:

Figure 6:

Result

The underlying layer parses the database file, imports the data of zxfg users into the new database, and completely recovers the data needed by the user.

After reading this article, I believe you have a certain understanding of "what to do when opening the Times due to bad block damage in the database file". If you want to know more about it, welcome to follow the industry information channel, thank you for your reading!

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.