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

ASM_DISKGROUPS = diskgroup [, diskgroup ] ...

Default value

There is no default value.

Modifiable

ALTER SYSTEM

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


数据运维技术 » Oracle 参数 ASM_DISKGROUPS 官方解释,作用,如何配置最优化建议