ASM - Revision history

Stuart at 12:09, 4 September 2018

2018-09-04T12:09:32Z

Stuart: /* asm_capacity.sql */

2018-07-27T12:55:58Z

‎asm_capacity.sql

Show changes

Stuart: /* Add disk to a disk group */

2018-03-22T16:05:46Z

‎Add disk to a disk group

Stuart at 16:03, 22 March 2018

2018-03-22T16:03:42Z

Stuart: /* Restart ASM */

2018-03-22T16:01:06Z

‎Restart ASM

Stuart at 15:50, 22 March 2018

2018-03-22T15:50:34Z

Stuart at 15:29, 13 March 2018

2018-03-13T15:29:11Z

Stuart: /* asm_capacity.sql */

2017-02-02T11:55:55Z

‎asm_capacity.sql

Stuart: /* Check free space in ASM diskgroups */

2017-02-02T11:55:00Z

‎Check free space in ASM diskgroups

Show changes

Stuart: /* Check free space in ASM diskgroups */

2017-01-20T17:04:27Z

‎Check free space in ASM diskgroups

← Older revision		Revision as of 12:09, 4 September 2018
Line 1:		Line 1:
		+	===Useful ASM commands===
		+	* [https://dbaprakash.wordpress.com/category/asm/ dbaprakash.wordpress.com]
		+	===Migrate From Database File system to ASM===
		+	* [https://dbaprakash.wordpress.com/2015/03/30/migrate-from-database-file-system-to-asm/ dbaprakash.wordpress.com]
	===See what disk groups exist===		===See what disk groups exist===
	<pre>		<pre>

@@ Line 56: / Line 56: @@
 alter diskgroup fra add disk 'ORCL:FRA04' name fra04;
 </pre>
-Now the same disk query gives an updated view
+Now the same disk query as above gives an updated view
 <pre>
 MOUNT_S HEADER_STATU MODE_ST STATE      TOTAL_MB    FREE_MB NAME                           PATH                 LABEL
@@ Line 74: / Line 74: @@
 </pre>
 ===Recheck space available in disk groups using query below===
 <pre>

@@ Line 4: / Line 4: @@
 ,      name
 from   v$asm_diskgroup;
 </pre>
 ===See how the disk groups are linked to their paths===
@@ Line 68: / Line 79: @@
 Name                    Size    Size    Unit size State       Type   Total size (Mb) Used size (Mb) Pct. used
 -------------------- ------- ------- ------------ ----------- ------ --------------- -------------- ---------
-DATA                     512   4,096    1,048,576 CONNECTED   EXTERN          61,436         61,426     99.98
+DATA                     512   4,096    1,048,576 MOUNTED     EXTERN          81,915         61,478     75.05
-FRA                      512   4,096    1,048,576 CONNECTED   EXTERN           8,190          7,638     93.26
+FRA                      512   4,096    1,048,576 MOUNTED     EXTERN          16,377          7,829     47.80
-REDO                     512   4,096    1,048,576 CONNECTED   EXTERN           4,094          1,891     46.19
+REDO                     512   4,096    1,048,576 MOUNTED     EXTERN           4,094          1,891     46.19
                                                                       --------------- --------------
-Grand Total:                                                                  73,720         70,955
+Grand Total:                                                                 102,386         71,198
 </pre>
 ===Restart ASM===
@@ Line 159: / Line 170: @@
 ,      round ( (1 -(free_mb / total_mb)) * 100, 2) pct_used
 from   v$asm_diskgroup
-order  by name
+order  by name;
 </pre>
 ===asm_capacity.sql===

@@ Line 62: / Line 62: @@
 rows selected.
 </pre>
 ===Restart ASM===

← Older revision		Revision as of 15:50, 22 March 2018
Line 1:		Line 1:
		+	===See what disk groups exist===
		+	<pre>
		+	select group_number
		+	, name
		+	from v$asm_diskgroup;
		+	</pre>
		+	===See how the disk groups are linked to their paths===
		+	<pre>
		+	set lines 2000
		+	col label for a20
		+	col path for a20
		+	select mount_status
		+	, header_status
		+	, mode_status
		+	, state
		+	, total_mb
		+	, free_mb
		+	, name
		+	, path
		+	, label
		+	from v$asm_disk;
		+	</pre>
		+	gives...
		+	<pre>
		+	MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH LABEL
		+	------- ------------ ------- -------- ---------- ---------- ------------------------------ -------------------- ----------
		+	CLOSED PROVISIONED ONLINE NORMAL 0 0 ORCL:DATA04 DATA04
		+	CLOSED PROVISIONED ONLINE NORMAL 0 0 ORCL:FRA03 FRA03
		+	CLOSED PROVISIONED ONLINE NORMAL 0 0 ORCL:FRA04 FRA04
		+	CACHED MEMBER ONLINE NORMAL 20479 4 DATA01 ORCL:DATA01 DATA01
		+	CACHED MEMBER ONLINE NORMAL 20479 0 DATA02 ORCL:DATA02 DATA02
		+	CACHED MEMBER ONLINE NORMAL 4095 272 FRA01 ORCL:FRA01 FRA01
		+	CACHED MEMBER ONLINE NORMAL 4095 280 FRA02 ORCL:FRA02 FRA02
		+	CACHED MEMBER ONLINE NORMAL 2047 1103 REDO01 ORCL:REDO01 REDO01
		+	CACHED MEMBER ONLINE NORMAL 2047 1100 REDO02 ORCL:REDO02 REDO02
		+	CACHED MEMBER ONLINE NORMAL 20478 6 DATA03 ORCL:DATA03 DATA03
		+
		+	10 rows selected.
		+
		+	</pre>
		+	===Add disk to a disk group===
		+	<pre>
		+	alter diskgroup data add disk 'ORCL:DATA04' name data04;
		+	alter diskgroup fra add disk 'ORCL:FRA03' name fra03;
		+	alter diskgroup fra add disk 'ORCL:FRA04' name fra04;
		+	</pre>
		+	Now the same disk query gives an updated view
		+	<pre>
		+	MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH LABEL
		+	------- ------------ ------- -------- ---------- ---------- ------------------------------ -------------------- ----------
		+	CACHED MEMBER ONLINE NORMAL 20479 5121 DATA01 ORCL:DATA01 DATA01
		+	CACHED MEMBER ONLINE NORMAL 20479 5120 DATA02 ORCL:DATA02 DATA02
		+	CACHED MEMBER ONLINE NORMAL 4095 903 FRA01 ORCL:FRA01 FRA01
		+	CACHED MEMBER ONLINE NORMAL 4095 908 FRA02 ORCL:FRA02 FRA02
		+	CACHED MEMBER ONLINE NORMAL 2047 1103 REDO01 ORCL:REDO01 REDO01
		+	CACHED MEMBER ONLINE NORMAL 2047 1100 REDO02 ORCL:REDO02 REDO02
		+	CACHED MEMBER ONLINE NORMAL 20478 5122 DATA03 ORCL:DATA03 DATA03
		+	CACHED MEMBER ONLINE NORMAL 20479 5124 DATA04 ORCL:DATA04 DATA04
		+	CACHED MEMBER ONLINE NORMAL 4093 3461 FRA03 ORCL:FRA03 FRA03
		+	CACHED MEMBER ONLINE NORMAL 4094 3463 FRA04 ORCL:FRA04 FRA04
		+
		+	10 rows selected.
		+
		+	</pre>
	===Restart ASM===		===Restart ASM===
	cat /opt/oracle/oak/onecmd/tmp/restartasm.sh		cat /opt/oracle/oak/onecmd/tmp/restartasm.sh

@@ Line 14: / Line 14: @@
 /u01/app/11.2.0.4/grid/bin/crsctl start res ora.crsd -init
 </pre>
 ===Check free space in ASM diskgroups===

@@ Line 70: / Line 70: @@
 ===asm_capacity.sql===
 Check resistance of an ASM cluster against a disk / cell failure
 SPOOL asm_disk_capacity.output

@@ Line 36: / Line 36: @@
 REDO                                    763120     687700
 DATA                                  14745600    2930908
 </pre>