oracle rac磁盘不大于2T,RAC创建ASM单个磁盘不能操作2T

安装问题2：ASM单个磁盘不能操作2T

bootinfo –s hdisk8

移除已经创建好的数据库，删除asm卷组及磁盘：

p7402:/home/oracle$export ORACLE_SID=+ASM2

p7402:/home/oracle$sqlplus / as sysdba

SQL> select instance_name from v$instance;

INSTANCE_NAME

--------------------------------

+ASM2

SQL> shutdown immediate

ASM diskgroups dismounted

ASM instan

停止实例2(+ASM2)后连接到实例(+ASM1)将卷组删除

p7401:/home/oracle$export ORACLE_SID=+ASM1

p7401:/home/oracle$sqlplus / as sysdba

SQL> select instance_name from v$instance;

INSTANCE_NAME

--------------------------------

+ASM1

SQL> show parameter spfile

NAME TYPE VALUE

------------------------------

spfile string

SQL> drop diskgroup NCDATA including contents;

Diskgroup dropped.

SQL>

SQL> select name from v$asm_diskgroup;

no rows selected

SQL> shutdown

ORA-15100: invalid or missing diskgroup name

ASM instance shutdown

SQL> exit

[oracle@node1 ~]$ oradism -delete -asmsid +ASM

[oracle@node1 ~]$ oradism -delete -asmsid +ASM1

[oracle@node1 ~]$ oradism -delete -asmsid +ASM2

p7401:/oracle/admin$vi /etc/oratab

+ASM1:/oracle/db /10.2/db_1:N

p7401:/oracle/admin$srvctl remove asm -n p7401 -i ASM1

p7401:/oracle/admin$srvctl remove asm -n p7402 -i ASM2

p7401:/oracle/admin$crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....01.lsnr application ONLINE ONLINE p7401

ora.p7401.gsd application ONLINE ONLINE p7401

ora.p7401.ons application ONLINE ONLINE p7401

ora.p7401.vip application ONLINE ONLINE p7401

ora....02.lsnr application ONLINE ONLINE p7402

ora.p7402.gsd application ONLINE ONLINE p7402

ora.p7402.ons application ONLINE ONLINE p7402

ora.p7402.vip application ONLINE ONLINE p7402

重新LUN单个500G，如下

参考：

ASM存储系统有如下限制：

每个存储系统最多63个Disk groups

每个存储系统最多10，000个ASM disks

每个磁盘组最多1 Million 文件

为避免复杂性，建议不要超过2个磁盘组：

DATA : datafiles, control files, online redo logs

Flash recovery area : Control file，online redo log， archived redo log

ASM磁盘的大小限制：<= 2TB, 有例证如下：

SQL> create diskgroup FLASH_RECOVERY_AREA external redundancy disk 'ORCL:ASM5';

create diskgroup FLASH_RECOVERY_AREA external redundancy disk 'ORCL:ASM5'

*

ERROR at line 1:

ORA-15018: diskgroup cannot be created

ORA-15099: disk 'ORCL:ASM5' is larger than maximum size of 2097152 MBs