ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 数据库磁盘组属性

oracle 数据库磁盘组属性

原创 Linux操作系统 作者:paulyibinyi 时间:2012-03-31 15:16:54 0 删除 编辑

Disk Group Attributes

Disk 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.

  • ACCESS_CONTROL.ENABLED

    This attribute can only be set when altering a disk group.

    For information about the 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 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 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 COMPATIBLE.ASM attribute, see "COMPATIBLE.ASM".

  • COMPATIBLE.RDBMS

    For information about the COMPATIBLE.RDBMS attribute, see "COMPATIBLE.RDBMS".

  • COMPATIBLE.ADVM

    For information about the COMPATIBLE.ADVM attribute, see "COMPATIBLE.ADVM" and "Overview of Oracle ASM Dynamic Volume Manager".

  • CONTENT.TYPE

    The CONTENT.TYPE attribute identifies the disk group type: data, recovery, or 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 data which specifies a distance of 1 to the nearest neighbor disk. A value of recovery specifies a distance of 3 to the nearest neighbor disk and a value of system specifies a distance of 5.

    The attribute can be specified when creating or altering a disk group. If CONTENT.TYPE attribute is set or changed using ALTER DISKGROUP, then the new configuration does not take effect until a disk group rebalance is explicitly run.

    The CONTENT.TYPE attribute is only valid for disk groups that are set to normal or high redundancy. The COMPATIBLE.ASM attribute must be set to 11.2.0.3 or higher to enable the 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 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 SECTOR_SIZE attribute, see "Specifying the Sector Size for Drives".

  • STORAGE.TYPE

    The STORAGE.TYPE disk group attribute specifies the type of the disks in the disk group. The possible values are AXIOM, ZFSSA, and OTHER. If the attribute is set to AXIOM or ZFSSA, then all disks in the disk group must be of that type. If the attribute is set to OTHER, then any types of disks can be in the disk group.

    If the STORAGE.TYPE disk group attribute is set to AXIOM or 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 STORAGE.TYPE attribute, the COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 11.2.0.3 or higher. For information about disk group compatibility attributes, refer to "Disk Group Compatibility".

    The 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 V$ASM_ATTRIBUTE view or with the ASMCMD 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.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-720052/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6586032