您好,登錄后才能下訂單哦!
RAC中asm_diskgroups的參數(shù)有哪些,很多新手對此不是很清楚,為了幫助大家解決這個難題,下面小編將為大家詳細講解,有這方面需求的人可以來學習下,希望你能有所收獲。
初始化參數(shù)asm_diskgroups指定了在ASM實例啟動時,或執(zhí)行alter diskgroup all mount語句時,被掛載的磁盤組的名字,即當ASM實例啟動的時候,會掛載這個參數(shù)指定的所有磁盤組,或當執(zhí)行alter diskgroup all mount/dismount語句時,也會掛載這個參數(shù)指定的所有磁盤組。
關(guān)于此參數(shù)的值,是由ASM自動維護的,不需要人去干預,修改。
1 當成功創(chuàng)建一個磁盤組或是掛載一個磁盤組時,磁盤組的名字將會自動添加到此參數(shù)中。
2 當刪除或卸載一個磁盤組時,磁盤組的名字也將相應地從這個參數(shù)中移除。
注意:
如果掛載或卸載使用的是alter diskgroup all mount或alter diskgroup all dismount,此參數(shù)的值將不會發(fā)生變化!
只有在掛載或卸載時執(zhí)行alter diskgroup xxx mount或alter diskgroup xxx dismount時,才會影響此參數(shù)的值。
做實驗如下:
SQL> select name,STATE from v$asm_diskgroup;
NAME STATE
----- --------
DATA1 MOUNTED
SQL> create diskgroup DATA2 external redundancy disk 'ORCL:VOL201','ORCL:VOL202','ORCL:VOL203','ORCL:VOL204';
Diskgroup created.
SQL> select name,STATE from v$asm_diskgroup;
NAME STATE
--------------- ---------------
DATA1 MOUNTED
DATA2 MOUNTED
SQL> show parameter asm_diskgroups;
NAME TYPE VALUE
-------------- -------- -------------
asm_diskgroups string DATA2
SQL> create pfile='/tmp/asm_20110905.ora' from spfile;
File created.
查看文件內(nèi)容:
[root@rac1 tmp]# cat asm_20110905.ora
+ASM1.__oracle_base='/opt/rac/grid'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/opt/rac/grid'#ORACLE_BASE set from in memory value
+ASM1.asm_diskgroups='DATA2'#Manual Mount
*.asm_power_limit=1
*.diagnostic_dest='/opt/rac/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
在節(jié)點2上
SQL> alter system set asm_diskgroups='DATA2' scope=spfile sid='+ASM2';
System altered.
SQL> show parameter asm_diskgroups;
##這里手工操作以后,asm_diskgroups里面是沒有信息的??!
NAME TYPE VALUE
--------------- ------------ ---------------
asm_diskgroups string
SQL> create pfile='/tmp/asm_20110905.ora' from spfile;
File created.
查看生成的文件!
[root@rac2 tmp]# cat asm_20110905.ora
+ASM1.__oracle_base='/opt/rac/grid'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/opt/rac/grid'#ORACLE_BASE set from in memory value
+ASM1.asm_diskgroups='DATA2'#Manual Mount
+ASM2.asm_diskgroups='DATA2'--手工加上的!
*.asm_power_limit=1
*.diagnostic_dest='/opt/rac/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
在節(jié)點2上檢查DATA2的狀態(tài):
grid@rac2:/home/grid>crsctl status resource ora.DATA2.dg
NAME=ora.DATA2.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE , OFFLINE
STATE=ONLINE on rac1, OFFLINE 在節(jié)點2上未啟動?。?/p>
grid@rac2:/home/grid>sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 5 14:18:25 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select name,STATE from v$asm_diskgroup;
NAME STATE
----------------------
DATA1 MOUNTED
DATA2 DISMOUNTED
SQL> alter diskgroup DATA2 MOUNT;
Diskgroup altered.
SQL> show parameter asm_diskgroups; ###mount DATA2磁盤之后,asm_diskgroups 顯示了數(shù)據(jù)DATA2
NAME TYPE VALUE
---------------- -------- -------------------
asm_diskgroups string DATA2
SQL> create pfile='/tmp/asm2_1.ora' from spfile;
File created.
SQL> exit
[root@rac2 tmp]# cat asm2_1.ora
+ASM1.__oracle_base='/opt/rac/grid'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/opt/rac/grid'#ORACLE_BASE set from in memory value
+ASM1.asm_diskgroups='DATA2'#Manual Mount
+ASM2.asm_diskgroups='DATA2'#Manual Mount
##oracle 自己添加上去的?。?!不過要注意 Manual Mount 提示,手動mount。
*.asm_power_limit=1
*.diagnostic_dest='/opt/rac/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
這里11.2.0.1 有一個bug 8663101 !和磁盤的mount 狀態(tài)有關(guān)!
看完上述內(nèi)容是否對您有幫助呢?如果還想對相關(guān)知識有進一步的了解或閱讀更多相關(guān)文章,請關(guān)注億速云行業(yè)資訊頻道,感謝您對億速云的支持。
免責聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。