9i dataguard delay使用要小心

本文探讨了Oracle数据库中归档日志的延迟应用问题,特别是在Red Hat Enterprise Linux AS release 4环境下,观察到的归档日志应用时间与设定的延迟时间不一致的现象,并分析了可能的原因。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Red Hat Enterprise Linux AS release 4 (Nahant Update 6)

9.2.0.4.0

 

Media Recovery Delayed for thread 1 seq# 156317 until 05/11/2012 06:30:26

Media Recovery Log /data/oracle9/arch/1_156317.dbf

Fri May 11 06:32:37 2012

Media Recovery Delayed for thread 1 seq# 156318 until 05/11/2012 07:17:37

Media Recovery Log /data/oracle9/arch/1_156318.dbf

Fri May 11 07:19:59 2012

Media Recovery Delayed for thread 1 seq# 156319 until 05/11/2012 08:04:59

Media Recovery Log /data/oracle9/arch/1_156319.dbf

Fri May 11 08:07:14 2012

Media Recovery Delayed for thread 1 seq# 156320 until 05/11/2012 08:52:14

Media Recovery Log /data/oracle9/arch/1_156320.dbf

Fri May 11 08:54:34 2012

Media Recovery Delayed for thread 1 seq# 156321 until 05/11/2012 09:39:34

Media Recovery Log /data/oracle9/arch/1_156321.dbf

Fri May 11 09:42:06 2012

Media Recovery Delayed for thread 1 seq# 156322 until 05/11/2012 10:27:06

Media Recovery Log /data/oracle9/arch/1_156322.dbf

Fri May 11 10:29:19 2012

 

到主库上去核实发现,备库上刚被应用的归档日志与主库的时间查远不是设置的45分钟,而且越往后时间越长,从上述的应用情况看,倒是前后两个日志应用的时间差刚好是45分钟,这与官方的说法不符!

The DELAY attribute indicates that the archived redo logs at the standby site are not available for recovery until the specified time interval has expired. The time interval is expressed in minutes, and it starts when the redo log is successfully transmitted and archived at the standby site.

 

When the standby database is in managed recovery mode, redo logs are automatically applied when they arrive from the primary database. However, to protect against the transfer of corrupted or erroneous data from the primary site to the standby site, you might want to create a time lag between archiving a redo log at the primary site and applying that archived redo log at the standby site.

 

同样的设置在11G是正常的,备库日志应用与主库的时间差等于指定的时间(delay),当然如果在这种情况下9i环境中仍然适用,就是当日志切换的时间间隔总体上大于归档日志延时应用的时间,备库的应用能跟上主库切换的脚步!

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

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值