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

This article mainly introduces "what is the recovery process of oracle database damage". In daily operation, I believe that many people have doubts about the recovery process of oracle database damage. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "what is the recovery process of oracle database damage?" Next, please follow the editor to study!

Fault description

The storage space of the whole server is composed of 6 SAS hard drives, of which 5 make up a RAID5 array, and the remaining 1 is used as a hot spare. Due to the failure of one hard disk in the RAID5 array, the hot spare in the server storage was activated successfully, and another hard disk failed in the process of synchronization, which led to the paralysis of the RAID5 array, the failure of the upper LUN and the crash of the server. The server data recovery engineer and the hardware data recovery engineer detect the customer storage at the same time and find that there is a physical fault in the hard disk in the server storage.

Second, server storage data recovery fault detection

The LUN stored by the IBM server is based on the RAID group, so the server data recovery needs to first analyze the information of the underlying RAID group, and then reconstruct the original RAID group according to the analyzed information. After analyzing each data disk, it is found that the data of one disk is different from that of other data disks, and it is considered that it may be a HotSpare disk. Then analyze other data disks, analyze the distribution of Oracle database pages in each disk, and get the important information of RAID group, such as stripe size, disk order and data direction, according to the data distribution.

In the server data recovery, because the LUN is based on the RAID group, it is necessary to virtualize the latest status of the RAID group according to the information analyzed above. Then analyze the distribution of LUN in the RAID group, and the data block MAP allocated by LUN for server data recovery. Therefore, it is only necessary to extract the block distribution MAP of LUN. Then the corresponding program is written according to these information, the data of LUN is parsed by MAP, and then the data of LUN is exported according to the data MAP.

III. Implementation plan for storage data recovery

1. Implementation plan 1

The LUN containing Oracle database in the restored server storage is parsed by JFS2 file system, and the incomplete file system is repaired manually. Use the self-developed JFS2 file system parsing tool to parse the restored LUN, then restore all the Oracle database files in the file system, and check whether the Oracle database files are complete.

Scan all the disks by scanning Oracle fragments for the database files with bad blocks, and combine the scanned data pages, and then manually fill and repair the database files with bad blocks.

After recovering all the Oracle databases, it is found that the application SAP can not be used normally, because some important data of the SAP application are also stored in the damaged storage, and if these data are missing, the SAP can not be used normally even if the database is complete, so it is necessary to adopt the second scheme to recover all the important data of SAP.

2. Implementation plan 2

All the LUN in the restored server storage is parsed by the file system, and the data LUN containing the SAP is checked for file system consistency. Repair the incomplete parts of the file system manually, and finally restore all SAP and SAP Test data. In this server data recovery case, due to the large number of SAP directories and data, the recovery process is more responsible.

Use professional means to detect the SAP data and repair the damaged data to ensure that all SAP data recovered are complete, so as to ensure that the SAP application can be started completely.

Then, using the recovered SAP data combined with the previously restored database, you can start SAP and all applications.

Start and repair Oracle data and SAP applications

1. Start the database and repair

Restore the recovered database files to the established environment and try to start the database. During the startup process, the database failed to start due to inconsistent verification of some temporary files in the database, and then coordinate our Oracle database experts to repair the database remotely. After a long time of repair, there is no problem with database startup, all users and all tables in the database are complete, and then try to start SAP.

2. Start SAP and repair

Restore the recovered SAP file to the built environment, and start SAP according to the previous startup script. After that, SAP starts normally, but the user rights and usage in SAP are not normal, and SAP does not have a serial number. It is initially suspected that the registration file of SAP may not be restored, re-examine the recovery process and check for steps that may be negligent. As a result, some files are not recovered because of the corruption of the file system, and the file system is repaired and the data is restored. After that, it is normal to start SAP and to use it.

5. The data stored on the server has been successfully restored.

With the cooperation of the user, start the Oracle database in the user server, start the SAP, and verify the integrity of all the data in the SAP through the SAP client. The most effective verification result is the complete recovery of the data, the SAP can be used normally, and the data stored on the server is restored successfully.

At this point, the study on "what is the recovery process of oracle database damage" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.