利用Oracle RAC 11gR2 新特性renamedg来更改diskgroup name(二)

2015-01-21 12:31:42 · 作者: · 浏览: 10
ion Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options



SQL> select name,state from v$asm_diskgroup;



NAME? ? ? ? ? ? ? ? ? ? ? ? ? STATE
------------------------------ -----------
DATADG? ? ? ? ? ? ? ? ? ? ? ? DISMOUNTED
OCRDG? ? ? ? ? ? ? ? ? ? ? ? ? MOUNTED



SQL> alter diskgroup datadg mount;



Diskgroup altered.



SQL> select name,state from v$asm_diskgroup;



NAME? ? ? ? ? ? ? ? ? ? ? ? ? STATE
------------------------------ -----------
DATADG? ? ? ? ? ? ? ? ? ? ? ? MOUNTED
OCRDG? ? ? ? ? ? ? ? ? ? ? ? ? MOUNTED



grid@sundb01:/home/grid>asmcmd
ASMCMD> lsdg
State? ? Type? ? Rebal? Sector? Block? ? ? AU? Total_MB? Free_MB? Req_mir_free_MB? Usable_file_MB? Offline_disks? Voting_files? Name
MOUNTED? NORMAL? N? ? ? ? 512? 4096? 1048576? ? 358400? 358192? ? ? ? ? ? ? ? 0? ? ? ? ? 179096? ? ? ? ? ? ? 0? ? ? ? ? ? N? DATADG/
MOUNTED? NORMAL? N? ? ? ? 512? 4096? 1048576? ? 15360? ? 14434? ? ? ? ? ? 5120? ? ? ? ? ? 4657? ? ? ? ? ? ? 0? ? ? ? ? ? Y? OCRDG/
ASMCMD>
ASMCMD> exit
grid@sundb01:/home/grid>sqlplus / as sysasm



SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 10 12:39:41 2014



Copyright (c) 1982, 2011, Oracle.? All rights reserved.


?



Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options



SQL> select name,path from v$asm_disk;



NAME? ? ? ? ? ? ? ? ? ? ? ? ? PATH
------------------------------ ----------------------------------------
OASMDGDATA01_0000? ? ? ? ? ? ? /dev/rhdisk1? ? -----从此处发现,其实即使更改了diskgroup的name,disk name也没有改变。
OASMDGDATA01_0001? ? ? ? ? ? ? /dev/rhdisk2? ? -----通过kfed查看磁盘头信息仍然会发现diskgroup name 还是之前的那个名称。
OCRDG_0000? ? ? ? ? ? ? ? ? ? /dev/rhdisk3
OCRDG_0001? ? ? ? ? ? ? ? ? ? /dev/rhdisk4
OCRDG_0002? ? ? ? ? ? ? ? ? ? /dev/rhdisk5



此处还需要将crs中的OASMDGDATA01信息给删除:
grid@sundb01:/home/grid>crs_stat
NAME=ora.DATADG.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on sundb01



NAME=ora.OASMDGDATA01.dg
TYPE=ora.diskgroup.type
TARGET=OFFLINE
STATE=OFFLINE



grid@sundb01:/home/grid>crsctl delete resource ora.OASMDGDATA01.dg
grid@sundb01:/home/grid>crs_stat -t
Name? ? ? ? ? Type? ? ? ? ? Target? ? State? ? Host? ? ? ?
------------------------------------------------------------
ora.DATADG.dg? ora....up.type ONLINE? ? ONLINE? ? sundb01? ?
ora....ER.lsnr ora....er.type ONLINE? ? ONLINE? ? sundb01? ?
ora....R1.lsnr ora....er.type ONLINE? ? ONLINE? ? sundb01? ?
ora....N1.lsnr ora....er.type ONLINE? ? ONLINE? ? sundb01? ?
ora.OCRDG.dg? ora....up.type ONLINE? ? ONLINE? ? sundb01? ?
ora.asm? ? ? ? ora.asm.type? ONLINE? ? ONLINE? ? sundb01? ?
ora.cvu? ? ? ? ora.cvu.type? ONLINE? ? ONLINE? ? sundb01? ?
ora.gsd? ? ? ? ora.gsd.type? OFFLINE? OFFLINE? ? ? ? ? ? ?
ora....SM1.asm application? ? ONLINE? ? ONLINE? ? sundb01? ?
ora....01.lsnr application? ? ONLINE? ? ONLINE? ? sundb01? ?
ora....01.lsnr application? ? ONLINE? ? ONLINE? ? sundb01? ?
ora....b01.gsd application? ? OFFLINE? OFFLINE? ? ? ? ? ? ?
ora....b01.ons application? ? ONLINE? ? ONLINE? ? sundb01? ?
ora....b01.vip ora....t1.type ONLINE? ? ONLINE? ? sundb01? ?
ora....SM2.asm application? ? ONLINE? ? ONLINE? ? sundb02? ?
ora....02.lsnr application? ? ONLINE? ? ONLINE? ? sundb02? ?
ora....02.lsnr application? ? ONLINE? ? ONLINE? ? sundb02? ?
ora....b02.gsd application? ? OFFLINE? OFFLINE? ? ? ? ? ? ?
ora....b02.ons application? ? ONLINE? ? ONLINE? ? sundb02? ?
ora....b02.vip ora....t1.type ONLINE? ? ONLINE? ? sundb02? ?
ora....network ora....rk.type ONLINE? ? ONLINE? ? sundb01? ?
ora.oc4j? ?