1. Kontrola připojeného disku
2. Označení disku pro ASM (stamp)
Lze využít utilitu asmtool případně asmtoolg
ASMCMD> lsdg State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name MOUNTED EXTERN N N 512 4096 1048576 1280020 94649 0 94649 0 DATA0/ MOUNTED EXTERN N N 512 4096 1048576 302740 79751 0 79751 0 DATA1/
SQL> SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;
MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH LABEL --------------------------------------------------------------------------------------------------- CACHED MEMBER ONLINE NORMAL 256004 18926 DATA0_0004 \\.\ORCLDISKDATA5 CACHED MEMBER ONLINE NORMAL 256004 18932 DATA0_0003 \\.\ORCLDISKDATA4 CACHED MEMBER ONLINE NORMAL 256004 18938 DATA0_0002 \\.\ORCLDISKDATA3 CACHED MEMBER ONLINE NORMAL 256004 18930 DATA0_0001 \\.\ORCLDISKDATA2 CACHED MEMBER ONLINE NORMAL 302740 79751 DATA1_0000 \\.\ORCLDISKDATA1 CACHED MEMBER ONLINE NORMAL 256004 18923 DATA0_0000 \\.\ORCLDISKDATA0 CLOSED PROVISIONED ONLINE NORMAL 153582 0 \\.\ORCLDISKDATA7 CLOSED PROVISIONED ONLINE NORMAL 358403 0 \\.\ORCLDISKDATA6
SQL> SELECT name, type, total_mb, free_mb, required_mirror_free_mb, usable_file_mb FROM V$ASM_DISKGROUP;
NAME TYPE TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB --------------------------------------------------------------------------------------------------- DATA0 EXTERN 1280020 94418 0 94418 DATA1 EXTERN 302740 79751 0 79751
3. Přidání disku
SQL> alter diskgroup DATA1 add disk ‚\\.\ORCLDISKDATA7‘;
Diskgroup altered.
SQL> alter diskgroup DATA0 add disk ‚\\.\ORCLDISKDATA6‘;
Diskgroup altered.
4. Kontrola logů
Alert.log --------- Tue Nov 04 09:51:18 2014 SUCCESS: disk DATA1_0001 (1.4042307832) added to diskgroup DATA1 Tue Nov 04 09:53:26 2014 SUCCESS: disk DATA0_0005 (5.4042307833) added to diskgroup DATA0
+ASM.log - node1 ---------------- SQL> alter diskgroup DATA1 add disk '\\.\ORCLDISKDATA7'
Tue Nov 04 09:51:13 2014 NOTE: reconfiguration of group 2/0xf0d04b36 (DATA1), full=1 Tue Nov 04 09:51:13 2014 NOTE: initializing header on grp 2 disk DATA1_0001 NOTE: cache opening disk 1 of grp 2: DATA1_0001 path:\\.\ORCLDISKDATA7 NOTE: PST update: grp = 2 NOTE: requesting all-instance disk validation for group=2 Tue Nov 04 09:51:13 2014 NOTE: disk validation pending for group 2/0xf0d04b36 (DATA1) SUCCESS: validated disks for 2/0xf0d04b36 (DATA1) Tue Nov 04 09:51:14 2014 NOTE: PST update: grp = 2 NOTE: requesting all-instance PST refresh for group=2 Tue Nov 04 09:51:14 2014 NOTE: PST refresh pending for group 2/0xf0d04b36 (DATA1) SUCCESS: refreshed PST for 2/0xf0d04b36 (DATA1) Tue Nov 04 09:51:17 2014 NOTE: requesting all-instance PST refresh for group=2 Tue Nov 04 09:51:17 2014 NOTE: PST refresh pending for group 2/0xf0d04b36 (DATA1) SUCCESS: refreshed PST for 2/0xf0d04b36 (DATA1) Tue Nov 04 09:51:23 2014 NOTE: starting rebalance of group 2/0xf0d04b36 (DATA1) at power 1 Starting background process ARB0 ARB0 started with pid=24, OS id=3808 Tue Nov 04 09:51:23 2014 NOTE: assigning ARB0 to group 2/0xf0d04b36 (DATA1) Tue Nov 04 09:51:24 2014 NOTE: X->S down convert bast on F1B3 bastCount=2 NOTE: X->S down convert bast on F1B3 bastCount=3 NOTE: X->S down convert bast on F1B3 bastCount=4 NOTE: X->S down convert bast on F1B3 bastCount=5 NOTE: X->S down convert bast on F1B3 bastCount=6 NOTE: X->S down convert bast on F1B3 bastCount=7
+ASM.log - node2 ---------------- Tue Nov 04 09:53:20 2014 NOTE: reconfiguration of group 1/0xf0a04802 (DATA0), full=1 NOTE: disk validation pending for group 1/0xf0a04802 (DATA0) SUCCESS: validated disks for 1/0xf0a04802 (DATA0) NOTE: PST refresh pending for group 1/0xf0a04802 (DATA0) NOTE: cache opening disk 5 of grp 1: DATA0_0005 path:\\.\ORCLDISKDATA6 SUCCESS: refreshed PST for 1/0xf0a04802 (DATA0) NOTE: PST refresh pending for group 1/0xf0a04802 (DATA0) SUCCESS: refreshed PST for 1/0xf0a04802 (DATA0)
5. Kontrola volného místa
MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH LABEL --------------------------------------------------------------------------------------------------- CACHED MEMBER ONLINE NORMAL 256004 18926 DATA0_0004 \\.\ORCLDISKDATA5 CACHED MEMBER ONLINE NORMAL 256004 18932 DATA0_0003 \\.\ORCLDISKDATA4 CACHED MEMBER ONLINE NORMAL 256004 18938 DATA0_0002 \\.\ORCLDISKDATA3 CACHED MEMBER ONLINE NORMAL 256004 18930 DATA0_0001 \\.\ORCLDISKDATA2 CACHED MEMBER ONLINE NORMAL 302740 79751 DATA1_0000 \\.\ORCLDISKDATA1 CACHED MEMBER ONLINE NORMAL 256004 18923 DATA0_0000 \\.\ORCLDISKDATA0 CACHED MEMBER ONLINE NORMAL 358403 358398 DATA0_0005 \\.\ORCLDISKDATA6 CACHED MEMBER ONLINE NORMAL 153582 149792 DATA1_0001 \\.\ORCLDISKDATA7
SQL> SELECT name, type, total_mb, free_mb, required_mirror_free_mb, usable_file_mb FROM V$ASM_DISKGROUP;
NAME TYPE TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB --------------------------------------------------------------------------------------------------- DATA0 EXTERN 1638423 452816 0 452816 DATA1 EXTERN 456322 233330 0 233330
ASMCMD> lsdg State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name MOUNTED EXTERN Y N 512 4096 1048576 1638423 452816 0 452816 0 DATA0/ MOUNTED EXTERN Y N 512 4096 1048576 456322 233330 0 233330 0 DATA1/ ASMCMD>