|
问题已经解决,11月4日凌晨重启了3个节点。
1.23点停rac2侦听
2.checkpoint 3次,switchlogfile 3次,停job query process,shutdown immediate
3.30分钟后仍然没有down,通过oradebug的trace文件看到:
WAIT #1: nam='instance state change' ela= 986275 p1=1 p2=0 p3=170
WAIT #1: nam='instance state change' ela= 986281 p1=1 p2=0 p3=171
WAIT #1: nam='instance state change' ela= 986287 p1=1 p2=0 p3=172
WAIT #1: nam='instance state change' ela= 986275 p1=1 p2=0 p3=173
……
4.shutdown abort rac2
5.0点停应用
6.停rac3侦听,停rac1侦听
7.在rac3上checkpoint 3次,switchlogfile 3次,停job query process,shutdown immediate
8.30分钟后仍然没有down,通过oradebug的trace文件看到:
WAIT #1: nam='instance state change' ela= 986275 p1=1 p2=0 p3=170
WAIT #1: nam='instance state change' ela= 986281 p1=1 p2=0 p3=171
WAIT #1: nam='instance state change' ela= 986287 p1=1 p2=0 p3=172
WAIT #1: nam='instance state change' ela= 986275 p1=1 p2=0 p3=173
……
9.shutdown abort rac3
10.在rac1上checkpoint 3次,switchlogfile 3次,停job query process,shutdown immediate
11.仍然没有down,通过oradebug的trace文件看到:
WAIT #0: nam='opishd' ela= 986314 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986146 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986281 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986285 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986309 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986193 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986278 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986271 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986277 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986306 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986210 p1=0 p2=0 p3=0
WAIT #0: nam='opishd' ela= 986268 p1=0 p2=0 p3=0
……
12.shutdown abort rac1.
13.重启rac1,正常启动
14.重启rac2,正常启动
15.重启rac3,正常启动
16.检查数据库无异常,恢复job query process和侦听。
17.启动业务,进行业务验证。 |
|