设置数据库归档时间间隔

设置数据库归档时间间隔,比如30分钟归档一次。

参考文档 https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams009.htm#REFRN10003https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams009.htm#REFRN10003

ARCHIVE_LAG_TARGET

PropertyDescription
Parameter typeInteger
Default value0 (disabled)
ModifiableALTER SYSTEM
Range of values0 or any integer in [60, 7200]
BasicNo
Oracle RACMultiple instances should use the same value.

ARCHIVE_LAG_TARGET forces 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.

See Also:

Oracle Data Guard Concepts and Administration for more information about criteria for setting this parameter

设置归档时间间隔为30分钟,并查看效果

SYS@test>alter system set archive_lag_target=1800;

System altered.


-rw-r-----. 1 oracle oinstall     2560 May 15 13:34 1_196_963738576.arc
-rw-r-----. 1 oracle oinstall 38250496 May 17 09:00 1_197_963738576.arc
-rw-r-----. 1 oracle oinstall    15360 May 17 09:00 1_198_963738576.arc
-rw-r-----. 1 oracle oinstall 42948096 May 17 10:03 1_199_963738576.arc
-rw-r-----. 1 oracle oinstall 43029504 May 17 19:00 1_200_963738576.arc
-rw-r-----. 1 oracle oinstall  4195840 May 17 19:43 1_201_963738576.arc
-rw-r-----. 1 oracle oinstall  3424256 May 17 20:13 1_202_963738576.arc
-rw-r-----. 1 oracle oinstall  1565184 May 17 20:43 1_203_963738576.arc
-rw-r-----. 1 oracle oinstall  3587072 May 17 21:13 1_204_963738576.arc
-rw-r-----. 1 oracle oinstall  1616384 May 17 21:43 1_205_963738576.arc
[oracle@test archive_log]$
end
阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/xxzhaobb/article/details/80357426
个人分类: 11gR2
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

设置数据库归档时间间隔

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭