报错求教reached maximum ASM file size (16384 GB)

[bkuai]

ORA-15095: reached maximum ASM file size (16384 GB)

创建表空间28000G时报错 ：


SQL> CREATE BIGFILE TABLESPACE tanadata DATAFILE '+DATA/ORCL/tanadata.dbf' SIZE 28000G
*
ERROR at line 1:
ORA-01119: error in creating database file '+DATA/ORCL/tanadata.dbf'
ORA-17502: ksfdcre:4 Failed to create file +DATA/ORCL/tanadata.dbf
ORA-15095: reached maximum ASM file size (16384 GB)

求指导

[秋雨飘落]

单个数据文件无需建这么大，普通的数据文件保留10G大小就差不多了~~~

[bkuai]

请问谁知道为什么会有16384 GB 限制 这个限制在哪里解除

[sleepzzzzz]

Cause
The limit on an ASM File is dependent on the compatible.rdbms attribute value and the redundancy of the diskgroup.

This is discussed at http://download.oracle.com/docs/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94136

So, either the limit has reached or you are trying to enlarge a file created with compatible.rdbms set to 10.1( default value).

Note that you can set the diskgroup attribute compatible.rdbms to a value greater than 10.1 with alter diskgroup command ( v$asm_attribute ), but the file size limit will be the old limit for the existing files. The new value of compatible.rdbms will be effective for the new files only.




Solution
You can move the file to a different diskgroup having compatible.rdbms set to a value greater than 10.1