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

Data recovery failure description: open oracle database error "system01.dbf needs more recovery to maintain consistency, the database cannot be opened". The engineer inspected the database file and found that there were bad blocks in sysaux01.dbf and the sysaux01.dbf file was corrupted. The database does not have a backup and cannot be restored through backup. The customer has provided all the files in the database oraclehome directory and urgently needs to recover the data under the zxfg user.

Oracle database failure analysis: "system01.dbf needs more recovery to maintain consistency", which may be control file corruption, data file corruption, SCN inconsistency between data file and control file, etc. Further detection and analysis of the database file shows that there are bad blocks in the sysaux01.dbf file. After repairing the number and starting the database, many queries reported errors, export and data pump tools could not be used, query alarm logs, analysis of errors, 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 parsing data files can be used to recover user data.

Oracle database detection and data 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 7.

Database data recovery results

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

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.