Shulou(Shulou.com)06/01 Report--

What are the parameters of asm_diskgroups in RAC, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

The initialization parameter asm_diskgroups specifies the name of the disk group to be mounted when the ASM instance is started or when the alter diskgroup all mount statement is executed, that is, when the ASM instance is started, all disk groups specified by this parameter will be mounted, or when the alter diskgroup all mount/dismount statement is executed, all disk groups specified by this parameter will also be mounted.

The value of this parameter is automatically maintained by ASM and does not require human intervention or modification.

1 when a disk group is successfully created or mounted, the name of the disk group will be automatically added to this parameter.

2 when you delete or unmount a disk group, the name of the disk group will be removed from this parameter accordingly.

Note:

If you are mounting or uninstalling using alter diskgroup all mount or alter diskgroup all dismount, the value of this parameter will not change!

The value of this parameter is affected only when alter diskgroup xxx mount or alter diskgroup xxx dismount is executed during mount or unmount.

The experiments are as follows:

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.

View the contents of the file:

[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'

On Node 2

SQL > alter system set asm_diskgroups='DATA2' scope=spfile sid='+ASM2'

System altered.

SQL > show parameter asm_diskgroups

# # after manual operation here, there is no information in asm_diskgroups!

NAME TYPE VALUE

Asm_diskgroups string

SQL > create pfile='/tmp/asm_20110905.ora' from spfile

File created.

View the generated file!

[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'-- added by hand!

* .asm_power_limit=1

* .diagnostic_dest='/opt/rac/grid'

* .instance_type='asm'

* .large_pool_size=12M

* .remote_login_passwordfile='EXCLUSIVE'

Check the status of the DATA2 on node 2:

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 is not started on Node 2!

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.

After SQL > show parameter asm_diskgroups; # mount DATA2 disk, asm_diskgroups displays the data 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

# # added by oracle itself! However, pay attention to the Manual Mount prompt, manual mount.

* .asm_power_limit=1

* .diagnostic_dest='/opt/rac/grid'

* .instance_type='asm'

* .large_pool_size=12M

* .remote_login_passwordfile='EXCLUSIVE'

There is a bug 8663101 here in 11.2.0.1! Related to the mount status of the disk!

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.