温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

12.2 Extended Disk Groups

发布时间:2020-08-04 19:10:21 来源:ITPUB博客 阅读:140 作者:xychong123 栏目:关系型数据库

An Oracle ASM extended disk group has all the features of a flex disk group, with a specific design to be highly available in an extended (stretch) cluster environment, which contains nodes that span multiple physically separated sites.

The following are characteristics of an extended disk group:

  • The redundancy setting of an extended disk group is set to EXTENDED REDUNDANCY and each file group of the extended disk group has its own redundancy property setting.

  • The redundancy of files and file groups in an extended disk group is specified for each site, rather than for each disk group.

    This means that the number of copies determined by the REDUNDANCY setting is multiplied by the number of data sites. If the REDUNDANCY is set to MIRROR, then that specifies two copies, resulting in four copies total for two data sites.

  • An extended disk group can tolerate the loss of an entire site, plus the loss of up to two failure groups in another site.

    This means that an extended disk group can tolerate failures at the site level in addition to the failure group level.

  • All data sites must have the same number of failure groups during disk group creation.

  • A quota group is specified for each disk group, rather than for each site.

  • The quota group limit is the physical space required for all copies across all sites.

    For example, with two data sites, a 6 M file with redundancy set to MIRROR uses 24 M of the quota limit.

  • There must be a total of three sites, two data sites and one quorum site, to create an extended disk group. Each data site should have three failure groups, and the quorum site should have one failure group.

  • For database files, the redundancy setting is dictated by the redundancy setting of the file groups of the extended disk group.

  • The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 12.2 or greater.

  • The minimum allocation unit (AU) size is 4 M.

  • Converting from another disk group type to an extended disk group is not supported.

  • The SITE specification for failure groups can be inferred from cells if Oracle Exadata has been configured. Otherwise, the site specification can be specified with the SQL statement when creating a disk group.

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI