归档日志传输不过去

asllk

环境说明
----------------------------------------------------------------------------
OS：Windows 2008 R2企业版 64bit
DB：11.2.0.1.0

主库和备库的日志放在同一个共享存储上
----------------------------------------------------------------------------

上周机房遭雷击断电，工作人员过后只起了主库，没有起备库，过了两天才发现。手动启动备库后，发现归档日志传输出现问题了。请帮忙看看，谢谢

tiejiang2009

为什么还有这么多windows？

nan_dream

Maclean Liu(刘相兵 发表于 2013-4-1 22:31
ORA-00600: internal error code, arguments: [krsr_rfs_wda.hdr_corrupt]可能有对应的BUG 和patch，但是这 ...

这个600的代码在MOS上面找不到，应该是未知的bug。。话说很多生产库用的都是11.2.0.1的版本

asllk

哦 谢谢

Maclean Liu(刘相兵

ORA-00600: internal error code, arguments: [krsr_rfs_wda.hdr_corrupt]可能有对应的BUG 和patch，但是这里不给出了。

我要说的是：

1 、11.2.0.1 不是给生产用的版本了， 请没有任何理由的升级！！  除非你在用盗版！
2、 win上的Oracle即不可靠也不稳定，个人经验

Maclean Liu(刘相兵

Errors in file d:\app\administrator\diag\rdbms\itacprod\itacprod\trace\itacprod_arcn_940.trc:
ORA-16099: internal error ORA-00600 occurred at standby database
Errors in file d:\app\administrator\diag\rdbms\itacprod\itacprod\trace\itacprod_arcn_940.trc:
ORA-16099: internal error ORA-00600 occurred at standby database
Errors in file d:\app\administrator\diag\rdbms\itacprod\itacprod\trace\itacprod_arcn_940.trc:
ORA-16099: internal error ORA-00600 occurred at standby database


RFS[79]: Opened log for thread 1 sequence 15 dbid -328035756 branch 808427734
CORRUPTION DETECTED: In redo blocks starting at block 1count 266 for thread 1 sequence 15
Errors in file d:\app\administrator\diag\rdbms\itacstandby\itacstandby\trace\itacstandby_rfs_2572.trc  (incident=8434):
ORA-00600: internal error code, arguments: [krsr_rfs_wda.9], [2], [], [], [], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\itacstandby\itacstandby\trace\itacstandby_rfs_2572.trc:
ORA-00272: error writing archive log F:\APP\ADMINISTRATOR\ORADATA\ITACSTANDBY\ARCH\1_12_808427734.ARC
ORA-00600: internal error code, arguments: [krsr_rfs_wda.9], [2], [], [], [], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\itacstandby\itacstandby\trace\itacstandby_rfs_956.trc  (incident=8433):
ORA-00600: internal error code, arguments: [krsr_rfs_wda.9], [2], [], [], [], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\itacstandby\itacstandby\trace\itacstandby_rfs_956.trc:
ORA-00272: error writing archive log F:\APP\ADMINISTRATOR\ORADATA\ITACSTANDBY\ARCH\1_13_808427734.ARC
ORA-00600: internal error code, arguments: [krsr_rfs_wda.9], [2], [], [], [], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\itacstandby\itacstandby\trace\itacstandby_rfs_632.trc  (incident=7698):
ORA-00600: internal error code, arguments: [krsr_rfs_wda.9], [2], [], [], [], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\itacstandby\itacstandby\trace\itacstandby_rfs_632.trc:
ORA-00272: error writing archive log F:\APP\ADMINISTRATOR\ORADATA\ITACSTANDBY\ARCH\1_15_808427734.ARC
ORA-00600: internal error code, arguments: [krsr_rfs_wda.9], [2], [], [], [], [], [], [], [], [], [], []
RFS[75]: Selected log 5 for thread 1 sequence 11 dbid -328035756 branch 808427734
CORRUPTION DETECTED: Header block validation failed for thr 1 seq 11
Errors in file d:\app\administrator\diag\rdbms\itacstandby\itacstandby\trace\itacstandby_rfs_1364.trc  (incident=8431):
ORA-00600: internal error code, arguments: [krsr_rfs_wda.hdr_corrupt], [2], [], [], [], [], [], [], [], [], [], []


根本原因就是 standby在RFS archivelog时出ORA-00600: internal error code, arguments: [krsr_rfs_wda.hdr_corrupt]

Teddy.huang

windows上面原来有过这种情况，如果确定网络已经连通，
把standby对应的log_archive_dest先设为空，再设回去，后面日志就刷刷的过去了。。。。
供参考。