Oracle RAC数据库单节点轮流重启
0、sqlplus / as sysdba
备份参数文件 create pfile='/home/oracle/pfile.ora' from spfile;
备份控制文件 Alter database backup controlfile to trace;
1、关闭两节点的监听；
2、操作系统层面kill掉所有LOCAL=NO的所有进程，即：连接会话。
ps -ef | grep ucdb |grep LOCAL=NO | grep -v grep | awk '{print $2}' | xargs kill -9
3、关闭节点1
sqlplus / as sysdba
shutdown immediate;
tail -500f alertucdb.log;
4、起动节点1
sqlplus / as sysdba
startup;
tail -500f alertucdb.log
5、等待5-10分钟
6、关闭节点2
sqlplus / as sysdba
shutdown immediate;
tail -500f alertucdb.log;
7、起动节点2
sqlplus / as sysdba
startup;
tail -500f alertucdb.log;