{"id":1235,"date":"2014-06-07T10:36:00","date_gmt":"2014-06-07T02:36:00","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1235"},"modified":"2014-06-07T10:49:36","modified_gmt":"2014-06-07T02:49:36","slug":"asm%e7%a3%81%e7%9b%98%e7%bb%84%e5%a4%b1%e8%b4%a5%e6%83%85%e6%99%af%e6%b5%8b%e8%af%95-normal-redundancy","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1235","title":{"rendered":"ASM\u78c1\u76d8\u7ec4\u5931\u8d25\u60c5\u666f\u6d4b\u8bd5-normal redundancy"},"content":{"rendered":"

ASM\u78c1\u76d8\u7ec4\u5931\u8d25\u60c5\u666f\u6d4b\u8bd5
\n\u6d4b\u8bd5\u573a\u666f1\uff1a<\/strong>
\n\u6709\u4e00\u4e2a\u78c1\u76d8\u7ec4data2\uff0c\u542b\u67092\u4e2a\u5931\u8d25\u7ec4\uff08fgdata2_c,fgdata2_d\uff09,\u6bcf\u4e2a\u5931\u8d25\u7ec4\u7684\u6240\u6709\u78c1\u76d8\u5206\u5e03\u5728\u5355\u72ec\u7684\u78c1\u76d8\u63a7\u5236\u5668\u4e0a\uff08sdc,sdd\uff09<\/strong>
\n\u5f53\u5176\u4e2d\u4e00\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u5931\u8d25\uff0c\u7136\u540e\u6dfb\u52a0\u65b0\u7684\u78c1\u76d8\uff0c\u91cd\u65b0\u6dfb\u52a0\u5931\u8d25\u7ec4\u5230\u8be5\u78c1\u76d8\u7ec4\uff0c\u5168\u8fc7\u7a0b\u5747\u4e0d\u5f71\u54cd\u6570\u636e\u5e93\u6b63\u5e38\u64cd\u4f5c\u3002
\n==========================================
\n\u6d4b\u8bd5\u573a\u666f2\uff1a<\/strong>
\n\u6709\u4e00\u4e2a\u78c1\u76d8\u7ec4data3\uff0c\u542b\u67092\u4e2a\u5931\u8d25\u7ec4\uff08fgdata3_cd1,fgdata3_cd2\uff09,\u6bcf\u4e2a\u5931\u8d25\u7ec4\u7684\u6240\u6709\u78c1\u76d8\u5747\u5300\u7684\u5206\u5e03\u57282\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u4e0a\uff08sdc,sdd\uff09<\/strong>
\n\u5f53\u5176\u4e2d\u4e00\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u5931\u8d25\uff0c\u7136\u540e\u6dfb\u52a0\u65b0\u7684\u78c1\u76d8\uff0c\u91cd\u65b0\u6dfb\u52a0\u5931\u8d25\u7ec4\u5230\u8be5\u78c1\u76d8\u7ec4\uff0c\u5168\u8fc7\u7a0b\u5747\u4e0d\u5f71\u54cd\u6570\u636e\u5e93\u6b63\u5e38\u64cd\u4f5c\u3002
\n==========================================
\n\u4e0b\u8fb9\u6d4b\u8bd5\u573a\u666f1\uff1a
\n\u865a\u62df\u673a\u6dfb\u52a02\u5757\u76d8\uff0c\u5404\u52064\u4e2a\u533a<\/p>\n

\r\n[root@test1 ~]# fdisk -l \/dev\/sdc\r\n\r\nDisk \/dev\/sdc: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdc1               1          63      506016   83  Linux\r\n\/dev\/sdc2              64         126      506047+  83  Linux\r\n\/dev\/sdc3             127         189      506047+  83  Linux\r\n\/dev\/sdc4             190         261      578340   83  Linux\r\n[root@test1 ~]# fdisk -l \/dev\/sdd\r\n\r\nDisk \/dev\/sdd: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdd1               1          63      506016   83  Linux\r\n\/dev\/sdd2              64         126      506047+  83  Linux\r\n\/dev\/sdd3             127         189      506047+  83  Linux\r\n\/dev\/sdd4             190         261      578340   83  Linux\r\n<\/pre>\n
\u7ed1\u5b9a\u540e\u5982\u4e0b\uff1a<\/p>\n
\r\n[root@test1 rules.d]# ls -l \/dev\/disk{c,d}*\r\nbrw-rw---- 1 oracle oinstall 8, 33 May 30 14:26 \/dev\/diskc_1\r\nbrw-rw---- 1 oracle oinstall 8, 34 May 30 14:26 \/dev\/diskc_2\r\nbrw-rw---- 1 oracle oinstall 8, 35 May 30 14:26 \/dev\/diskc_3\r\nbrw-rw---- 1 oracle oinstall 8, 36 May 30 14:26 \/dev\/diskc_4\r\nbrw-rw---- 1 oracle oinstall 8, 49 May 30 14:26 \/dev\/diskd_1\r\nbrw-rw---- 1 oracle oinstall 8, 50 May 30 14:26 \/dev\/diskd_2\r\nbrw-rw---- 1 oracle oinstall 8, 51 May 30 14:26 \/dev\/diskd_3\r\nbrw-rw---- 1 oracle oinstall 8, 52 May 30 14:26 \/dev\/diskd_4\r\n<\/pre>\n
\u521b\u5efa\u60c5\u666f1\u7684\u78c1\u76d8\u7ec4<\/p>\n
\r\nSQL> create diskgroup data2 normal redundancy\r\n  2  failgroup fgdata2_c disk\r\n  3  '\/dev\/diskc_1',\r\n  4  '\/dev\/diskc_2',\r\n  5  '\/dev\/diskc_3',\r\n  6  '\/dev\/diskc_4'\r\n  7  failgroup fgdata2_d disk\r\n  8  '\/dev\/diskd_1',\r\n  9  '\/dev\/diskd_2',\r\n 10  '\/dev\/diskd_3',\r\n 11  '\/dev\/diskd_4';\r\n\r\nDiskgroup created.\r\n\r\nSQL> select GROUP_NUMBER,NAME,TYPE,STATE,TOTAL_MB,FREE_MB from  v$asm_diskgroup;\r\n\r\nGROUP_NUMBER NAME                           TYPE   STATE         TOTAL_MB    FREE_MB\r\n------------ ------------------------------ ------ ----------- ---------- ----------\r\n           1 DATA2                          NORMAL MOUNTED           4092       3978\r\n\r\nSQL> select group_number g#,disk_number d#,name,mount_status,header_status,total_mb,free_mb,path from v$asm_disk;\r\n\r\n        G#         D# NAME                           MOUNT_S HEADER_STATU   TOTAL_MB    FREE_MB PATH\r\n---------- ---------- ------------------------------ ------- ------------ ---------- ---------- --------------------\r\n         1          6 DATA2_0006                     CACHED  MEMBER              494        477 \/dev\/diskd_3\r\n         1          7 DATA2_0007                     CACHED  MEMBER              564        554 \/dev\/diskd_4\r\n         1          5 DATA2_0005                     CACHED  MEMBER              494        480 \/dev\/diskd_2\r\n         1          4 DATA2_0004                     CACHED  MEMBER              494        478 \/dev\/diskd_1\r\n         1          1 DATA2_0001                     CACHED  MEMBER              494        478 \/dev\/diskc_2\r\n         1          3 DATA2_0003                     CACHED  MEMBER              564        553 \/dev\/diskc_4\r\n         1          2 DATA2_0002                     CACHED  MEMBER              494        479 \/dev\/diskc_3\r\n         1          0 DATA2_0000                     CACHED  MEMBER              494        479 \/dev\/diskc_1\r\n\r\n8 rows selected.\t\t\r\n<\/pre>\n
\u521b\u5efa\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> sho user\r\nUSER is "SYS"\r\nSQL> create tablespace yallonking datafile '+data2\/yallonking01.dbf' size 10m;\r\n\r\nTablespace created.\r\n\r\nSQL> create table yallonking tablespace yallonking as select * from dba_objects;\r\n\r\nTable created.\r\n\r\nSQL> select count(*) from YALLONKING;\r\n\r\n  COUNT(*)\r\n----------\r\n      9400\r\n<\/pre>\n
\u4e0b\u8fb9\u4eba\u4e3a\u5c06sdd\u78c1\u76d8\u6240\u6709\u5206\u533a\u5168\u90e8\u683c\u5f0f\u5316\u5e76\u5c06\u78c1\u76d8\u4ece\u865a\u62df\u673a\u62ff\u4e0b\uff0c\u6a21\u62df\u78c1\u76d8\u5b58\u50a8\u6545\u969c<\/p>\n
\r\n[root@test1 ~]# dd if=\/dev\/zero of=\/dev\/sdd1 bs=1M count=512\r\ndd: writing `\/dev\/sdd1': No space left on device\r\n495+0 records in\r\n494+0 records out\r\n518160384 bytes (518 MB) copied, 2.80467 seconds, 185 MB\/s\r\n[root@test1 ~]# dd if=\/dev\/zero of=\/dev\/sdd2 bs=1M count=512\r\ndd: writing `\/dev\/sdd2': No space left on device\r\n495+0 records in\r\n494+0 records out\r\n518192640 bytes (518 MB) copied, 3.36884 seconds, 154 MB\/s\r\n[root@test1 ~]# dd if=\/dev\/zero of=\/dev\/sdd3 bs=1M count=512\r\ndd: writing `\/dev\/sdd3': No space left on device\r\n495+0 records in\r\n494+0 records out\r\n518192640 bytes (518 MB) copied, 9.98685 seconds, 51.9 MB\/s\r\n[root@test1 ~]# dd if=\/dev\/zero of=\/dev\/sdd4 bs=1M count=1000\r\ndd: writing `\/dev\/sdd4': No space left on device\r\n565+0 records in\r\n564+0 records out\r\n592220160 bytes (592 MB) copied, 16.1438 seconds, 36.7 MB\/s\r\n\r\n[root@test1 ~]# fdisk -l\r\n\r\nDisk \/dev\/sda: 21.4 GB, 21474836480 bytes\r\n255 heads, 63 sectors\/track, 2610 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sda1   *           1          64      514048+  83  Linux\r\n\/dev\/sda2              65         586     4192965   82  Linux swap \/ Solaris\r\n\/dev\/sda3             587        2610    16257780   83  Linux\r\n\r\nDisk \/dev\/sdb: 10.7 GB, 10737418240 bytes\r\n255 heads, 63 sectors\/track, 1305 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdb1               1        1305    10482381   83  Linux\r\n\r\nDisk \/dev\/sdc: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdc1               1          63      506016   83  Linux\r\n\/dev\/sdc2              64         126      506047+  83  Linux\r\n\/dev\/sdc3             127         189      506047+  83  Linux\r\n\/dev\/sdc4             190         261      578340   83  Linux\r\n\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n<\/pre>\n
\u53ef\u80fd\u4f1a\u906d\u9047\u6b64bug\uff0c\u5982\u4e0b\uff1a<\/p>\n
\r\nSQL> select count(*) from YALLONKING;\r\nselect count(*) from YALLONKING\r\n                         *\r\nERROR at line 1:\r\nORA-08103: object no longer exists\r\n<\/pre>\n
\u6b64\u65f6\uff0coracle\u65e0\u62a5\u9519\u3002<\/p>\n
asm\u4e2d\u4fee\u590d<\/p>\n
\r\nSQL> alter diskgroup data2 check all norepair;\r\n\r\nDiskgroup altered.\r\n\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select count(*) from YALLONKING;\r\n\r\n  COUNT(*)\r\n----------\r\n      9400\r\n\r\n<\/pre>\n
asm\u65e5\u5fd7<\/p>\n
\r\nFri May 30 12:37:04 2014\r\nSQL> alter diskgroup data2 check all norepair \r\nFri May 30 12:37:04 2014\r\nNOTE: starting check of diskgroup DATA2\r\nWARNING: cache failed to read dsk=4 blk=3 from disk(s): 4\r\nORA-15196: invalid ASM block header [kfc.c:7910] [endian_kfbh] [2147483652] [3] [0 != 1]\r\nNOTE: a corrupted block was dumped to the trace file\r\nSystem State dumped to trace file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/+ASM\/udump\/+asm_ora_5569.trc\r\nNOTE: cache initiating offline of disk 4  group 1\r\nWARNING: offlining disk 4.3916022481 (DATA2_0004) with mask 0x3\r\nNOTE: PST update: grp = 1, dsk = 4, mode = 0x6\r\nFri May 30 12:37:05 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nNOTE: group DATA2: relocated PST to: disk 0005 (PST copy 1)\r\nFri May 30 12:37:05 2014\r\nNOTE: PST update: grp = 1, dsk = 4, mode = 0x4\r\nNOTE: cache closing disk 4 of grp 1: DATA2_0004\r\nWARNING: cache failed to read dsk=5 blk=3 from disk(s): 5\r\nORA-15196: invalid ASM block header [kfc.c:7910] [endian_kfbh] [2147483653] [3] [0 != 1]\r\nNOTE: a corrupted block was dumped to the trace file\r\nSystem State dumped to trace file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/+ASM\/udump\/+asm_ora_5569.trc\r\nNOTE: cache initiating offline of disk 5  group 1\r\nWARNING: offlining disk 5.3916022482 (DATA2_0005) with mask 0x3\r\nNOTE: PST update: grp = 1, dsk = 5, mode = 0x6\r\nFri May 30 12:37:05 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nNOTE: group DATA2: relocated PST to: disk 0006 (PST copy 1)\r\nFri May 30 12:37:05 2014\r\nNOTE: PST update: grp = 1, dsk = 5, mode = 0x4\r\nNOTE: cache closing disk 5 of grp 1: DATA2_0005\r\nWARNING: cache failed to read dsk=6 blk=3 from disk(s): 6\r\nORA-15196: invalid ASM block header [kfc.c:7910] [endian_kfbh] [2147483654] [3] [0 != 1]\r\nNOTE: a corrupted block was dumped to the trace file\r\nSystem State dumped to trace file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/+ASM\/udump\/+asm_ora_5569.trc\r\nNOTE: cache initiating offline of disk 6  group 1\r\nWARNING: offlining disk 6.3916022483 (DATA2_0006) with mask 0x3\r\nNOTE: PST update: grp = 1, dsk = 6, mode = 0x6\r\nFri May 30 12:37:05 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nNOTE: group DATA2: relocated PST to: disk 0007 (PST copy 1)\r\nFri May 30 12:37:05 2014\r\nNOTE: PST update: grp = 1, dsk = 6, mode = 0x4\r\nNOTE: cache closing disk 6 of grp 1: DATA2_0006\r\nWARNING: cache failed to read dsk=7 blk=3 from disk(s): 7\r\nORA-15196: invalid ASM block header [kfc.c:7910] [endian_kfbh] [2147483655] [3] [0 != 1]\r\nNOTE: a corrupted block was dumped to the trace file\r\nSystem State dumped to trace file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/+ASM\/udump\/+asm_ora_5569.trc\r\nNOTE: cache initiating offline of disk 7  group 1\r\nWARNING: offlining disk 7.3916022484 (DATA2_0007) with mask 0x3\r\nNOTE: PST update: grp = 1, dsk = 7, mode = 0x6\r\nFri May 30 12:37:05 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nFri May 30 12:37:05 2014\r\nNOTE: PST update: grp = 1, dsk = 7, mode = 0x4\r\nFri May 30 12:37:05 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nNOTE: cache closing disk 7 of grp 1: DATA2_0007\r\nFri May 30 12:37:05 2014\r\nSUCCESS: check of diskgroup DATA2 found no errors\r\n<\/pre>\n
\r\nFri May 30 12:38:13 2014\r\nWARNING: PST-initiated drop disk 1(520696412).4(3916022481) (DATA2_0004)\r\nWARNING: PST-initiated drop disk 1(520696412).5(3916022482) (DATA2_0005)\r\nWARNING: PST-initiated drop disk 1(520696412).6(3916022483) (DATA2_0006)\r\nWARNING: PST-initiated drop disk 1(520696412).7(3916022484) (DATA2_0007)\r\nNOTE: PST update: grp = 1\r\nFri May 30 12:38:13 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nFri May 30 12:38:13 2014\r\nNOTE: requesting all-instance PST refresh for group=1\r\nFri May 30 12:38:13 2014\r\nNOTE: PST refresh pending for group 1\/0x1f09325c (DATA2)\r\nSUCCESS: refreshed PST for 1\/0x1f09325c (DATA2)\r\nFri May 30 12:38:16 2014\r\nNOTE: starting rebalance of group 1\/0x1f09325c (DATA2) at power 1\r\nStarting background process ARB0\r\nARB0 started with pid=15, OS id=5858\r\nFri May 30 12:38:16 2014\r\nNOTE: assigning ARB0 to group 1\/0x1f09325c (DATA2)\r\nFri May 30 12:38:16 2014\r\nSUCCESS: PST-initiated disk drop completed\r\nFri May 30 12:38:20 2014\r\nErrors in file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/+ASM\/bdump\/+asm_arb0_5858.trc:\r\nORA-15041: diskgroup space exhausted\r\nFri May 30 12:38:20 2014\r\nNOTE: stopping process ARB0\r\nFri May 30 12:38:22 2014\r\nWARNING: rebalance not completed for group 1\/0x1f09325c (DATA2)\r\nFri May 30 12:38:22 2014\r\nSUCCESS: rebalance completed for group 1\/0x1f09325c (DATA2) \r\nNOTE: PST update: grp = 1\r\nFri May 30 12:38:22 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nFri May 30 12:38:22 2014\r\nWARNING: offline disk number 4 has references (14 AUs)\r\nWARNING: offline disk number 5 has references (14 AUs)\r\nWARNING: offline disk number 6 has references (16 AUs)\r\nWARNING: offline disk number 7 has references (17 AUs)\r\nNOTE: PST update: grp = 1\r\nFri May 30 12:38:22 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\n<\/pre>\n
\u6ce8\u610f\uff1aasm\u5148\u5b9a\u4f4d\u5931\u8d25\u7684\u78c1\u76d8\u4f4d\u7f6e\u4ee5\u53ca\u5f71\u54cd\u5230\u7684AU\uff0c\u5c1d\u8bd5\u8fdb\u884crebalance\uff0c\u53d1\u73b0\u53ea\u6709\u4e00\u4e2afailgroup\u53ef\u7528\uff0c\u6545\u62a5\u78c1\u76d8\u7a7a\u95f4\u4e0d\u8db3\uff0crebalance\u5931\u8d25\u5e76\u5c06\u76f8\u5173\u78c1\u76d8offline\u3002<\/p>\n
\u67e5\u770b\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select count(*) from YALLONKING;\r\n\r\n  COUNT(*)\r\n----------\r\n      9400\r\n\r\nSQL> insert into yallonking select * from yallonking;\r\n\r\n9400 rows created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> select count(*) from YALLONKING;\r\n\r\n  COUNT(*)\r\n----------\r\n     18800\r\n<\/pre>\n
\u67e5\u770basm\u78c1\u76d8\u60c5\u51b5<\/p>\n
\r\nSQL> select group_number g#,disk_number d#,name,mount_status,header_status,total_mb,free_mb,path from v$asm_disk;\r\n\r\n        G#         D# NAME                           MOUNT_S HEADER_STATU   TOTAL_MB    FREE_MB PATH\r\n---------- ---------- ------------------------------ ------- ------------ ---------- ---------- --------------------\r\n         1          7 DATA2_0007                     MISSING CANDIDATE             0          0\r\n         1          4 DATA2_0004                     MISSING CANDIDATE             0          0\r\n         1          5 DATA2_0005                     MISSING CANDIDATE             0          0\r\n         1          6 DATA2_0006                     MISSING CANDIDATE             0          0\r\n         1          0 DATA2_0000                     CACHED  MEMBER              494        475 \/dev\/diskc_1\r\n         1          1 DATA2_0001                     CACHED  MEMBER              494        476 \/dev\/diskc_2\r\n         1          2 DATA2_0002                     CACHED  MEMBER              494        477 \/dev\/diskc_3\r\n         1          3 DATA2_0003                     CACHED  MEMBER              564        549 \/dev\/diskc_4\r\n\r\n8 rows selected.\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u6b64\u65f6\uff0casm\u5df2\u7ecf\u6807\u8bb0disk\u4e22\u5931\u3002<\/p>\n
\u91cd\u542f\u6570\u636e\u5e93,ASM\u5b9e\u4f8b,\u4e3b\u673a;\u9632\u6b62\u7f13\u5b58\u5f71\u54cd<\/p>\n
\r\nSQL> shutdown immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\nSQL> shutdown immediate;\r\nASM diskgroups dismounted\r\nASM instance shutdown\t\r\n\r\n[root@test1 ~]# reboot\r\n\r\nBroadcast message from root (pts\/1) (Fri May 30 15:18:59 2014):\r\n\r\nThe system is going down for reboot NOW!  \r\n<\/pre>\n
\u542f\u52a8asm\u5b9e\u4f8b<\/p>\n
\r\n[oracle@test1 ~]$ export ORACLE_SID=+ASM\r\n[oracle@test1 ~]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Fri May 30 15:21:53 2014\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL> startup\r\nASM instance started\r\n\r\nTotal System Global Area   83886080 bytes\r\nFixed Size                  1217836 bytes\r\nVariable Size              57502420 bytes\r\nASM Cache                  25165824 bytes\r\nASM diskgroups mounted\r\n<\/pre>\n
\u542f\u52a8db\u5b9e\u4f8b\u5e76\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area  314572800 bytes\r\nFixed Size                  1219184 bytes\r\nVariable Size             100664720 bytes\r\nDatabase Buffers          209715200 bytes\r\nRedo Buffers                2973696 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL> insert into yallonking select * from yallonking;\r\n\r\n18800 rows created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> select count(*) from yallonking;\r\n\r\n  COUNT(*)\r\n----------\r\n     37600\r\n<\/pre>\n
\u4e0b\u8fb9\u6dfb\u52a0\u865a\u62df\u673a\u78c1\u76d8\u6a21\u62df\u78c1\u76d8\u6062\u590d\u6b63\u5e38<\/p>\n
\r\n[root@test1 ~]# fdisk -l \/dev\/sdd \r\n\r\nDisk \/dev\/sdd: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\nDisk \/dev\/sdd doesn't contain a valid partition table\r\n<\/pre>\n
\u5206\u533a\u540e\u5982\u4e0b\uff1a<\/p>\n
\r\n[root@test1 ~]# fdisk -l \/dev\/sdd \r\n\r\nDisk \/dev\/sdd: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdd1               1          63      506016   83  Linux\r\n\/dev\/sdd2              64         126      506047+  83  Linux\r\n\/dev\/sdd3             127         189      506047+  83  Linux\r\n\/dev\/sdd4             190         261      578340   83  Linux\r\n\r\n<\/pre>\n
\u7ed1\u5b9a\u540e\u5982\u4e0b\uff1a<\/p>\n
\r\n[root@test1 ~]# ls -l \/dev\/diskd*\r\nbrw-rw---- 1 oracle oinstall 8, 49 May 30 15:51 \/dev\/diskd_1\r\nbrw-rw---- 1 oracle oinstall 8, 50 May 30 15:51 \/dev\/diskd_2\r\nbrw-rw---- 1 oracle oinstall 8, 51 May 30 15:51 \/dev\/diskd_3\r\nbrw-rw---- 1 oracle oinstall 8, 52 May 30 15:51 \/dev\/diskd_4\r\n<\/pre>\n
\u67e5\u770basm\u78c1\u76d8\u72b6\u6001\t  <\/p>\n
\r\nSQL> select group_number g#,disk_number d#,name,mount_status,header_status,total_mb,free_mb,path from v$asm_disk;\r\n\r\n        G#         D# NAME                           MOUNT_S HEADER_STATU   TOTAL_MB    FREE_MB PATH\r\n---------- ---------- ------------------------------ ------- ------------ ---------- ---------- --------------------\r\n         0          0                                CLOSED  CANDIDATE           494          0 \/dev\/diskd_2\r\n         0          1                                CLOSED  CANDIDATE           564          0 \/dev\/diskd_4\r\n         0          2                                CLOSED  CANDIDATE           494          0 \/dev\/diskd_3\r\n         0          3                                CLOSED  CANDIDATE           494          0 \/dev\/diskd_1\r\n         1          6 DATA2_0006                     MISSING CANDIDATE             0          0\r\n         1          7 DATA2_0007                     MISSING CANDIDATE             0          0\r\n         1          5 DATA2_0005                     MISSING CANDIDATE             0          0\r\n         1          4 DATA2_0004                     MISSING CANDIDATE             0          0\r\n         1          1 DATA2_0001                     CACHED  MEMBER              494        476 \/dev\/diskc_2\r\n         1          3 DATA2_0003                     CACHED  MEMBER              564        549 \/dev\/diskc_4\r\n         1          0 DATA2_0000                     CACHED  MEMBER              494        475 \/dev\/diskc_1\r\n         1          2 DATA2_0002                     CACHED  MEMBER              494        477 \/dev\/diskc_3\r\n\r\n12 rows selected.\r\n\r\nSQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,MODE_STATUS,STATE,REDUNDANCY,FAILGROUP,PATH from v$asm_disk;\r\n\r\nGROUP_NUMBER DISK_NUMBER MOUNT_S MODE_ST STATE    REDUNDA FAILGROUP                      PATH\r\n------------ ----------- ------- ------- -------- ------- ------------------------------ --------------------\r\n           0           0 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_2\r\n           0           1 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_4\r\n           0           2 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_3\r\n           0           3 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_1\r\n           1           6 MISSING OFFLINE HUNG     UNKNOWN\r\n           1           7 MISSING OFFLINE HUNG     UNKNOWN\r\n           1           5 MISSING OFFLINE HUNG     UNKNOWN\r\n           1           4 MISSING OFFLINE HUNG     UNKNOWN\r\n           1           1 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_2\r\n           1           3 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_4\r\n           1           0 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_1\r\n           1           2 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_3\r\n\r\n12 rows selected.\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u6b64\u5904asm\u5c06\u539f\u6765\u7684asm disk\u6807\u8bb0\u4e3a\u4e22\u5931\uff0c\u5c06\u65b0\u6dfb\u52a0\u7684disk\u6807\u8bb0\u4e3a\u5019\u9009\u8005<\/p>\n
\u5c06\u65b0\u7684\u5931\u8d25\u7ec4\u6dfb\u52a0\u5230\u78c1\u76d8\u7ec4<\/p>\n
\r\nSQL> alter diskgroup data2 add\r\n  2  failgroup fgdata2_d disk\r\n  3  '\/dev\/diskd_1',\r\n  4  '\/dev\/diskd_2',\r\n  5  '\/dev\/diskd_3',\r\n  6  '\/dev\/diskd_4';\r\n\r\nDiskgroup altered.\r\n<\/pre>\n
\u67e5\u770basm\u78c1\u76d8\u60c5\u51b5<\/p>\n
\r\nSQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,MODE_STATUS,STATE,REDUNDANCY,FAILGROUP,PATH from v$asm_disk;\r\n\r\nGROUP_NUMBER DISK_NUMBER MOUNT_S MODE_ST STATE    REDUNDA FAILGROUP                      PATH\r\n------------ ----------- ------- ------- -------- ------- ------------------------------ --------------------\r\n           1           0 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_1\r\n           1           2 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_3\r\n           1           1 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_2\r\n           1           3 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_C                      \/dev\/diskc_4\r\n           1          10 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_D                      \/dev\/diskd_3\r\n           1          11 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_D                      \/dev\/diskd_4\r\n           1           9 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_D                      \/dev\/diskd_2\r\n           1           8 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA2_D                      \/dev\/diskd_1\r\n\r\n8 rows selected.\r\n\r\n<\/pre>\n
asm\u540e\u53f0\u65e5\u5fd7<\/p>\n
\r\nFri May 30 14:00:12 2014\r\nSQL> alter diskgroup data2 add\r\nfailgroup fgdata2_d disk\r\n'\/dev\/diskd_1',\r\n'\/dev\/diskd_2',\r\n'\/dev\/diskd_3',\r\n'\/dev\/diskd_4' \r\nFri May 30 14:00:12 2014\r\nNOTE: initializing header on grp 1 disk DATA2_0008\r\nNOTE: initializing header on grp 1 disk DATA2_0009\r\nNOTE: initializing header on grp 1 disk DATA2_0010\r\nNOTE: initializing header on grp 1 disk DATA2_0011\r\nNOTE: cache opening disk 8 of grp 1: DATA2_0008 path:\/dev\/diskd_1\r\nNOTE: cache opening disk 9 of grp 1: DATA2_0009 path:\/dev\/diskd_2\r\nNOTE: cache opening disk 10 of grp 1: DATA2_0010 path:\/dev\/diskd_3\r\nNOTE: cache opening disk 11 of grp 1: DATA2_0011 path:\/dev\/diskd_4\r\nNOTE: PST update: grp = 1\r\nFri May 30 14:00:12 2014\r\nNOTE: group DATA2: relocated PST to: disk 0000 (PST copy 0)\r\nNOTE: group DATA2: relocated PST to: disk 0008 (PST copy 1)\r\nFri May 30 14:00:12 2014\r\nNOTE: requesting all-instance disk validation for group=1\r\nFri May 30 14:00:12 2014\r\nNOTE: disk validation pending for group 1\/0x2098c19b (DATA2)\r\nSUCCESS: validated disks for 1\/0x2098c19b (DATA2)\r\nFri May 30 14:00:13 2014\r\nNOTE: PST update: grp = 1\r\nNOTE: requesting all-instance PST refresh for group=1\r\nFri May 30 14:00:13 2014\r\nNOTE: PST refresh pending for group 1\/0x2098c19b (DATA2)\r\nSUCCESS: refreshed PST for 1\/0x2098c19b (DATA2)\r\nFri May 30 14:00:16 2014\r\nNOTE: requesting all-instance PST refresh for group=1\r\nFri May 30 14:00:16 2014\r\nNOTE: PST refresh pending for group 1\/0x2098c19b (DATA2)\r\nSUCCESS: refreshed PST for 1\/0x2098c19b (DATA2)\r\nFri May 30 14:00:22 2014\r\nNOTE: starting rebalance of group 1\/0x2098c19b (DATA2) at power 1\r\nStarting background process ARB0\r\nARB0 started with pid=15, OS id=5309\r\nFri May 30 14:00:23 2014\r\nNOTE: assigning ARB0 to group 1\/0x2098c19b (DATA2)\r\nFri May 30 14:00:23 2014\r\nNOTE: F1X0 copy 2 relocating from 4:2 to 11:2\r\nNOTE: F1X0 copy 3 relocating from 65534:4294967294 to 65534:4294967294\r\nFri May 30 14:00:36 2014\r\nNOTE: stopping process ARB0\r\nFri May 30 14:00:38 2014\r\nSUCCESS: rebalance completed for group 1\/0x2098c19b (DATA2) \r\nFri May 30 14:00:38 2014\r\nSUCCESS: rebalance completed for group 1\/0x2098c19b (DATA2) \r\nNOTE: PST update: grp = 1\r\nSUCCESS: disk number 4 force dropped offline\r\nSUCCESS: disk number 5 force dropped offline\r\nSUCCESS: disk number 6 force dropped offline\r\nSUCCESS: disk number 7 force dropped offline\r\nNOTE: PST update: grp = 1\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u6b64\u5904\uff0casm\u5148\u5c06\u65b0\u7684\u5019\u9009\u8005\u521d\u59cb\u5316\u5e76cache\u5230\u78c1\u76d8\u7ec4\uff0c\u7136\u540e\u8fdb\u884crebalance\uff0c\u6700\u540e\u5c06\u5931\u6548\u7684\u78c1\u76d8\u5220\u9664\u6389\u3002<\/p>\n
\u4e0b\u8fb9\u518d\u8fdb\u884c\u6d4b\u8bd5<\/p>\n
\r\nSQL> insert into yallonking select * from yallonking;\r\n\r\n37600 rows created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> alter system flush buffer_cache;\r\n\r\nSystem altered.\r\n\r\nSQL> select count(*) from yallonking;\r\n\r\n  COUNT(*)\r\n----------\r\n     75200\r\n<\/pre>\n
\u81f3\u6b64\uff0c\u8be5\u60c5\u666f\u6d4b\u8bd5\u6210\u529f\uff01<\/p>\n
=================================================
\n\u6d4b\u8bd5\u60c5\u666f2\uff1a
\n\u6709\u4e00\u4e2a\u78c1\u76d8\u7ec4data3\uff0c\u542b\u67092\u4e2a\u5931\u8d25\u7ec4\uff08fgdata3_cd1,fgdata3_cd2\uff09,\u6bcf\u4e2a\u5931\u8d25\u7ec4\u7684\u6240\u6709\u78c1\u76d8\u5747\u5300\u7684\u5206\u5e03\u57282\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u4e0a\uff08sdc,sdd\uff09
\n\u5f53\u5176\u4e2d\u4e00\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u5931\u8d25\uff0c\u7136\u540e\u6dfb\u52a0\u65b0\u7684\u78c1\u76d8\uff0c\u91cd\u65b0\u6dfb\u52a0\u5931\u8d25\u7ec4\u5230\u8be5\u78c1\u76d8\u7ec4\uff0c\u5168\u8fc7\u7a0b\u5747\u4e0d\u5f71\u54cd\u6570\u636e\u5e93\u6b63\u5e38\u64cd\u4f5c\u3002
\n=================================================
\n\u865a\u62df\u673a\u6dfb\u52a02\u5757\u76d8\uff0c\u5404\u52064\u4e2a\u533a<\/p>\n
\r\n[root@test1 ~]# fdisk -l \/dev\/sdc\r\n\r\nDisk \/dev\/sdc: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdc1               1          63      506016   83  Linux\r\n\/dev\/sdc2              64         126      506047+  83  Linux\r\n\/dev\/sdc3             127         189      506047+  83  Linux\r\n\/dev\/sdc4             190         261      578340   83  Linux\r\n[root@test1 ~]# fdisk -l \/dev\/sdd\r\n\r\nDisk \/dev\/sdd: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdd1               1          63      506016   83  Linux\r\n\/dev\/sdd2              64         126      506047+  83  Linux\r\n\/dev\/sdd3             127         189      506047+  83  Linux\r\n\/dev\/sdd4             190         261      578340   83  Linux\r\n\r\n<\/pre>\n
\u7ed1\u5b9a\u540e\u5982\u4e0b\uff1a<\/p>\n
\r\n[root@test1 rules.d]# ls -l \/dev\/disk{c,d}*\r\nbrw-rw---- 1 oracle oinstall 8, 33 May 30 14:26 \/dev\/diskc_1\r\nbrw-rw---- 1 oracle oinstall 8, 34 May 30 14:26 \/dev\/diskc_2\r\nbrw-rw---- 1 oracle oinstall 8, 35 May 30 14:26 \/dev\/diskc_3\r\nbrw-rw---- 1 oracle oinstall 8, 36 May 30 14:26 \/dev\/diskc_4\r\nbrw-rw---- 1 oracle oinstall 8, 49 May 30 14:26 \/dev\/diskd_1\r\nbrw-rw---- 1 oracle oinstall 8, 50 May 30 14:26 \/dev\/diskd_2\r\nbrw-rw---- 1 oracle oinstall 8, 51 May 30 14:26 \/dev\/diskd_3\r\nbrw-rw---- 1 oracle oinstall 8, 52 May 30 14:26 \/dev\/diskd_4\r\n<\/pre>\n
\u521b\u5efa\u7b26\u5408\u60c5\u666f2\u7684\u78c1\u76d8\u7ec4<\/p>\n
\r\nSQL> drop diskgroup data2 including contents; \r\n\r\nDiskgroup dropped.\r\n\r\nSQL> create diskgroup data3 normal redundancy\r\n  2  failgroup fgdata3_cd1 disk\r\n  3  '\/dev\/diskc_1',\r\n  4  '\/dev\/diskc_3',\r\n  5  '\/dev\/diskd_1',\r\n  6  '\/dev\/diskd_3'\r\n  7  failgroup fgdata3_cd2 disk\r\n  8  '\/dev\/diskc_2',\r\n  9  '\/dev\/diskc_4',\r\n 10  '\/dev\/diskd_2',\r\n 11  '\/dev\/diskd_4';\r\n\r\nDiskgroup created.\r\n\r\n\r\nSQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,MODE_STATUS,STATE,REDUNDANCY,FAILGROUP,PATH from v$asm_disk;\r\n\r\nGROUP_NUMBER DISK_NUMBER MOUNT_S MODE_ST STATE    REDUNDA FAILGROUP                      PATH\r\n------------ ----------- ------- ------- -------- ------- ------------------------------ --------------------\r\n           1           0 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD1                    \/dev\/diskc_1\r\n           1           1 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD1                    \/dev\/diskc_3\r\n           1           4 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD2                    \/dev\/diskc_2\r\n           1           5 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD2                    \/dev\/diskc_4\r\n           1           7 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD2                    \/dev\/diskd_4\r\n           1           3 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD1                    \/dev\/diskd_3\r\n           1           6 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD2                    \/dev\/diskd_2\r\n           1           2 CACHED  ONLINE  NORMAL   UNKNOWN FGDATA3_CD1                    \/dev\/diskd_1\r\n\r\n8 rows selected.\r\n\r\n<\/pre>\n
\u521b\u5efa\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> drop tablespace yallonking INCLUDING CONTENTS and datafiles;\r\n\r\nTablespace dropped.\r\n\r\nSQL> create tablespace yallonking datafile '+data3\/yallonking01.dbf' size 10m;\r\n\r\nTablespace created.\r\n\r\nSQL> create table yallonking tablespace yallonking as select * from dba_objects;\r\n\r\nTable created.\r\n\r\nSQL> select TABLE_NAME,TABLESPACE_NAME from dba_tables where TABLE_NAME='YALLONKING';\r\n\r\nTABLE_NAME                     TABLESPACE_NAME\r\n------------------------------ ------------------------------\r\nYALLONKING                     YALLONKING\r\n\r\n\r\nSQL> select count(*) from YALLONKING;\r\n\r\n  COUNT(*)\r\n----------\r\n      9400\r\n<\/pre>\n
\u4e0b\u8fb9\u4eba\u4e3a\u5c06sdd\u78c1\u76d8\u4ece\u865a\u62df\u673a\u62ff\u8d70\u6a21\u62df\u78c1\u76d8\u5931\u8d25<\/p>\n
\r\n[root@test1 ~]# fdisk -l\r\n\r\nDisk \/dev\/sda: 21.4 GB, 21474836480 bytes\r\n255 heads, 63 sectors\/track, 2610 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sda1   *           1          64      514048+  83  Linux\r\n\/dev\/sda2              65         586     4192965   82  Linux swap \/ Solaris\r\n\/dev\/sda3             587        2610    16257780   83  Linux\r\n\r\nDisk \/dev\/sdb: 10.7 GB, 10737418240 bytes\r\n255 heads, 63 sectors\/track, 1305 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdb1               1        1305    10482381   83  Linux\r\n\r\nDisk \/dev\/sdc: 2147 MB, 2147483648 bytes\r\n255 heads, 63 sectors\/track, 261 cylinders\r\nUnits = cylinders of 16065 * 512 = 8225280 bytes\r\n\r\n   Device Boot      Start         End      Blocks   Id  System\r\n\/dev\/sdc1               1          63      506016   83  Linux\r\n\/dev\/sdc2              64         126      506047+  83  Linux\r\n\/dev\/sdc3             127         189      506047+  83  Linux\r\n\/dev\/sdc4             190         261      578340   83  Linux\r\n\u6ce8\u610f\uff1a\u6b64\u5904sdd\u5df2\u7ecf\u5931\u8d25\r\n<\/pre>\n
\u67e5\u770b\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> select count(*) from YALLONKING;\r\n\r\n  COUNT(*)\r\n----------\r\n      9400\r\n\r\nSQL> alter system flush BUFFER_CACHE;\r\n\r\nSystem altered.\r\n\r\nSQL> select count(*) from YALLONKING;\r\nselect count(*) from YALLONKING\r\n*\r\nERROR at line 1:\r\nORA-01115: IO error reading block from file 9 (block # 12)\r\nORA-01110: data file 9: '+DATA3\/yallonking01.dbf'\r\nORA-15078: ASM diskgroup was forcibly dismounted\r\n<\/pre>\n
\u67e5\u770basm\u78c1\u76d8\u60c5\u51b5<\/p>\n
\r\nSQL> select GROUP_NUMBER,NAME,STATE from v$asm_diskgroup;\r\n\r\nGROUP_NUMBER NAME                 STATE\r\n------------ -------------------- -----------\r\n           0 DATA3                DISMOUNTED\r\n\r\nSQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,MODE_STATUS,STATE,REDUNDANCY,FAILGROUP,PATH from v$asm_disk;\r\n\r\nGROUP_NUMBER DISK_NUMBER MOUNT_S MODE_ST STATE    REDUNDA FAILGROUP                      PATH\r\n------------ ----------- ------- ------- -------- ------- ------------------------------ --------------------\r\n           0           0 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_4\r\n           0           1 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskc_1\r\n           0           2 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskc_3\r\n           0           7 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_2\r\n           0           4 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_3\r\n           0           5 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskc_2\r\n           0           6 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskc_4\r\n           0           3 CLOSED  ONLINE  NORMAL   UNKNOWN                                \/dev\/diskd_1\r\n\r\n8 rows selected.\r\n\r\n<\/pre>\n
\u6b64\u65f6asm\u540e\u53f0\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n
\r\nFri May 30 16:27:16 2014\r\nWARNING: offlining disk 7.3915950641 (DATA3_0007) with mask 0x3\r\nNOTE: PST update: grp = 1, dsk = 7, mode = 0x6\r\nNOTE: PST update: grp = 1, dsk = 7, mode = 0x4\r\nNOTE: cache closing disk 7 of grp 1: DATA3_0007\r\nFri May 30 16:30:03 2014\r\nWARNING: PST-initiated drop disk 1(2211994373).7(3915950641) (DATA3_0007)\r\nFri May 30 16:30:03 2014\r\nErrors in file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/+ASM\/bdump\/+asm_lgwr_3434.trc:\r\nORA-27091: unable to queue I\/O\r\nORA-27072: File I\/O error\r\nLinux Error: 5: Input\/output error\r\nAdditional information: 4\r\nAdditional information: 4248\r\nAdditional information: -1\r\nFri May 30 16:30:03 2014\r\nNOTE: cache initiating offline of disk 2  group 1\r\nWARNING: offlining disk 2.3915950644 (DATA3_0002) with mask 0x3\r\nNOTE: PST update: grp = 1, dsk = 2, mode = 0x6\r\nFri May 30 16:30:03 2014\r\nERROR: too many offline disks in PST (grp 1)\r\nFri May 30 16:30:03 2014\r\nNOTE: halting all I\/Os to diskgroup DATA3\r\nNOTE: active pin found: 0x0x243512f0\r\nNOTE: active pin found: 0x0x2435135c\r\nFri May 30 16:30:03 2014\r\nERROR: ORA-15130 signalled during reconfiguration of diskgroup DATA3\r\nERROR: PST-initiated disk drop failed\r\nFri May 30 16:30:03 2014\r\nErrors in file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/admin\/+ASM\/bdump\/+asm_b000_5382.trc:\r\nORA-15130: diskgroup "" is being dismounted\r\nFri May 30 16:30:03 2014\r\nERROR: PST-initiated MANDATORY DISMOUNT of group DATA3\r\nNOTE: cache dismounting group 1\/0x83D85B05 (DATA3) \r\nSUCCESS: diskgroup DATA3 was dismounted\r\n<\/pre>\n
\u81f3\u6b64\uff0c\u60c5\u666f2\u5931\u8d25\u3002<\/p>\n
\u7ed3\u8bba\uff1a
\n\u6d4b\u8bd5\u573a\u666f1\uff1a
\n\u6709\u4e00\u4e2a\u78c1\u76d8\u7ec4data2\uff0c\u542b\u67092\u4e2a\u5931\u8d25\u7ec4\uff08fgdata2_c,fgdata2_d\uff09,\u6bcf\u4e2a\u5931\u8d25\u7ec4\u7684\u6240\u6709\u78c1\u76d8\u5206\u5e03\u5728\u5355\u72ec\u7684\u78c1\u76d8\u63a7\u5236\u5668\u4e0a\uff08sdc,sdd\uff09
\n\u5f53\u5176\u4e2d\u4e00\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u5931\u8d25\uff0c\u7136\u540e\u6dfb\u52a0\u65b0\u7684\u78c1\u76d8\uff0c\u91cd\u65b0\u6dfb\u52a0\u5931\u8d25\u7ec4\u5230\u8be5\u78c1\u76d8\u7ec4\uff0c\u5168\u8fc7\u7a0b\u5747\u4e0d\u5f71\u54cd\u6570\u636e\u5e93\u6b63\u5e38\u64cd\u4f5c\u3002
\n\u6d4b\u8bd5\u573a\u666f2\uff1a
\n\u6709\u4e00\u4e2a\u78c1\u76d8\u7ec4data3\uff0c\u542b\u67092\u4e2a\u5931\u8d25\u7ec4\uff08fgdata3_cd1,fgdata3_cd2\uff09,\u6bcf\u4e2a\u5931\u8d25\u7ec4\u7684\u6240\u6709\u78c1\u76d8\u5747\u5300\u7684\u5206\u5e03\u57282\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u4e0a\uff08sdc,sdd\uff09
\n\u5f53\u5176\u4e2d\u4e00\u4e2a\u78c1\u76d8\u63a7\u5236\u5668\u5931\u8d25\uff0c\u7136\u540e\u6dfb\u52a0\u65b0\u7684\u78c1\u76d8\uff0c\u91cd\u65b0\u6dfb\u52a0\u5931\u8d25\u7ec4\u5230\u8be5\u78c1\u76d8\u7ec4\uff0c\u5168\u8fc7\u7a0b\u5747\u4e0d\u5f71\u54cd\u6570\u636e\u5e93\u6b63\u5e38\u64cd\u4f5c\u3002
\n\u60c5\u666f1\u6210\u529f(\u53ef\u80fd\u4f1a\u906d\u9047bug)\uff0c\u60c5\u666f2\u5931\u8d25\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
ASM\u78c1\u76d8\u7ec4\u5931\u8d25\u60c5\u666f\u6d4b\u8bd5 \u6d4b\u8bd5\u573a\u666f1\uff1a \u6709\u4e00\u4e2a\u78c1\u76d8\u7ec4data2\uff0c\u542b\u67092\u4e2a\u5931\u8d25\u7ec4\uff08fgdata2_c,fgdat […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[87],"tags":[264,265,266],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1235"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1235"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1235\/revisions"}],"predecessor-version":[{"id":1240,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1235\/revisions\/1240"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1235"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}