Oracle rac数据库节点2在线日志生成归档日志在节点1上的初步分析

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:36

Oracle rac数据库节点2在线日志生成归档日志在节点1上的初步分析

昨天去客户现场做数据库安全方面的调研,客户问到一个问题,怎么节点2的在线日志生成的归档日志怎么跑到节点1上去了

分析过程大概如下:
节点2down机:
alert_gz2.log (0%)
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwpost0
ORA-27303: additional information: ukid = 874057518489215114, errno = 22
LMON: terminating instance due to error 29702
Sat Jul 30 13:26:00 2011
Errors in file /oracle/admin/gz/bdump/gz2_lms2_4540.trc:
ORA-29702: error occurred in Cluster Group Service operation
Sat Jul 30 13:26:00 2011
Errors in file /oracle/admin/gz/bdump/gz2_lms0_4536.trc:
ORA-29702: error occurred in Cluster Group Service operation
Sat Jul 30 13:26:00 2011
System state dump is made for local instance
System State dumped to trace file /oracle/admin/gz/bdump/gz2_diag_4528.trc
Sat Jul 30 13:26:04 2011
Instance terminated by LMON, pid = 4532

节点1 13:26分日志如下:
Started redo application at
Thread 2: logseq 9705, block 99429
Sat Jul 30 13:26:03 2011
Recovery of Online Redo Log: Thread 2 Group 6 Seq 9705 Reading mem 0
Mem# 0: +DG1/gz/onlinelog/group_6.268.651752891
Sat Jul 30 13:26:03 2011
Recovery of Online Redo Log: Thread 2 Group 5 Seq 9706 Reading mem 0
Mem# 0: +DG1/gz/onlinelog/group_5.267.651752889
Sat Jul 30 13:26:05 2011
Completed redo application
Sat Jul 30 13:26:06 2011
Completed instance recovery at
Thread 2: logseq 9706, block 49566, scn 1041346872
7450 data blocks read, 7479 data blocks written, 50484 redo blocks read
Switch log for thread 2 to sequence 9707
Sat Jul 30 13:26:09 2011
ARC1: Archiving disabled thread 2 sequence 9707

节点1做实例恢复,生成了节点2 的9706和9707两个归档日志

-rw-rw---- 1 oracle dba 50755584 Jul 30 13:26 2_9706_658773440.dbf
-rw-rw---- 1 oracle dba 2048 Jul 30 13:26 2_9707_658773440.dbf

分析总结如下:

节点2在2011.07.30 13:26 分发生down机,而这个时候业务漂移到节点1上,节点1做数据库实例恢复,该前滚的前滚,
该回滚的回滚,所以节点2的归档日志产生到节点1上。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】