ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dataguard 遭遇ORA-00334

dataguard 遭遇ORA-00334

原创 Linux操作系统 作者:microsoft_fly 时间:2009-04-22 16:36:22 0 删除 编辑
有多台服务器,环境一致,数据库版本一致,其他机器间配置均没问题,但有两台服务器多次配置DG后出现同样问题:
QMN0 started with pid=16
Thu Apr  2 08:55:45 2009
Fetching gap sequence for thread 1, gap sequence 4927-5020
Trying FAL server: 216
Media Recovery Log /data/oracle9/product/9.2.0/dbs/1_4927.dbf
Thu Apr  2 08:59:23 2009
Restarting dead background process QMN0
QMN0 started with pid=18
Thu Apr  2 09:00:07 2009
Errors in file /data/oracle9/admin/GISDB/bdump/orcljl_mrp0_31067.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 27986 change 121657645675 time 03/31/2009 19:22:03
ORA-00334: archived log: '/data/oracle9/product/9.2.0/dbs/1_4927.dbf'
Thu Apr  2 09:00:07 2009
MRP0: Background Media Recovery terminated with error 354
Thu Apr  2 09:00:07 2009
Errors in file /data/oracle9/admin/GISDB/bdump/orcljl_mrp0_31067.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1633366 change 121659056582 time 03/31/2009 19:40:18
ORA-00334: archived log: '/data/oracle9/product/9.2.0/dbs/1_4927.dbf'
Recovery interrupted.
Recovered data files restored to a consistent state at change 121659051570.
MRP0: Background Media Recovery process shutdown
我做了很多次了,大部分应用第一个日志有问题,有一次是第2个有问题,但我在主库上对该日志做LOGMNR并没有发现问题!
还有归档日志我都换了块硬盘,还是出现同样的问题!奇怪
oracle 9i 64位

[ 本帖最后由 microsoft_fly 于 2009-4-22 16:58 编辑 ]

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

请登录后发表评论 登录
全部评论

注册时间:2008-11-06

  • 博文量
    41
  • 访问量
    99323