testdb1 2016/09/07 04:11:26 /oracle/app/11.2.0/grid/cdata/testdb-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
#手工备份OCR
su - root
/oracle/app/11.2.0/grid/bin/ocrconfig -export /home/oracle/ocr_bak20160918
###############################################################################################
一. 停止业务
hostname 查看主机
id 查看id
查看每个节点crs状态
crsctl stat res -t
二. 停止CRS相关资源的自启动
1. 停止监听资源
su - oracle
srvctl disable listener
srvctl stop listener
crsctl stat res -t
2. 停止数据库资源(每个节点)
su - oracle
ps -ef|grep LOCAL=NO|awk '{print $2}'|xargs kill -9
select * from v$FAST_START_TRANSACTIONS where UNDOBLOCKSDONE <> UNDOBLOCKSTOTAL; --查看是否有大事物回滚,如存在需等待回滚完毕
select undoblocksdone,undoblockstotal from v$fast_start_transactions where state<>'RECOVERED';
sqlplus / as sysdba
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system checkpoint;
srvctl disable database -d testdb (只需在一个节点操作)
srvctl stop database -d testdb -o immediate (只需在一个节点操作)
crsctl stat res -t
新开窗口 ora log 查看日志
tail -300f /oraclelog/diag/rdbms/testdb/testdb1/trace/alert*.log
tail -300f /oraclelog/diag/rdbms/testdb/testdb2/trace/alert*.log