Oracle ASM Failure Data Recovery

Source: Internet
Author: User

First, fault description

ASM Disk group dropped, ASM instance cannot mount. ASM Disk Group has 4 500G disks, database and ASM software 10.2.0.1, the Oracle database is in urgent need of recovery.


Second, fault analysis

Analyze the disks that make up the ASM disk group, remove the ASM metadata, and analyze the metadata: ASM storage metadata is corrupted, causing DiskGroup to mount. Reorganize the ASM storage space, export the database files from the ASM Disk group, and then detect and repair the database files. If the database files are intact, you can start the database with the database files exported from the ASM Disk group. If the database file is corrupted, the underlying parsing of these database files will import the data into the new database and restore the data.


Iii. recovery process

1 Lower level get ASM metadata, reorganize ASM storage space

2 using the North Asia ASM Analytic tool to parse the ASM structure to obtain data files in ASM

Figure One:

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/05/A8/wKiom1mpAbHDok6aAAC-iq-zgiY446.png-wh_500x0-wm_ 3-wmp_4-s_2512113145.png "title=" 1.png "alt=" Wkiom1mpabhdok6aaac-iq-zgiy446.png-wh_50 "/>

3 database files in ASM Disk groups are detected using the North Asia Oracle File Detection Tool

Figure II:

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/A4/59/wKioL1mpAaij_8sWAABtXHZSM9A990.png-wh_500x0-wm_ 3-wmp_4-s_2632545018.png "title=" 2.png "alt=" Wkiol1mpaaij_8swaabtxhzsm9a990.png-wh_50 "/>

4 Use the North Asia Oracle Resolution tool to parse data records from all data files and import them into the new database by user

Might

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M00/05/A8/wKiom1mpAcqxnDDqAACOzw8SItY591.png-wh_500x0-wm_ 3-wmp_4-s_3105485226.png "title=" 3.png "alt=" Wkiom1mpacqxnddqaacozw8sity591.png-wh_50 "/>

Iv. Results

Reorganize ASM storage space, the underlying parse ASM disk, export database files. The underlying parsing of these database files, according to the user to import data into the new database, by sampling data tables to verify the data, the data fully restored.

Figure IV:

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/A4/59/wKioL1mpAb_AgjE-AAC8uBOkOd0548.png-wh_500x0-wm_ 3-wmp_4-s_3326879147.png "title=" 4.png "alt=" Wkiol1mpab_agje-aac8ubokod0548.png-wh_50 "/>

This article is from the "SUN" blog, be sure to keep this source http://sun510.blog.51cto.com/9640486/1961935

Oracle ASM Failure Data Recovery

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.