lxhbww

164 积分	0 好友	16 主题

发消息

[RAC性能调优] 11gr2 rac ORA-00235 不带锁定的控制文件读取因并发更新而不.....

1^#

发表于 2013-10-25 14:36:23 | 查看: 9184| 回复: 7

请教下各位大师们，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 回复只看该作者道具举报

ericcrg

2^#

发表于 2013-10-25 18:12:01

口令变更过？standby2拒绝归档文件的正常传输，主机的checkpoint进程在持续的更新datafile头文件和控制文件。

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-10-25 18:13:53

上传下 /app/oracle/diag/rdbms/data/data1/trace/data1_nsa2_2531.trc:

回复只看该作者道具举报

lxhbww

4^#

发表于 2013-10-25 19:55:11

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

data1_nsa2_2531.rar

19.4 KB, 下载次数: 762

回复只看该作者道具举报

lxhbww

5^#

发表于 2013-10-25 21:33:14

口令没变过，版本是11.2.0.2.0 主库和备库操作系统和数据库版本一致.

回复只看该作者道具举报

lunar

6^#

发表于 2013-10-28 12:00:14

怀疑是Bug 12368540，具体要根据trace去匹配函数

回复只看该作者道具举报

Maclean Liu(刘相兵

7^#

发表于 2013-10-29 22:22:39

*** 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!

ODM FINDING:

n ALERT.LOG of the Primary Database ORA-235 is raised.

CAUSE

ORA-00235: controlfile fixed table inconsistent due to concurrent update
Cause: Concurrent update activity on a controlfile caused a query on a controlfile fixed table to read inconsistent information.

SOLUTION

Explanation for this particular Issue can be found in

Bug 12368540: ARC AND RFS CAUSES ORA-235 FREQUENTLY ON DATA GUARD 11.2.0.2

You can safely ignore those Messages from the NSA-Process. The Process is trying to read from the Controlfile without acquireing an Enqueue for Performance Reasons.

So it is possible that another Process currently holding the Controlfile Enqueue is modifying it while this Process is reading the same Information and so the ORA-235 is raised. Ensure you have not enabled Archive Tracing (log_archive_trace = 0) unless necessary to avoid additional Dumping Information to be written into a Background Process Tracefile when this Error is raised.

REFERENCES

BUG:12368540 - ARC AND RFS CAUSES ORA-235 FREQUENTLY ON DATA GUARD 11.2.0.2

一般可以忽略该问题

回复只看该作者道具举报

lxhbww

8^#

发表于 2013-11-3 09:48:35

Maclean Liu(刘相兵发表于 2013-10-29 22:22
*** 2013-10-25 00:26:35.931
LOG_ARCHIVE_DEST_3 depends upon me, but my destination index 1 does not ...

ok,谢谢!

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册