背景:因为RAC的一个节点故障,需要关闭asm实例
数据库:Oracle 11GR2
1.切换到grid账户
[root@netrac_node02 ~]# su - grid
2.进入数据库
[grid@netrac_node02 ~]$ sqlplus "/as sysdba"
3.查看当前实例
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
2 +ASM2
netrac_node02
11.2.0.4.0 20-FEB-17 STARTED YES 0 STOPPED
ALLOWED NO ACTIVE UNKNOWN NORMAL NO
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
2 +ASM2
netrac_node02
11.2.0.4.0 20-FEB-17 STARTED YES 0 STOPPEDALLOWED NO ACTIVE UNKNOWN NORMAL NO
4.想直接关闭asm实例,但是没有权限,需切换之sysasm用户
SQL> shutdown immediate
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
5.切换sysasm用户,关闭实例
SQL> conn /as sysasm
Connected.
SQL> shutdown immediate
Connected.
SQL> shutdown immediate
本文介绍如何在Oracle11GR2环境下,由于RAC节点故障需关闭ASM实例的过程。首先切换到grid账户并登录数据库,尝试直接关闭失败后,通过sysasm用户成功关闭实例。

696

被折叠的 条评论
为什么被折叠?



