Oracle database based data recovery method

Abstract

The present invention discloses an Oracle database based data recovery method comprising the following steps: S1: determining a data table of a database; S2: obtaining all the information of the table; S3: obtaining a recorded logical structural relationship; S4: obtaining specific information of fields; S5: obtaining logical structural features of data recovery ; and S6: composing data into the form of the the data table, and extracting the data. The present invention has the following beneficial effects: the records and fields in the data table are parsed by virtue of an Oracle database structure, the head of each record and the structure division data of the fields are found and then are extracted, the data recovery efficiency is high, the data destruction and the data discontinuous fragment level database can also be normally extracted and recovered, the data recovery success rate is high, and the loss caused by database damages is effectively reduced.

Description

technical field [0001] The invention relates to the technical field of information security, in particular to a data recovery method based on an Oracle database. Background technique [0002] OracleDatabase, also known as OracleRDBMS, or Oracle for short. It is a relational database management system developed by Oracle Corporation. It is a product that has always been in a leading position in the database field. It can be said that the Oracle database system is currently a popular relational database management system in the world. The system has good portability, convenient use, and strong functions, and is suitable for various large, medium, small, and microcomputer environments. It is a high-efficiency, reliable and high-throughput database solution; a database contains various components, including tables, views, stored procedures, records, fields, indexes, etc. [0003] However, database failures sometimes occur, resulting in inaccessible data. The common reasons fo...

AI Technical Summary

Problems solved by technology

[0003] However, database failures sometimes occur, resulting in inaccessible data. Among them, the common reasons for database corruption are as follows: Transaction log problems

For example, the transaction log file is lost; the transaction log file is deleted by mistake during the operation; The database is shut down abnormally while being read and written; the table of the database is damaged or the index is damaged, or other objects of the database are damaged or lost; the data file is deleted or its name is changed; the hard disk is damaged, causing data and Log file read and write errors, etc.; some of these errors can be handled by the database itself through disaster recovery mechanisms to ensure normal data access, but for database table damage, database deletion, or data file deletion, the database itself cannot be repaired at this time. A special method is needed to solve these problems. Most of the solutions are to restore the lost database files, and then restore the records. However, if the files are stored in fragments, there are some methods to restore the database on the market. In this case, it is necessary to use the method of recording characteristics to complete data recovery, so as to preserve the integrity of key data to the greatest extent.

Images