Oracle RAC集群重启

SQL> show parameter name

NAME TYPE VALUE

---

cell_offloadgroup_name string
db_file_name_convert string
db_name string qzybkf
db_unique_name string qzybkf
global_names boolean FALSE
instance_name string qzybkf1
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string qzybkf

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME STATUS

---

qzybkf1 MOUNTED

SQL> shutdown abort

–切换到集群用户grid
grid
srvctl status listener -n shbxdb1
srvctl stop listener -n shbxdb1
ps -ef |grep -i local=no
srvctl stop instance -o immediate -d qzybkf -i qzybkf1
crs_stat -t -v
srvctl status database -d qzybkf

–关闭集群
root
(find / -name crsctl)
/u01/app/12.1.0/grid/bin/crsctl stop crs

grid
crs_stat -t -v
srvctl stop asm -n shbxdb1
srvctl status asm -n shbxdb1
ps -ef |grep -i asm
ps -ef |grep -i ora

–开启服务器步骤
（1）正常情况下重启服务器，集群会自动启动（等待时间15-20分钟）
（2）手动启动，先查看集群状态
–手动启动，启动集群（一个节点执行即可） ROOT用户
root
(find / -name crsctl)
/u01/app/12.1.0/grid/bin/crsctl start crs
–查看集群状态
grid
crs_stat -t -v
srvctl status asm

oracle
sqlplus / as sysdba
SQL> startup mount
SQL> select * from v$log;
SQL> recover database until time ‘2019-11-05’
SQL> alter database open resetlogs;

grid
srvctl status database -d qzybkf