linux 指定某个节点,11g RAC单独关闭某个节点的疑问

3节点的11.2.0.2 RAC系统， 单独关闭一个节点的测试 。

单独关闭某节点 ：

[root@wsjrac01 ~]# su - grid

wsjrac01$emctl  stop  dbconsole

wsjrac01$srvctl  stop instance  -o  immediate  -d wsjdell  -i wsjdell1

wsjrac01$srvctl  stop  asm  -n  wsjrac01 -f               --  这里必须是 -f ,   否则会报错

wsjrac01$srvctl  stop  listener -n  wsjrac01

这时候状态：

ora....SM1.asm application    OFFLINE   OFFLINE

ora....01.lsnr application    OFFLINE   OFFLINE

ora....c01.gsd application    OFFLINE   OFFLINE

ora....c01.ons application    ONLINE    ONLINE    wsjrac01

ora....c01.vip ora....t1.type ONLINE    ONLINE    wsjrac01

wsjrac01$srvctl  stop  nodeapps  -n  wsjrac01

这时候状态：

ora....SM1.asm application    OFFLINE   OFFLINE

ora....01.lsnr application    OFFLINE   OFFLINE

ora....c01.gsd application    OFFLINE   OFFLINE

ora....c01.ons application    OFFLINE   OFFLINE

ora....c01.vip ora....t1.type OFFLINE   OFFLINE

单独开启某节点(一般来说重新启动Server后会自动开启) ：

[root@wsjrac01 ~]# su - grid

wsjrac01$srvctl  start  nodeapps  -n  wsjrac01

可以看到ons及vip都已经online, network服务也移动到了节点1.

wsjrac01$srvctl  start  asm  -n  wsjrac01

可以看到asm实例及监听都online.  但这时sqlplus登入，数据库实例还是idle的。

wsjrac01$srvctl  start  instance  -d wsjdell  -i wsjdell1

但是在关闭asm 实例时使用 -f  会在asm 实例的alert log 中看到如下提示， 实例是被 shutdown abort 的：

Wed Jun 29 15:46:52 2011

SQL> ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:18217:18064} */

Wed Jun 29 15:47:02 2011

GMON querying group 1 at 10 for pid 18, osid 9224

Wed Jun 29 15:47:02 2011

NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1

Wed Jun 29 15:47:02 2011

ORA-15032: not all alterations performed

ORA-15027: active use of diskgroup "DATA" precludes its dismount

ERROR: ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:18217:18064} */

Wed Jun 29 15:47:02 2011

SQL> ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:18217:18064} */

Wed Jun 29 15:47:12 2011

GMON querying group 1 at 11 for pid 18, osid 9224

Wed Jun 29 15:47:12 2011

NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1

Wed Jun 29 15:47:12 2011

ORA-15032: not all alterations performed

ORA-15027: active use of diskgroup "DATA" precludes its dismount

ERROR: ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:18217:18064} */

Wed Jun 29 15:47:12 2011

SQL> ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:18217:18064} */

Wed Jun 29 15:47:22 2011

GMON querying group 1 at 12 for pid 18, osid 9224

Wed Jun 29 15:47:22 2011

NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1

Wed Jun 29 15:47:22 2011

ORA-15032: not all alterations performed

ORA-15027: active use of diskgroup "DATA" precludes its dismount

ERROR: ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:18217:18064} */

Wed Jun 29 15:47:22 2011

Shutting down instance (abort)

License high water mark = 12

USER (ospid: 9241): terminating the instance

Instance terminated by USER, pid = 9241

Wed Jun 29 15:47:23 2011

Instance shutdown complete

"alert_+ASM1.log" 95L, 4234C

每次这样关闭ASM 倒是有点害怕 ， 毕竟是 shutdown abort ....,    关闭的顺序及步骤是否有不妥的地方， 或者是否有其他方式来单独关闭一个节点 ？

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