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

Introduction: HP DL380 server three 300GSAS hard drives, disk failure caused the entire RAID group paralysis, one of the hard disk status light is red. The database is stored in partition D and the backup is stored in partition E. Storage failure, resulting in the D partition can not be identified, E partition can be identified, but copy the backup file reported an error, and restart the server, resulting in the first offline hard disk online, and synchronized for a period of time, directly forced shutdown without synchronization completed, and then did not move the server.

Solution:

1. In order to ensure the security of the data in the existing disk, first make a read-only mirror backup of the disk, three hard disks can be read normally, no bad paths are found, and only read the mirror backup log.

Figure 1:

2. Analyze the backup image files in detail, reorganize the raid structure, and perform XOR verification. Some of the checks pass. After the offline hard disk is online, the synchronization operation will damage the data, and the partial pass means that the data is damaged.

Figure 2:

3. In the process of RAID analysis, try to extract data from various hard drives offline, and the data extracted from each disk is the same.

Figure 3:

Figure 4:

Figure 5:

Figure 6:

4. Firstly, analyze and repair the dat file in E partition. Both backup files were found to be corrupted

Figure 7:

5. Analyze the aggregated dat fragments to verify the integrity of the dat data, and the underlying structure shows damage.

Figure 8:

6. At the same time, analyze and scan the data files of D partition. Due to storage synchronization, the data file directory is not visible.

7. Scan the free space data page of partition D, and analyze and aggregate the file fragments.

8. Verify the integrity and validity of data file fragments.

9. Extract the data from the backup file and record it into the new database.

10. Connect the database through the upper application to verify the data availability, the database file can be loaded normally, the user account in the upper application software is normal, and the normal data query can be carried out.

Conclusion:

During the recovery process, 2 backup files of SealLib databases were found on disk E. However, a small part of the page structure in the backup file data is damaged, and more continuous data fragments are found in the results of the D partition scan, and the fragments are available. Through the integration and splicing of D partition fragments and E partition backup files. The final repair of the parsed data can support the normal use of the whole application, and the upper application can query the database content normally.

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.