eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Oracle 18c 19c 安装的 DBT-50000 错误解决 | Blog首页 | 2018 ACOUG年会:从BigData到Cloud,Oracle的云上变革 »

Oracle 12c :ASM 存储单盘限制从2TB到4PB的改变
modb.pro

在 Oracle 12c之前,ASM 单盘有一个 2T 的限制,当创建磁盘组单盘超过 2T 时,将会遇到诸如 ORA-15018, ORA-15099 的错误:

ORA-15018: diskgroup cannot be created

ORA-15099: disk '/dev/mapper/ORA_data1p1' is larger than maximum size of 2097152 MBs

MOS 文档 1077784.1 明确说明了这个限制,在Oracle 10g 和 Oracle 11g中,这个问题都是硬限制。

那么到了Oracle 12c 中,这个限制已经被去除,单盘最大限制是 4PB 起。

查了一下文档,转引一下,帮助大家一起更新知识:

Oracle ASM Storage Limits

Oracle ASM provides near unlimited capacity for future growth, but does have some storage limits.

Oracle ASM has the following limits on the number of disk groups, disks, and files:

  • 511 disk groups in a storage system for Oracle Database 12c Release 1 or later

  • 10,000 Oracle ASM disks in a disk group

  • 65530 Oracle ASM disks in a storage system

  • 1 million files for each disk group

Without any Oracle Exadata Storage, Oracle ASM has the following storage limits if the COMPATIBLE.ASM or COMPATIBLE.RDBMS disk group attribute is set to less than 12.1:

  • 2 terabytes (TB) maximum storage for each Oracle ASM disk

  • 20 petabytes (PB) maximum for the storage system

Without any Oracle Exadata Storage, Oracle ASM has the following storage limits if the COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes are set to 12.1 or greater:

  • 4 PB maximum storage for each Oracle ASM disk with the allocation unit (AU) size equal to 1 MB

  • 8 PB maximum storage for each Oracle ASM disk with the AU size equal to 2 MB

  • 16 PB maximum storage for each Oracle ASM disk with the AU size equal to 4 MB

  • 32 PB maximum storage for each Oracle ASM disk with the AU size equal to 8 MB

  • 320 exabytes (EB) maximum for the storage system

With all Oracle Exadata Storage, Oracle ASM has the following storage limits:

  • 4 PB maximum storage for each Oracle ASM disk with the AU size equal to 1 MB

  • 8 PB maximum storage for each Oracle ASM disk with the AU size equal to 2 MB

  • 16 PB maximum storage for each Oracle ASM disk with the AU size equal to 4 MB

  • 32 PB maximum storage for each Oracle ASM disk with the AU size equal to 8 MB

  • 320 EB maximum for the storage system

The maximum size limit of a disk group equals the maximum disk size multiplied by the maximum number of disks in a disk group (10,000).

The maximum number of disks across all disk groups is 10,000. The 10,000 disks can be in one disk group or distributed across a maximum of 511 disk groups. This is a limitation on the number of Oracle ASM disks, not necessarily the number of spindles. A storage array could group multiple spindles into a LUN that is used as a single Oracle ASM disk.

File size limits are dependent on the value of the disk group compatibility attributes. Oracle ASM supports file sizes greater than 128 TB in any redundancy mode when the COMPATIBLE.RDBMS disk group attribute is set greater than 10.1.

If COMPATIBLE.RDBMS is set to 10.1, the file size limits are less. For example, with COMPATIBLE.RDBMS equal to 10.1 and the AU size equal to 1 MB, Oracle ASM file size limits are:

  • External redundancy: 16 TB

  • Normal redundancy: 5.8 TB

  • High redundancy: 3.9 TB

Note:

Oracle Database supports data file sizes up to 128 TB depending on the file system. In addition, Oracle Database has a file size limit that is dependent on the DB_BLOCK_SIZE initialization parameter.


历史上的今天...
    >> 2010-12-17文章:
    >> 2008-12-17文章:
    >> 2007-12-17文章:
    >> 2005-12-17文章:
           北京天下亦有雪

By eygle on 2018-12-17 16:33 | Comments (0) | FAQ | 3324 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com