oracle控制文件没有更新,11gr2 rac ORA-00235 不带锁定的控制文件读取因并发更新而不........

请教下各位大师们,oel5.5+11g r2 rac+二个物理dg

11号01:25和今天25 号凌晨00:30查看rac节点1的alert有报

ORA-00235: 不带锁定的控制文件读取因并发更新而不一致

这会是什么原因引起?节点2的21号00:42也报这个

节点一早上alert报错日志如下

Fri Oct 25 00:26:35 2013

Thread 1 advanced to log sequence 2894 (LGWR switch)

Current log# 6 seq# 2894 mem# 0: +ORADATA/data/onlinelog/group_6.269.823078493

Current log# 6 seq# 2894 mem# 1: +ORAARCH/data/onlinelog/group_6.263.823078493

Fri Oct 25 00:26:35 2013

LNS: Standby redo logfile selected for thread 1 sequence 2894 for destination LOG_ARCHIVE_DEST_2

Fri Oct 25 00:26:37 2013

Archived Log entry 14385 added for thread 1 sequence 2893 ID 0x67753a18 dest 1:

Fri Oct 25 00:27:02 2013

LNS: Standby redo logfile selected for thread 1 sequence 2894 for destination LOG_ARCHIVE_DEST_3

Fri Oct 25 00:27:05 2013

ARC3: Archive log rejected (thread 1 sequence 2893) at host 'standby2'

FAL[server, ARC3]: FAL archive failed, see trace file.

ARCH: FAL archive failed. Archiver continuing

ORACLE Instance data1 - Archival Error. Archiver continuing.

Fri Oct 25 00:30:42 2013

Thread 1 advanced to log sequence 2895 (LGWR switch)

Current log# 1 seq# 2895 mem# 0: +ORADATA/data/onlinelog/group_1.257.823075995

Current log# 1 seq# 2895 mem# 1: +ORAARCH/data/onlinelog/group_1.257.823075997

Fri Oct 25 00:30:42 2013

Errors in file /app/oracle/diag/rdbms/data/data1/trace/data1_nsa2_2531.trc:

ORA-00235: 不带锁定的控制文件读取因并发更新而不一致

Fri Oct 25 00:30:43 2013

Archived Log entry 14391 added for thread 1 sequence 2894 ID 0x67753a18 dest 1:

LNS: Standby redo logfile selected for thread 1 sequence 2895 for destination LOG_ARCHIVE_DEST_2

Fri Oct 25 00:31:20 2013

LNS: Standby redo logfile selected for thread 1 sequence 2895 for destination LOG_ARCHIVE_DEST_3

Fri Oct 25 00:31:24 2013

Thread 1 advanced to log sequence 2896 (LGWR switch)

Current log# 2 seq# 2896 mem# 0: +ORADATA/data/onlinelog/group_2.258.823075997

Current log# 2 seq# 2896 mem# 1: +ORAARCH/data/onlinelog/group_2.258.823075997

Fri Oct 25 00:31:24 2013

LNS: Standby redo logfile selected for thread 1 sequence 2896 for destination LOG_ARCHIVE_DEST_2

Fri Oct 25 00:31:25 2013

Archived Log entry 14394 added for thread 1 sequence 2895 ID 0x67753a18 dest 1:

Fri Oct 25 00:32:09 2013

Thread 1 advanced to log sequence 2897 (LGWR switch)

Current log# 5 seq# 2897 mem# 0: +ORADATA/data/onlinelog/group_5.268.823078485

Current log# 5 seq# 2897 mem# 1: +ORAARCH/data/onlinelog/group_5.262.823078487

Fri Oct 25 00:32:10 2013

LNS: Standby redo logfile selected for thread 1 sequence 2897 for destination LOG_ARCHIVE_DEST_2

Fri Oct 25 00:32:10 2013

Archived Log entry 14396 added for thread 1 sequence 2896 ID 0x67753a18 dest 1:

Fri Oct 25 00:32:10 2013

ARC3: Standby redo logfile selected for thread 1 sequence 2896 for destination LOG_ARCHIVE_DEST_3

Fri Oct 25 00:33:19 2013

LNS: Standby redo logfile selected for thread 1 sequence 2897 for destination LOG_ARCHIVE_DEST_3

Fri Oct 25 00:34:44 2013

ARC0: Archive log rejected (thread 1 sequence 2896) at host 'standby2'

FAL[server, ARC0]: FAL archive failed, see trace file.

ARCH: FAL archive failed. Archiver continuing

ORACLE Instance data1 - Archival Error. Archiver continuing.

Fri Oct 25 00:43:09 2013

Thread 1 advanced to log sequence 2898 (LGWR switch)

Current log# 6 seq# 2898 mem# 0: +ORADATA/data/onlinelog/group_6.269.823078493

Current log# 6 seq# 2898 mem# 1: +ORAARCH/data/onlinelog/group_6.263.823078493

Fri Oct 25 00:43:09 2013

LNS: Standby redo logfile selected for thread 1 sequence 2898 for destination LOG_ARCHIVE_DEST_2

Fri Oct 25 00:43:10 2013

Archived Log entry 14403 added for thread 1 sequence 2897 ID 0x67753a18 dest 1:

Fri Oct 25 00:43:10 2013

LNS: Standby redo logfile selected for thread 1 sequence 2898 for destination LOG_ARCHIVE_DEST_3

Fri Oct 25 01:57:54 2013

Thread 1 advanced to log sequence 2899 (LGWR switch)

Current log# 1 seq# 2899 mem# 0: +ORADATA/data/onlinelog/group_1.257.823075995

Current log# 1 seq# 2899 mem# 1: +ORAARCH/data/onlinelog/group_1.257.823075997

Fri Oct 25 01:57:54 2013

/app/oracle/diag/rdbms/data/data1/trace/data1_nsa2_2531.trc

*** 2013-10-25 00:24:59.870

LOG_ARCHIVE_DEST_3 depends upon me, but my destination index 1 does not match its destination index 2

Log file opened [logno 5]

*** 2013-10-25 00:26:35.931

LOG_ARCHIVE_DEST_3 depends upon me, but my destination index 1 does not match its destination index 2

Log file opened [logno 6]

*** 2013-10-25 00:30:42.269

ORA-00235: 不带锁定的控制文件读取因并发更新而不一致

*** 2013-10-25 00:30:43.878

LOG_ARCHIVE_DEST_3 depends upon me, but my destination index 1 does not match its destination index 2

Redo shipping client performing standby login

*** 2013-10-25 00:30:43.968 4595 krsu.c

Logged on to standby successfully

Client logon and security negotiation successful!

*** 2013-10-25 00:30:44.039

Log file opened [logno 1]

*** 2013-10-25 00:31:24.826

LOG_ARCHIVE_DEST_3 depends upon me, but my destination index 1 does not match its destination index 2

哪位大神遇到过类似问题?这期间没有做rman备份.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值