转载

Oracle ASM磁盘头部破坏实验

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ号:47079569 邮箱： service@parnassusdata.com

创建external磁盘组DATA1

Oracle ASM磁盘头部破坏实验

2.	备份磁盘头
[root@asm asm]# dd if=/dev/asm-diskf of=/asm/diskf1.bak bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 3.71699 seconds, 28.2 MB/s


3.	清除磁盘头
[root@asm asm]# dd if=/dev/zero of=/dev/asm-diskf bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.0391271 seconds, 2.7 GB/s


4.	尝试mount
SQL> alter diskgroup DATA1 mount;
alter diskgroup DATA1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA1" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"DATA1"

5.	查看alert日志
SQL> alter diskgroup DATA1 mount
NOTE: cache registered group DATA1 number=3 incarn=0xf1c89c27
NOTE: cache began mount (first) of group DATA1 number=3 incarn=0xf1c89c27
NOTE: Assigning number (3,4) to disk (/dev/asm-diskj)
NOTE: Assigning number (3,3) to disk (/dev/asm-diski)
NOTE: Assigning number (3,2) to disk (/dev/asm-diskh)
NOTE: Assigning number (3,1) to disk (/dev/asm-diskg)
Fri Apr 03 09:11:26 2015
ERROR: no read quorum in group: required 1, found 0 disks
NOTE: cache dismounting (clean) group 3/0xF1C89C27 (DATA1)
NOTE: messaging CKPT to quiesce pins Unix process pid: 7276, image: oracle@asm (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0xF1C89C27 (DATA1)
NOTE: cache ending mount (fail) of group DATA1 number=3 incarn=0xf1c89c27
NOTE: cache deleting context for group DATA1 3/0xf1c89c27
Fri Apr 03 09:11:26 2015
NOTE: No asm libraries found in the system
ASM Health Checker found 1 new failures
GMON dismounting group 3 at 21 for pid 20, osid 7276
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
ERROR: diskgroup DATA1 was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA1" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA1"
ERROR: alter diskgroup DATA1 mount
Fri Apr 03 09:18:00 2015


6.	恢复磁盘头
[root@asm asm]# dd if=/asm/diskf1.bak of=/dev/asm-diskf bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.0391271 seconds, 2.7 GB/s

7.	尝试挂载磁盘组
SQL> alter diskgroup DATA1 mount;

Diskgroup altered.

2. NORMAL

1. 创建normal磁盘组DATA2

2.	备份磁盘头
[root@asm asm]# dd if=/dev/asm-diskf of=/asm/diskf2.bak bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.187849 seconds, 558 MB/s

3.	破坏磁盘头
[root@asm asm]# dd if=/dev/zero of=/dev/asm-diskf bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.0262667 seconds, 4.0 GB/s

4.	查看磁盘组状态
SQL> select group_number,name,state,type from v$asm_diskgroup;

GROUP_NUMBER NAME		    STATE	TYPE
------------ ------------------------------            -----------     ------
	   1 DATA			    MOUNTED	NORMAL
	   2 ORADATA			    MOUNTED	EXTERN
	   3 DATA2			    MOUNTED	NORMAL

5.	Dismount磁盘组
SQL> alter diskgroup data2 dismount;

Diskgroup altered.

6.	尝试mount磁盘组
SQL> alter diskgroup data2 mount;
alter diskgroup data2 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "0" is missing from group number "3"

7.	查看alert日志
SQL> alter diskgroup data2 mount
NOTE: cache registered group DATA2 number=3 incarn=0x62589c78
NOTE: cache began mount (first) of group DATA2 number=3 incarn=0x62589c78
NOTE: Assigning number (3,4) to disk (/dev/asm-diskj)
NOTE: Assigning number (3,3) to disk (/dev/asm-diski)
NOTE: Assigning number (3,2) to disk (/dev/asm-diskh)
NOTE: Assigning number (3,1) to disk (/dev/asm-diskg)
Fri Apr 03 09:33:36 2015
NOTE: group DATA2: updated PST location: disk 0001 (PST copy 0)
NOTE: group DATA2: updated PST location: disk 0002 (PST copy 1)
NOTE: group DATA2: updated PST location: disk 0003 (PST copy 2)
NOTE: GMON heartbeating for grp 3
GMON querying group 3 at 38 for pid 20, osid 7681
NOTE: Assigning number (3,0) to disk ()
GMON querying group 3 at 39 for pid 20, osid 7681
NOTE: cache dismounting (clean) group 3/0x62589C78 (DATA2)
NOTE: messaging CKPT to quiesce pins Unix process pid: 7681, image: oracle@asm (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0x62589C78 (DATA2)
NOTE: cache ending mount (fail) of group DATA2 number=3 incarn=0x62589c78
NOTE: cache deleting context for group DATA2 3/0x62589c78
GMON dismounting group 3 at 40 for pid 20, osid 7681
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
ERROR: diskgroup DATA2 was not mounted
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "0" is missing from group number "3"
ERROR: alter diskgroup data2 mount
Fri Apr 03 09:33:43 2015
ASM Health Checker found 1 new failures
Fri Apr 03 09:39:05 2015



8.	恢复磁盘头
[root@asm asm]# dd if=/asm/diskf2.bak of=/dev/asm-diskf bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.095314 seconds, 1.1 GB/s

9.	再次尝试mount磁盘组
SQL> alter diskgroup data2 mount;

Diskgroup altered.

3 创建HIGH磁盘组DATA3

2.	备份磁盘头
[root@asm asm]# dd if=/dev/asm-diskf of=/asm/diskf3.bak bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.171521 seconds, 611 MB/s

3.	清除磁盘头
[root@asm asm]# dd if=/dev/zero of=/dev/asm-diskf bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.0213577 seconds, 4.9 GB/s

4.	查看磁盘组状态
SQL> select group_number,name,state,type from v$asm_diskgroup;

GROUP_NUMBER NAME			    STATE	TYPE
------------ ------------------------------ ----------- ------
	   1 DATA			    MOUNTED	NORMAL
	   2 ORADATA			    MOUNTED	EXTERN
	   3 DATA3			    MOUNTED	HIGH

5.	Dismount磁盘组DATA3
SQL> alter diskgroup data3 dismount;

Diskgroup altered.


6.	Mount磁盘组
SQL> alter diskgroup data3 mount;
alter diskgroup data3 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "0" is missing from group number "3"

7.	查看alert日志
SQL> alter diskgroup data3 mount
NOTE: cache registered group DATA3 number=3 incarn=0x36489cbc
NOTE: cache began mount (first) of group DATA3 number=3 incarn=0x36489cbc
NOTE: Assigning number (3,4) to disk (/dev/asm-diskj)
NOTE: Assigning number (3,3) to disk (/dev/asm-diski)
NOTE: Assigning number (3,2) to disk (/dev/asm-diskh)
NOTE: Assigning number (3,1) to disk (/dev/asm-diskg)
Fri Apr 03 09:52:35 2015
WARNING: GMON has insufficient disks to maintain consensus. minimum required is 5
NOTE: group DATA3: updated PST location: disk 0001 (PST copy 0)
NOTE: group DATA3: updated PST location: disk 0002 (PST copy 1)
NOTE: group DATA3: updated PST location: disk 0003 (PST copy 2)
NOTE: group DATA3: updated PST location: disk 0004 (PST copy 3)
NOTE: group DATA3: updated PST location: disk 0001 (PST copy 0)
NOTE: group DATA3: updated PST location: disk 0002 (PST copy 1)
NOTE: group DATA3: updated PST location: disk 0003 (PST copy 2)
NOTE: group DATA3: updated PST location: disk 0004 (PST copy 3)
NOTE: GMON heartbeating for grp 3
GMON querying group 3 at 57 for pid 20, osid 8015
NOTE: group DATA3: updated PST location: disk 0001 (PST copy 0)
NOTE: group DATA3: updated PST location: disk 0002 (PST copy 1)
NOTE: group DATA3: updated PST location: disk 0003 (PST copy 2)
NOTE: group DATA3: updated PST location: disk 0004 (PST copy 3)
NOTE: Assigning number (3,0) to disk ()
GMON querying group 3 at 58 for pid 20, osid 8015
NOTE: group DATA3: updated PST location: disk 0001 (PST copy 0)
NOTE: group DATA3: updated PST location: disk 0002 (PST copy 1)
NOTE: group DATA3: updated PST location: disk 0003 (PST copy 2)
NOTE: group DATA3: updated PST location: disk 0004 (PST copy 3)
NOTE: cache dismounting (clean) group 3/0x36489CBC (DATA3)
NOTE: messaging CKPT to quiesce pins Unix process pid: 8015, image: oracle@asm (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0x36489CBC (DATA3)
NOTE: cache ending mount (fail) of group DATA3 number=3 incarn=0x36489cbc
NOTE: cache deleting context for group DATA3 3/0x36489cbc
GMON dismounting group 3 at 59 for pid 20, osid 8015
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
ERROR: diskgroup DATA3 was not mounted
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "0" is missing from group number "3"
ERROR: alter diskgroup data3 mount
Fri Apr 03 09:52:43 2015
ASM Health Checker found 1 new failures
Fri Apr 03 09:55:08 2015


8.	恢复磁盘头
[root@asm asm]# dd if=/asm/diskf3.bak of=/dev/asm-diskf bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.0911406 seconds, 1.2 GB/s

9.	再次mount磁盘组
SQL> alter diskgroup data3 mount;               

Diskgroup altered.