ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 强制归档参数ARCHIVE_LAG_TARGET

强制归档参数ARCHIVE_LAG_TARGET

原创 Linux操作系统 作者:tolywang 时间:2009-08-02 09:32:40 0 删除 编辑

          在Standby 环境中,为了减少出现故障时数据损失,我们可以设置ARCHIVE_LAG_TARGET参数,强制进行日志切换。ARCHIVE_LAG_TARGET参数可以设置一个时间,通过时间限制,指定数据库强制进行Log Switch,进行归档。 这个参数的缺省值是0,即为不启用该参数。该参数合理的取值范围在60 ~ 7200之间。 通常大于7200和小于1800不被推荐,低于30分钟的切换时间可能导致性能问题。 

 

ARCHIVE_LAG_TARGET

Property Description
Parameter type Integer
Default value 0 (disabled)
Modifiable ALTER SYSTEM
Range of values 0 or any integer in [60, 7200]
Basic No
Real Application Clusters Multiple instances should use the same value.

ARCHIVE_LAG_TARGET limits the amount of data that can be lost and effectively increases the availability of the standby database by forcing a log switch after the specified amount of time elapses.

A 0 value disables the time-based thread advance feature; otherwise, the value represents the number of seconds. Values larger than 7200 seconds are not of much use in maintaining a reasonable lag in the standby database. The typical, or recommended value is 1800 (30 minutes).    Extremely low values can result in frequent log switches, which could degrade performance;    such values can also make the archiver process too busy to archive the continuously generated logs.  

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

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13202960