RAC11g删除ASM磁盘组

  因为公司近期打算将生成环境的共享存储替换掉，即用新的挂载点，那么简单来说就是用新的ASM磁盘组或者利用rebalace进行转移。为此周末打算在家模拟测试。因为家用配置问题，首先先尝试删除磁盘组作其他测试。

例子：在11gR2 RAC中将ASM磁盘组THREE给drop掉，这个磁盘组主要是存储归档，因为测试，所以打算drop掉。（虚拟化）

0.当前crs状态
[grid@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora.ONE.dg     ora....up.type ONLINE    ONLINE    rac1        
ora.TWO.dg     ora....up.type ONLINE    ONLINE    rac1        
ora.THREE.dg    ora....up.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.eons       ora.eons.type  ONLINE    ONLINE    rac1        
ora.gsd        ora.gsd.type   ONLINE    ONLINE    rac1        
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1        
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora.racdb.db   ora....se.type ONLINE    ONLINE    rac1        
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1


1.首先将两个节点down掉
[oracle@rac1 ~]$ srvctl stop instance -d RACDB -n rac1 
[oracle@rac2 ~]$ srvctl stop instance -d RACDB -n rac2

2.将节点1到mount状态，取消归档模式(没开闪回模式)
[oracle@rac1 ~]$ srvctl start instance -d RACDB -n rac1 -o mount
SQL> alter database noarchivelog;
SQL> alter system set log_archive_dest_1='';

3.将节点1down掉
[oracle@rac1 ~]$ srvctl stop instance -d RACDB -n rac1 

4.节点1和节点2进行+ASM实例将ASM磁盘组THREE给dismount
[grid@rac1 ~]$ sqlplus / as sysasm
SQL> alter diskgroup THREE dismount;

[grid@rac2 ~]$ sqlplus / as sysasm
SQL> alter diskgroup THREE dismount;

SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
ONE                            MOUNTED
THREE                          DISMOUNTED
TWO                            MOUNTED



5.在节点1上drop掉ASM磁盘组THREE
SQL> drop diskgroup THREE including contents;

这里没有成功drop掉，所以使用force
SQL> drop diskgroup THREE force including contents;

Diskgroup dropped.

**如果报错 ORA-15039、 ORA-15001，说明 可能没有dismount；


6.删除crs服务(diskgroup)
[grid@rac1 dbs]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora.ONE.dg     ora....up.type ONLINE    ONLINE    rac1        
ora.THREE.dg   ora....up.type ONLINE    OFFLINE               
ora.TWO.dg     ora....up.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.eons       ora.eons.type  ONLINE    ONLINE    rac1        
ora.gsd        ora.gsd.type   ONLINE    ONLINE    rac1        
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1        
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora.racdb.db   ora....se.type ONLINE    OFFLINE               
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1


[grid@rac1 dbs]$ srvctl stop diskgroup -g THREE
[grid@rac1 dbs]$ srvctl remove diskgroup -g THREE



7.节点1启动实例（报错）
[oracle@rac1 ~]$ srvctl start instance -d RACDB -n rac1
PRCR-1013 : Failed to start resource ora.racdb.db
PRCR-1064 : Failed to start resource ora.racdb.db on node rac1
ORA-15032: not all alterations performed
ORA-15017: diskgroup "THREE" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "THREE"

CRS-2674: Start of 'ora.THREE.dg' on 'rac1' failed

因为没有在crs中更新

[oracle@rac1 ~]$ srvctl config database -d RACDB
Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +TWO/RACDB/spfileRACDB.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RACDB
Database instances: RACDB1,RACDB2
PRCD-1012 : Failed to retrieve disk group list for database RACDB.
PRCR-1035 : Failed to look up CRS resource ora.THREE.dg for RACDB
PRCR-1001 : Resource ora.THREE.dg does not exist


更新crs信息，要用root用户
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/srvctl modify database -d RACDB -a ONE,TWO

[root@rac1 ~]# /u01/app/11.2.0/grid/bin/srvctl config database -d RACDB -a 
Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +TWO/RACDB/spfileRACDB.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RACDB
Database instances: RACDB1,RACDB2
Disk Groups: ONE,TWO
Services: 
Database is enabled
Database is administrator managed


[oracle@rac1 ~]$ srvctl start instance -d RACDB -n rac1

[grid@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.FOUR.dg    ora....up.type ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora.ONE.dg     ora....up.type ONLINE    ONLINE    rac1        
ora.TWO.dg     ora....up.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.eons       ora.eons.type  ONLINE    ONLINE    rac1        
ora.gsd        ora.gsd.type   ONLINE    ONLINE    rac1        
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1        
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora.racdb.db   ora....se.type ONLINE    ONLINE    rac1        
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1

成功启动

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30220976/viewspace-1837025/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30220976/viewspace-1837025/