Oracle 参数 ASM_DISKGROUPS 官方解释,作用,如何配置最优化建议
本站中文解释
ASM_DISKGROUPS微参数有两个作用,1是配置ASM磁盘组的名称,2是指定把某些磁盘组的设备加到某个磁盘组。
正确设置ASM_DISKGROUPS参数的步骤如下:
1.用以下SQL语句查询出所有当前ASM实例可用的磁盘组:
SELECT * FROM V$ASM_DISKGROUP;
2.用ALTER SYSTEM设置ASM_DISKGROUPS参数,格式为:ASM_DISKGROUPS=name或者ASM_DISKGROUPS=’name1,name2, …’
例如:ALTER SYSTEM SET asm_diskgroups=’DATA,DATA2′ SCOPE=BOTH;
3.在指定的ASM磁盘组内创建指定的设备:
ALTER DISKGROUP data ADD DISK ‘/dev/sdd1′ NAME sd_d1 SIZE 100M;
4.用ALTER SYSTEM设置参数,重新启用新设置:
ALTER SYSTEM SET asm_diskgroups=’DATA,DATA2′ SCOPE=SPFILE;
ALTER SYSTEM SET asm_diskgroups=’DATA,DATA2’ SCOPE=MEMORY;
5.重新启动ASM实例以加载新设置:
SHUTDOWN IMMEDIATE;
STARTUP;
官方英文解释
ASM_DISKGROUPS
specifies a list of disk group names that an Oracle ASM instance mounts at startup when the ALTER DISKGROUP ALL MOUNT
statement is issued.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
There is no default value. |
Modifiable |
|
Modifiable in a PDB |
No |
Range of values |
Comma-separated list of strings, up to 30 characters |
Basic |
No |
Oracle RAC |
Multiple instances can have different values. |
Note:
This parameter may only be specified in an Oracle Automatic Storage Management (Oracle ASM) instance.
The Oracle ASM instance startup process executes ALTER DISKGROUP ALL MOUNT
unless the NOMOUNT
startup option is specified.
The ASM_DISKGROUPS
parameter is dynamic. If you are using a server parameter file (SPFILE), then you do not have to manually alter the value of ASM_DISKGROUPS
in most situations. Oracle ASM automatically adds a disk group to the parameter when the disk group is successfully created or mounted. Oracle ASM also automatically removes a disk group from the parameter when the disk group is dropped. However, the SPFILE is not updated on a manual dismount.
Issuing the ALTER DISKGROUP...ALL MOUNT
or ALTER DISKGROUP...ALL DISMOUNT
command does not affect the value of this parameter.
Supporting Up to 511 Disk Groups for an Oracle ASM Instance
In Oracle Database 12c Release 1 or later, Oracle ASM configurations support up to 511 disk groups. Oracle ASM configurations with Oracle Database releases before 12c Release 1 can only support up to 63 disk groups.
See Also:
Oracle Automatic Storage
Management Administrator’s Guide for more information about and examples of using this parameter