ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 节点2在线日志生成归档日志在节点1上的初步分析

节点2在线日志生成归档日志在节点1上的初步分析

原创 Linux操作系统 作者:paulyibinyi 时间:2011-08-03 16:59:00 0 删除 编辑
    oracle rac 2节点
 
昨天去客户现场做数据库安全方面的调研,客户问到一个问题,怎么节点2的在线日志生成的归档日志怎么跑到节点1上去了
 
分析过程大概如下:
节点2down机:
lert_gzgjj2.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/gzgjj/bdump/gzgjj2_lms2_4540.trc:
ORA-29702: error occurred in Cluster Group Service operation
Sat Jul 30 13:26:00 2011
Errors in file /oracle/admin/gzgjj/bdump/gzgjj2_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/gzgjj/bdump/gzgjj2_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/gzgjj/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/gzgjj/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上。
 
 
 
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-704009/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6597197