ASM\u5e38\u7528\u547d\u4ee4<\/p>\n
--\u521b\u5efa\u78c1\u76d8\u7ec4
\n--\u6807\u51c6\u5197\u4f59
\nsql>create diskgroup dg01 normal redundancy
\nfailgroup fg01 disk
\n'\/dev\/rhdisk5',
\n'\/dev\/rhdisk6'
\nfailgroup fg02 disk
\n'\/dev\/rhdisk7',
\n'\/dev\/rhdisk8';<\/p>\n
--\u5916\u90e8\u5197\u4f59
\nsql>create diskgroup dg01 external redundancy
\ndisk
\n'\/dev\/rhdisk5',
\n'\/dev\/rhdisk6'<\/p>\n
--\u5220\u9664\u78c1\u76d8\u7ec4
\n--\u5378\u8f7d\u5176\u4ed6\u8282\u70b9\u7684\u78c1\u76d8\u7ec4
\nsql>alter drop diskgroup dg1 dismount;
\n--\u4ece\u9009\u5b9a\u8282\u70b9\u5220\u9664\u78c1\u76d8\u7ec4
\nsql>drop diskgroup dg1;
\nsql>drop diskgroup dg1 including contents;<\/p>\n
--\u6dfb\u52a0\u78c1\u76d8
\nsql>alter diskgroup dg01
\nadd disk
\n'\/dev\/rhdisk9' name disk9,
\n'\/dev\/rhdisk10' name disk10;<\/p>\n
--\u5220\u9664\u78c1\u76d8
\nsql>alter diskgroup dg01
\ndrop disk disk9;<\/p>\n
--\u5220\u9664\u5931\u8d25\u7ec4\u4e2d\u6240\u6709\u78c1\u76d8
\nsql>alter diskgroup dg1 drop disks in failgroup fg2;<\/p>\n
--\u53d6\u6d88\u5220\u9664\u78c1\u76d8\u64cd\u4f5c
\nsql>alter diskgroup dg1 undrop disks;<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u7ec4\u4fe1\u606f
\nSQL> select name,state,type,total_mb ,free_mb from v$asm_diskgroup;<\/p>\n
NAME STATE TYPE TOTAL_MB FREE_MB
\n------------------------------ ----------- ------ ---------- ----------
\nDATA MOUNTED EXTERN 10207 8209<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u4fe1\u606f
\nSQL> select group_number,path,state,total_mb,free_mb from v$asm_disk;<\/p>\n
GROUP_NUMBER PATH STATE TOTAL_MB FREE_MB
\n------------ -------------------- -------- ---------- ----------
\n1 \/dev\/racdisk1 NORMAL 977 755
\n1 \/dev\/racdisk4 NORMAL 4345 3497
\n1 \/dev\/racdisk3 NORMAL 3907 3171
\n1 \/dev\/racdisk2 NORMAL 978 786<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u7ec4\u8bbf\u95ee\u60c5\u51b5
\nSQL> col instance_name for a10
\nSQL> select group_number,instance_name,db_name,status from v$asm_client;<\/p>\n
GROUP_NUMBER INSTANCE_N DB_NAME STATUS
\n------------ ---------- -------- ------------
\n1 +ASM1 +ASM CONNECTED
\n1 racdb1 racdb CONNECTED<\/p>\n
--\u78c1\u76d8\u7ec4rebalance
\nSQL> alter diskgroup data rebalance power 3;
\nSQL> alter diskgroup data rebalance power 3 wait;<\/p>\n
--\u6302\u8f7d\u78c1\u76d8\u7ec4
\n--\u81ea\u52a8\u6302\u8f7d
\nSQL> show parameter group<\/p>\n
NAME TYPE VALUE
\n------------------------------------ ----------- ------------------------------
\nasm_diskgroups string
\nasm_preferred_read_failure_groups string
\nSQL> alter system set asm_diskgroups='data';<\/p>\n
System altered.<\/p>\n
SQL> show parameter group<\/p>\n
NAME TYPE VALUE
\n------------------------------------ ----------- ------------------------------
\nasm_diskgroups string data
\nasm_preferred_read_failure_groups string
\n--\u624b\u52a8\u6302\u8f7d
\nSQL> alter diskgroup data mount;
\nSQL> alter diskgroup data dismount;<\/p>\n
--\u521b\u5efa\u76ee\u5f55
\nSQL> alter diskgroup data add directory '+data\/racdb\/my_dir';<\/p>\n
Diskgroup altered.<\/p>\n
--\u91cd\u547d\u540d\u76ee\u5f55
\nSQL> alter diskgroup data rename directory '+data\/racdb\/my_dir' to '+data\/racdb\/back_dir';<\/p>\n
Diskgroup altered.<\/p>\n
--\u5220\u9664\u76ee\u5f55
\nSQL> alter diskgroup data drop directory '+data\/racdb\/back_dir' force;<\/p>\n
Diskgroup altered.<\/p>\n
--\u6dfb\u52a0\u522b\u540d
\nSQL> alter diskgroup data add alias '+data\/racscan\/ocrfile\/ocr.bak' for '+data\/racscan\/ocrfile\/REGISTRY.255.792513531';<\/p>\n
Diskgroup altered.<\/p>\n
--\u4fee\u6539\u522b\u540d
\nSQL> alter diskgroup data rename alias '+data\/racscan\/ocrfile\/ocr.bak' to '+data\/racscan\/ocrfile\/ocr_new.bak';<\/p>\n
Diskgroup altered.<\/p>\n
--\u5220\u9664\u522b\u540d
\nSQL> alter diskgroup data drop alias '+data\/racscan\/ocrfile\/ocr_new.bak';<\/p>\n
Diskgroup altered.<\/p>\n
--asmcmd\u5e38\u7528\u547d\u4ee4
\n--asm\u5b9e\u4f8b\u542f\u52a8
\nASMCMD> startup --nomount --pfile asm_init.ora
\n--asm\u5b9e\u4f8b\u5173\u95ed
\nASMCMD> shutdown --abort
\n--asm\u6570\u636e\u5e93\u7279\u6743\u7528\u6237
\nASMCMD> lspwusr
\nUsername sysdba sysoper sysasm
\nSYS TRUE TRUE TRUE
\nASMSNMP TRUE FALSE FALSE<\/p>\n
--\u521b\u5efa\u7528\u6237
\nASMCMD> orapwusr --add --privilege sysasm user1
\nEnter password: *****
\nASMCMD> lspwusr
\nUsername sysdba sysoper sysasm
\nSYS TRUE TRUE TRUE
\nASMSNMP TRUE FALSE FALSE
\nUSER1 FALSE FALSE TRUE<\/p>\n
--\u4fee\u6539\u7528\u6237\u53e3\u4ee4
\nASMCMD> orapwusr --modify --password user1
\nEnter password: ****<\/p>\n
--\u5220\u9664\u7528\u6237
\nASMCMD> orapwusr --delete user1<\/p>\n
--\u67e5\u770b\u53c2\u6570\u6587\u4ef6\u4f4d\u7f6e
\nASMCMD> spget
\n+DATA\/racscan\/asmparameterfile\/registry.253.792513519<\/p>\n
--\u78c1\u76d8\u7ec4\u4fe1\u606f\u67e5\u770b
\nASMCMD> lsdg data
\nState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
\nMOUNTED EXTERN N 512 4096 1048576 10207 8199 0 8199 0 N DATA\/<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u7ec4\u4e2d\u7684\u78c1\u76d8
\nASMCMD> lsdsk -G data
\nPath
\n\/dev\/racdisk1
\n\/dev\/racdisk2
\n\/dev\/racdisk3
\n\/dev\/racdisk4<\/p>\n
--\u67e5\u770b\u78c1\u76d8I\/O\u4fe1\u606f
\nASMCMD> lsdsk --statistics -G data
\nReads Write Read_Errs Write_Errs Read_time Write_Time Bytes_Read Bytes_Written Voting_File Path
\n1758 7269 0 0 57.921481 98.543651 30908416 37490688 Y \/dev\/racdisk1
\n1455 602 0 0 158.978452 13.234895 20516864 9986048 N \/dev\/racdisk2
\n14484 2435 0 0 310.265993 47.717912 233005056 40397312 N \/dev\/racdisk3
\n54998 15762 0 0 803.793446 404.21283 884313088 248880128 N \/dev\/racdisk4<\/p>\n
--\u67e5\u770b\u5019\u9009\u76d8
\nASMCMD> lsdsk --candidate -p
\nGroup_Num Disk_Num Incarn Mount_Stat Header_Stat Mode_Stat State Path<\/p>\n
--\u67e5\u770b\u8fdb\u7a0b\u6b63\u5728\u4f7f\u7528\u7684\u78c1\u76d8
\nASMCMD> lsod -G data --process LGWR
\nInstance Process OSPID Path
\n1 oracle@11grac1 (LGWR) 4716 \/dev\/racdisk1
\n1 oracle@11grac1 (LGWR) 4716 \/dev\/racdisk3
\n1 oracle@11grac1 (LGWR) 4716 \/dev\/racdisk4<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u7ec4\u5c5e\u6027
\nASMCMD> lsattr -l -G data
\nName Value
\naccess_control.enabled FALSE
\naccess_control.umask 066
\nau_size 1048576
\ncell.smart_scan_capable FALSE
\ncompatible.asm 11.2.0.0.0
\ncompatible.rdbms 10.1.0.0.0
\ndisk_repair_time 3.6h
\nsector_size 512<\/p>\n
--\u67e5\u770b\u78c1\u76d8\u7ec4I\/O\u4fe1\u606f
\nASMCMD> iostat -G data
\nGroup_Name Dsk_Name Reads Writes
\nDATA DATA_0000 31248384 38199296
\nDATA DATA_0001 237719552 40659456
\nDATA DATA_0002 20643840 10067968
\nDATA DATA_0003 903425024 254173696
\nASMCMD> iostat -t -G data
\nGroup_Name Dsk_Name Reads Writes Read_Time Write_Time
\nDATA DATA_0000 31297536 38219776 58.037687 99.323947
\nDATA DATA_0001 238194688 40692224 311.505431 47.882874
\nDATA DATA_0002 20643840 10100736 159.062091 13.290881
\nDATA DATA_0003 904211456 254403584 809.647423 408.726518
\nASMCMD> iostat -e -G data
\nGroup_Name Dsk_Name Reads Writes Read_Err Write_Err
\nDATA DATA_0000 31297536 38236160 0 0
\nDATA DATA_0001 238276608 40692224 0 0
\nDATA DATA_0002 20660224 10100736 0 0
\nDATA DATA_0003 904686592 254534656 0 0
\nASMCMD> iostat --io -G data
\nGroup_Name Dsk_Name Reads Writes
\nDATA DATA_0000 1781 7442
\nDATA DATA_0001 14817 2460
\nDATA DATA_0002 1466 611
\nDATA DATA_0003 56295 16167<\/p>\n","protected":false},"excerpt":{"rendered":"
ASM\u5e38\u7528\u547d\u4ee4 –\u521b\u5efa\u78c1\u76d8\u7ec4 –\u6807\u51c6\u5197\u4f59 sql>create diskgroup dg01 nor […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[87],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/275"}],"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=275"}],"version-history":[{"count":6,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/275\/revisions"}],"predecessor-version":[{"id":646,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/275\/revisions\/646"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=275"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}