SQL> alter diskgroup WMDW_DATAGP1 drop disk WMDW_DATAGP1_0003 rebalance power 11;
alter diskgroup WMDW_DATAGP1 drop disk WMDW_DATAGP1_0003 rebalance power 11
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15071: ASM disk "WMDW_DATAGP1_0003" is already being dropped
SQL>alter diskgroup WMDW_DATAGP1 resize diskWMDW_DATAGP1_0002 size 50m时
连接自动断开，alert日志不断报
NOTE: requesting all-instance PST refresh for group=1
Thu Sep 17 11:43:00 2009
NOTE: active pin found: 0x0x65df4690
这样的信息，然后大概3个小时，RAC整个就down掉了。
重启后，有恢复使用了。
谁见过这种情况？
Operation system ： Red Hat AS 4 update 6 x86-64
Oracle version： oracle 10.2.0.3
[oracle@node01 2009-09-16]$ cat /etc/sysconfig/rawdevices
# This file and interface are deprecated.
# Applications needing raw device access should open regular
# block devices with O_DIRECT.
# raw device bindings
# format:
#
# example: /dev/raw/raw1 /dev/sda1
#
/dev/raw/raw2 8 5
#vote disk
/dev/raw/raw3 /dev/iscsi/raw3
#OCR
/dev/raw/raw5 /dev/iscsi/raw5
/dev/raw/raw6 /dev/iscsi/raw6
#data
/dev/raw/raw7 /dev/iscsi/raw7
/dev/raw/raw8 /dev/iscsi/raw8
/dev/raw/sddraw1/dev/iscsi/raw1
/dev/raw/sddraw2/dev/iscsi/raw2
++++++++++++++++++++++++++++++++++++++++++++++
[oracle@node01 2009-09-16]$ ll /dev/raw/
total 0
crw-rw----1 root disk 162, 1 Sep 15 16:58 raw1
crw-rw----1 root disk 162, 2 Sep 15 16:58 raw2
crw-r--r--1 oracle oinstall 162, 3 Sep 15 16:34 raw3
crw-rw----1 root oinstall 162, 5 Sep 15 16:34 raw5
crw-rw----1 root oinstall 162, 6 Sep 15 16:34 raw6
crw-rw----1 oracle oinstall 162, 7 Sep 15 16:34 raw7
crw-rw----1 oracle oinstall 162, 8 Sep 15 16:34 raw8
crw-rw----1 oracle oinstall 162, 1 Sep 15 16:52 sddraw1
crw-rw----1 oracle oinstall 162, 2 Sep 15 16:52 sddraw2
[oracle@node01 2009-09-16]$ sqlplus / as sysdba
SQL> select * from v$asm_diskgroup
GROUP_NUMBER NAME
SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE
TYPE
TOTAL_MBFREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS UN COMPATIBILITY
DATABASE_COMPATIBILITY
------------ ------------------------------------------------------------ ----------- ---------- -------------------- ---------------------- ------------ ---------- ---------- ----------------------- -------------- ------------- -- ------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------
1 WMDW_DATAGP1
512 4096
1048576 MOUNTED EXTERN 1023506 288925
0 288925
0 N10.1.0.0.0
10.1.0.0.0
SQL> selectGROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, MODE_STATUS, STATE, REDUNDANCY,name, FAILGROUP, PATH from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS
MODE_STATUSSTATE
REDUNDANCY NAME
FAILGROUP
PATH
------------ ----------- -------------- ------------------------ -------------- ---------------- -------------- ------------------------------------------------------------ ------------------------------------------------------------
0 4 CLOSED FOREIGN
ONLINE NORMAL UNKNOWN
/dev/raw/raw6
0 5 CLOSED FOREIGN
ONLINE NORMAL UNKNOWN
/dev/raw/raw5
0 6 CLOSED FOREIGN
ONLINE NORMAL UNKNOWN
/dev/raw/raw3
1 3 CACHED MEMBER
ONLINE FORCING
UNKNOWNWMDW_DATAGP1_0003 WMDW_DATAGP1_0003
/dev/raw/sddraw2
1 2 CACHED MEMBER
ONLINE FORCING
UNKNOWNWMDW_DATAGP1_0002 WMDW_DATAGP1_0002
/dev/raw/sddraw1
1 1 CACHED MEMBER
ONLINE NORMAL UNKNOWNWMDW_DATAGP1_0001 WMDW_DATAGP1_0001
/dev/raw/raw8
1 0 CACHED MEMBER
ONLINE NORMAL UNKNOWNWMDW_DATAGP1_0000 WMDW_DATAGP1_0000
/dev/raw/raw7
SQL> alter diskgroup WMDW_DATAGP1 check disk WMDW_DATAGP1_0000
Thu Sep 17 11:38:00 2009
SQL> alter diskgroup WMDW_DATAGP1 check disk WMDW_DATAGP1_0002
Thu Sep 17 11:39:50 2009
SQL> alter diskgroup WMDW_DATAGP1 check disk WMDW_DATAGP1_0001
Thu Sep 17 11:41:01 2009
SQL> alter diskgroup WMDW_DATAGP1 check disk WMDW_DATAGP1_0002 repair
Thu Sep 17 11:42:46 2009
SQL>alter diskgroup WMDW_DATAGP1 resize diskWMDW_DATAGP1_0002 size 50m
Thu Sep 17 11:42:46 2009
WARNING: cache failed to read dsk=2 blk=2 from disk(s): 2
ORA-15196: invalid ASM block header [kfc.c:7997] [check_kfbh] [2147483650] [2] [2180611560 != 2187360525]
NOTE: a corrupted block was dumped to the trace file
System State dumped to trace file /home/oracle/admin/+ASM/udump/+asm1_ora_13614.trc
NOTE: cache initiating offline of disk 2group 1
WARNING: offlining disk 2.3915282310 (WMDW_DATAGP1_0002) with mask 0x3
NOTE: PST update: grp = 1, dsk = 2, mode = 0x6
Thu Sep 17 11:42:47 2009
ERROR: too many offline disks in PST (grp 1)
Thu Sep 17 11:42:48 2009
NOTE: PST not enabling heartbeating (grp 1): group dismounted
Thu Sep 17 11:42:48 2009
NOTE: halting all I/Os to diskgroup WMDW_DATAGP1
NOTE: active pin found: 0x0x65df47f0
NOTE: active pin found: 0x0x65df4690
NOTE: active pin found: 0x0x65df4740
Thu Sep 17 11:42:48 2009
Errors in file /home/oracle/admin/+ASM/udump/+asm1_ora_13614.trc:
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-15130: diskgroup "WMDW_DATAGP1" is being dismounted
ORA-15066: offlining disk "WMDW_DATAGP1_0002" may result in a data loss
Thu Sep 17 11:42:48 2009
NOTE: active pin found: 0x0x65df4690
NOTE: active pin found: 0x0x65df4740
Thu Sep 17 11:42:49 2009
Errors in file /home/oracle/admin/+ASM/udump/+asm1_ora_13614.trc:
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-15130: diskgroup "WMDW_DATAGP1" is being dismounted
ORA-15066: offlining disk "WMDW_DATAGP1_0002" may result in a data loss
Thu Sep 17 11:42:49 2009
Trace dumping is performing id=[cdmp_20090917114249]
Thu Sep 17 11:42:50 2009
Errors in file /home/oracle/admin/+ASM/udump/+asm1_ora_13614.trc:
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-15130: diskgroup "WMDW_DATAGP1" is being dismounted
ORA-15066: offlining disk "WMDW_DATAGP1_0002" may result in a data loss
Thu Sep 17 11:42:51 2009
Errors in file /home/oracle/admin/+ASM/udump/+asm1_ora_13614.trc:
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kfgscRefresh_0], [1], [], [], [], [], [], []
ORA-15130: diskgroup "WMDW_DATAGP1" is being dismounted
ORA-15066: offlining disk "WMDW_DATAGP1_0002" may result in a data loss
Thu Sep 17 11:42:51 2009
NOTE: active pin found: 0x0x65df4690
NOTE: active pin found: 0x0x65df4740
NOTE: active pin found: 0x0x65df4690
NOTE: active pin found: 0x0x65df4740
Thu Sep 17 11:42:55 2009
NOTE: requesting all-instance PST refresh for group=1
Thu Sep 17 11:42:55 2009
NOTE: PST refresh pending for group 1/0xffce8775 (WMDW_DATAGP1)
Thu Sep 17 11:42:57 2009
NOTE: active pin found: 0x0x65df4690
NOTE: active pin found: 0x0x65df4740
Thu Sep 17 11:42:57 2009
SUCCESS: refreshed PST for 1/0xffce8775 (WMDW_DATAGP1)
ERROR: ORA-15130 thrown in RBAL for group number 1
Thu Sep 17 11:42:57 2009
Errors in file /home/oracle/admin/+ASM/bdump/+asm1_rbal_652.trc:
ORA-15130: diskgroup "WMDW_DATAGP1" is being dismounted
Thu Sep 17 11:43:00 2009
NOTE: requesting all-instance PST refresh for group=1
Thu Sep 17 11:43:00 2009
NOTE: active pin found: 0x0x65df4690
NOTE: active pin found: 0x0x65df4740
NOTE: active pin found: 0x0x65df4690
NOTE: active pin found: 0x0x65df4740
Thu Sep 17 11:43:05 2009
|
