asllk

0 积分	1 好友	1 主题

发消息

[备份恢复] 归档日志传输不过去

1^#

发表于 2013-4-1 21:59:35 | 查看: 5959| 回复: 6

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

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

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

主库日志.zip

26.72 KB, 下载次数: 921

备库日志.zip

19.17 KB, 下载次数: 921

分享0

收藏0 回复只看该作者道具举报

Teddy.huang

2^#

发表于 2013-4-1 22:11:54

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

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-4-1 22:28:46

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]

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2013-4-1 22:31:01

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

我要说的是：

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

回复只看该作者道具举报