dataguard 遭遇ORA-00334

最新推荐文章于 2025-01-03 09:12:58 发布

转载最新推荐文章于 2025-01-03 09:12:58 发布 · 257 阅读

文章标签：

在多台配置一致的服务器中尝试配置Oracle9i的数据保护(Data Guard)时遇到重复的日志文件损坏问题，表现为背景进程异常重启及日志块头损坏等错误。

有多台服务器,环境一致,数据库版本一致,其他机器间配置均没问题,但有两台服务器多次配置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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/751051/viewspace-731740/