oracle数据库ASM磁盘组属性

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:32

oracle数据库ASM磁盘组属性

Disk Group AttributesDisk group attributes are parameters that are bound to a disk group, rather than an Oracle ASM instance.
Disk group attributes can be set when a disk group is created or altered, unless otherwise noted in the following list.
[list]
[*]ACCESS_CONTROL.ENABLED
This attribute can only be set when altering a disk group.
For information about the [font=NSimsun]ACCESS_CONTROL.ENABLED attribute, see "Setting Disk Group Attributes for Oracle ASM File Access Control".

[*]ACCESS_CONTROL.UMASK
This attribute can only be set when altering a disk group.
For information about the [font=NSimsun]ACCESS_CONTROL.UMASK attribute, see "Setting Disk Group Attributes for Oracle ASM File Access Control".

[*]AU_SIZE
This attribute can only be set when creating a disk group.
For information about allocation unit size and extents, see "Allocation Units", "Extents", and "Specifying the Allocation Unit Size". For an example of the use of the [font=NSimsun]AU_SIZE attribute, see Example 4-1, "Creating the DATA disk group".

[*]CELL.SMART_SCAN_CAPABLE
This attribute is only applicable to Oracle Exadata storage.
See Also:Oracle Exadata documentation

[*]COMPATIBLE.ASM
For information about the [font=NSimsun]COMPATIBLE.ASM attribute, see "COMPATIBLE.ASM".

[*]COMPATIBLE.RDBMS
For information about the [font=NSimsun]COMPATIBLE.RDBMS attribute, see "COMPATIBLE.RDBMS".

[*]COMPATIBLE.ADVM
For information about the [font=NSimsun]COMPATIBLE.ADVM attribute, see "COMPATIBLE.ADVM" and "Overview of Oracle ASM Dynamic Volume Manager".

[*]CONTENT.TYPE
The [font=NSimsun]CONTENT.TYPE attribute identifies the disk group type: [font=NSimsun]data, [font=NSimsun]recovery, or [font=NSimsun]system. The type value determines the distance to the nearest neighbor disk in the failure group where Oracle ASM mirrors copies of the data. The default value is [font=NSimsun]data which specifies a distance of 1 to the nearest neighbor disk. A value of [font=NSimsun]recovery specifies a distance of 3 to the nearest neighbor disk and a value of [font=NSimsun]system specifies a distance of 5.
The attribute can be specified when creating or altering a disk group. If [font=NSimsun]CONTENT.TYPE attribute is set or changed using [font=NSimsun]ALTER [font=NSimsun]DISKGROUP, then the new configuration does not take effect until a disk group rebalance is explicitly run.
The [font=NSimsun]CONTENT.TYPE attribute is only valid for disk groups that are set to normal or high redundancy. The [font=NSimsun]COMPATIBLE.ASM attribute must be set to [font=NSimsun]11.2.0.3 or higher to enable the [font=NSimsun]CONTENT.TYPE attribute for the disk group.
The attribute can be set with SQL, ASMCMD, or ASMCA. For example:
SQL> CREATE DISKGROUP data NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1' NAME diska1,... ATTRIBUTE 'compatible.asm' = '11.2.0.3', 'content.type' = 'recovery',...SQL> ALTER DISKGROUP data SET ATTRIBUTE 'content.type' = 'data';This attribute is primarily intended for use with Oracle Exadata storage.
See Also:Oracle Exadata documentation

[*]DISK_REPAIR_TIME
This attribute can only be set when altering a disk group.
For information about the [font=NSimsun]DISK_REPAIR_TIME attribute, see "Oracle ASM Fast Mirror Resync".

[*]IDP.BOUNDARY and IDP.TYPE
These attributes are intended for use with Oracle Exadata storage.
See Also:Oracle Exadata documentation

[*]SECTOR_SIZE
This attribute can only be set when creating a disk group.
For information about the [font=NSimsun]SECTOR_SIZE attribute, see "Specifying the Sector Size for Drives".

[*]STORAGE.TYPE
The [font=NSimsun]STORAGE.TYPE disk group attribute specifies the type of the disks in the disk group. The possible values are [font=NSimsun]AXIOM, [font=NSimsun]ZFSSA, and [font=NSimsun]OTHER. If the attribute is set to [font=NSimsun]AXIOM or [font=NSimsun]ZFSSA, then all disks in the disk group must be of that type. If the attribute is set to [font=NSimsun]OTHER, then any types of disks can be in the disk group.
If the [font=NSimsun]STORAGE.TYPE disk group attribute is set to [font=NSimsun]AXIOM or [font=NSimsun]ZFSSA, then functionality for Hybrid Columnar Compression (HCC) can be enabled for Pillar Axiom or ZFS storage.
Note:ZFS storage must be added through Direct NFS (dNFS) and Pillar Axiom storage must be added as SCSI/Fiber Channel.
To set the [font=NSimsun]STORAGE.TYPE attribute, the [font=NSimsun]COMPATIBLE.ASM and [font=NSimsun]COMPATIBLE.RDBMS disk group attributes must be set to [font=NSimsun]11.2.0.3 or higher. For information about disk group compatibility attributes, refer to "Disk Group Compatibility".
The [font=NSimsun]STORAGE.TYPE attribute can be set when creating a disk group or when altering a disk group. The attribute cannot be set when clients are connected to the disk group. For example, the attribute cannot be set when an Oracle ADVM volume is enabled on the disk group.
The attribute is not visible in the [font=NSimsun]V$ASM_ATTRIBUTE view or with the ASMCMD [font=NSimsun]lsattr command until the attribute has been set.
See Also:Oracle Database Concepts for more information about Hybrid Columnar Compression. Hybrid Columnar Compression is a feature of certain Oracle storage systems.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】