OracleRAC故障处理(二)(+DATA磁盘组故障)

admin管理员组

文章数量:1535371

2024年2月7日发(作者：)

[root@rac2 bin]# su - grid[grid@rac2 ~]$ asmcmdASMCMD> lsOCR/---3 挂载DATA磁盘组失败SQL> shutdown abortASM instance shutdownSQL> startupORA-00099: warning: no parameter file specified for ASM instanceASM instance startedTotal System Global Area 1135747072 bytesFixed Size 2260728 bytesVariable Size 1108320520 bytesASM Cache 25165824 bytesASM diskgroups mountedASM diskgroups volume enabledSQL> set line 100SQL> select name,group_number,state from v$asm_diskgroup;NAME GROUP_NUMBER STATEOCR 2 MOUNTEDDATA 0 DISMOUNTEDSQL> set line 150SQL> col path for a30SQL> select GROUP_NUMBER,disk_number,state,name,path from v$asm_disk;GROUP_NUMBER DISK_NUMBER STATE NAME PATH0 0 NORMAL /dev/asm-diske0 1 NORMAL /dev/asm-diskg0 2 NORMAL /dev/asm-diskf1 1 NORMAL OCR_0001 /dev/asm-diskc1 0 NORMAL OCR_0000 /dev/asm-diskb1 2 NORMAL OCR_0002 /dev/asm-diskd6 rows selected.

SQL> alter diskgroup data mount;alter diskgroup data mount*ERROR at line 1:ORA-15032: not all alterations performedORA-15040: diskgroup is incompleteORA-15042: ASM disk "3" is missing from group number "1"SQL> drop diskgroup DATA;

drop diskgroup DATA*ERROR at line 1:ORA-15039: diskgroup not droppedORA-15001: diskgroup "DATA" does not exist or is not mounted---4 重新初始化DATA磁盘组内磁盘[root@rac1 ~]# cat /etc/udev/rules.d/ERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VBde6560cc-5b43c5dc", NAME="asm-diskb", OWNER="grid", GROUP="asmadmin",MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB0bc9f076-5bc9501f", NAME="asm-diskc", OWNER="grid", GROUP="asmadmin",MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB69c7e48f-359e5a75", NAME="asm-diskd", OWNER="grid", GROUP="asmadmin",MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VBf71d68a1-6c9355a0", NAME="asm-diske", OWNER="grid", GROUP="asmadmin",MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB6bae812a-c8d1bb88", NAME="asm-diskf", OWNER="grid", GROUP="asmadmin",MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB01fde635-97fae482", NAME="asm-diskg", OWNER="grid", GROUP="asmadmin",MODE="0660"---asm-diskg 1ATA_VBOX_HARDDISK_VB01fde635-97fae482---asm-diske 1ATA_VBOX_HARDDISK_VBf71d68a1-6c9355a0---asm-diskf 1ATA_VBOX_HARDDISK_VB6bae812a-c8d1bb88[root@rac1 ~]# scsi_id -g /dev/sdg1ATA VBOX HARDDISK VB01fde635-97fae482[root@rac1 ~]# scsi_id -g /dev/sde

1ATA VBOX HARDDISK VBf71d68a1-6c9355a0[root@rac1 ~]# scsi_id -g /dev/sdf1ATA VBOX HARDDISK VB6bae812a-c8d1bb88[root@rac1 ~]# dd if=/dev/zero of=/dev/sdg bs=1024k count=1010+0 records in10+0 records out10485760 bytes (10 MB) copied, 0.169501 s, 61.9 MB/s[root@rac1 ~]# dd if=/dev/zero of=/dev/sde bs=1024k count=1010+0 records in10+0 records out10485760 bytes (10 MB) copied, 0.100031 s, 105 MB/s[root@rac1 ~]# dd if=/dev/zero of=/dev/sdf bs=1024k count=1010+0 records in10+0 records out10485760 bytes (10 MB) copied, 0.17868 s, 58.7 MB/s[root@rac1 ~]# /sbin/start_udevStarting udev: [ OK ]---5 重建DATA磁盘组[grid@rac1 ~]$ asmca

SQL> select group_number,disk_number,name,state,path from v$asm_disk;GROUP_NUMBER DISK_NUMBER NAMESTATE PATH1 0 OCR_0000NORMAL /dev/asm-diskb1 1 OCR_0001NORMAL /dev/asm-diskc1 2 OCR_0002NORMAL /dev/asm-diskd2 0 DATA_0000NORMAL /dev/asm-diske2 1 DATA_0001NORMAL /dev/asm-diskf

(2)新建Database

[root@rac1 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is running on node rac1Instance cjcdb2 is running on node rac2

本文标签： 磁盘故障挂载失败处理