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，如下

參考：

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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/21754115/viewspace-1370399/，如需轉載，請註明出處，否則將追究法律責任。