RAC创建ASM单个磁盘不能操作2T

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

clip_image002

clip_image004

clip_image006

bootinfo –s hdisk8

clip_image008

clip_image010

移除已经创建好的数据库,删除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,如下

clip_image012

参考:

http://hi.baidu.com/faceok/blog/item/89c5cc81673df0d7bc3e1ea6.html

  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

clip_image014

clip_image016

clip_image018

请使用浏览器的分享功能分享到微信等