How to manually fix ASM DISK HEADER Exceptions in Oracle

Source: Internet
Author: User
Tags count valid oracle database backup

Today, there are users of the ASM in the disk to do Fdisk, resulting in ASM disc exception, through the manual repair ASM disk HEADER To solve the problem, here through the experiment reproduced, reminding you to operate the ASM hard disk partitions need to be cautious, usually to the ASM disk header to do a backup

Initializing information

Sql> select * from V$version;

BANNER

----------------------------------------------------------------------

Oracle Database 11g Enterprise Edition release 11.2.0.3.0-production

Pl/sql Release 11.2.0.3.0-production

CORE 11.2.0.3.0 Production

TNS for Linux:version 11.2.0.3.0-production

Nlsrtl Version 11.2.0.3.0-production

Sql> show parameter instance_name;

NAME TYPE VALUE

------------------------------------ ---------- ----------------

instance_name string +asm1

Sql> select Group_number,disk_number,path,header_status from V$asm_disk;

Group_number Disk_number PATH Header_status

------------ ----------- ------------------------------ ------------------------

1/dev/oracleasm/disks/vol2 Member

0/DEV/ORACLEASM/DISKS/VOL1 Member

1/DEV/ORACLEASM/DISKS/VOL4 Member

0/DEV/ORACLEASM/DISKS/VOL3 Member

[Grid@rac1 ~]$/etc/init.d/oracleasm querydisk-d VOL3

Disk "VOL3" is a valid ASM disk on device [8,17]

[Grid@rac1 ~]$ ll/dev |grep 8,|grep 17

Brw-r-----1 Root disk 8, APR 11:37 SDB1

[Grid@rac1 ~]$/etc/init.d/oracleasm querydisk-d VOL4

Disk "VOL4" is a valid ASM disk on device [8,18]

[Grid@rac1 ~]$ Ll/dev |grep 8,|grep 18

Brw-r-----1 Root disk 8, APR 11:37 SDB2

Backup ASM DISK HEADER

[Root@rac1 backup_asmheader]# dd if=/dev/sdb1 of=vol3header.dd bs=4096 count=1

1+0 Records in

1+0 Records out

4096 bytes (4.1 kB) copied, 0.000143581 seconds, 28.5 MB/s

[Root@rac1 backup_asmheader]# dd if=/dev/sdb2 of=vol4header.dd bs=4096 count=1

1+0 Records in

1+0 Records out

4096 bytes (4.1 kB) copied, 0.000147727 seconds, 27.7 MB/s

Destroy ASM DISK HEADER

[Root@rac1 ~]# dd If=/dev/zero of=/dev/sdb1 bs=4096 count=1

1+0 Records in

1+0 Records out

4096 bytes (4.1 kB) copied, 4.4421e-05 seconds, 92.2 MB/s

[Grid@rac1 ~]$ kfed read/dev/oracleasm/disks/vol3

kfbh.endian:0; 0x000:0x00

kfbh.hard:0; 0x001:0x00

kfbh.type:0; 0x002:kfbtyp_invalid

kfbh.datfmt:0; 0x003:0x00

kfbh.block.blk:0; 0x004:blk=0

More Wonderful content: http://www.bianceng.cn/database/Oracle/

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.