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

fault description

The failure is mainly manifested as an error when opening the database, which reads: "system01.dbf needs more recovery to maintain consistency, the database cannot be opened." After checking the database file, the following preliminary conclusions can be drawn: sysaux01.dbf has bad blocks, sysaux01.dbf file is damaged. Urgent need to recover zxfg user data.

fault analysis

The possible reasons for the above errors are mainly control file damage, data file damage, data file and control file SCN inconsistency. Further inspection and analysis of the database file revealed that sysaux01.dbf file had bad blocks. 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 errors, this is due to sysaux file corruption, resulting in appeal errors. No database can be repaired at the database level. System and user table space data files are normal, you can use the underlying parsing data file to recover user data.

detection and recovery

1 Using DBV to detect data files

Figure 1:

The analysis results show that SYSAUX01.DBF file data block (Data) detection failed 40 pages, index page (Index) detection failed 29 pages, other files detection is normal.

2 Repair database, open database

Figure 2:

Figure 3:

3 Query database error, export and data pump error

Figure 4:

Figure 5:

Various attempts were made and a large amount of information was consulted. This internal error in the database cannot be fixed by command.

4 Low-level parsing, importing ZXFG user data into a new database

Figure 6:

Figure 7:

results

Parse the database file at the bottom, import the zxfg user data into the new database, completely restore the data required by the user, and restore 100% of the data.

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.