初始化参数archive_lag_targe

archive_lag_target
控制日志切换/归档最长时间间隔/频率的参数。
* 该参数通过指定最长日志切换时间间隔,限制最大可丢失日志数据,达到增加备库(standby database)的可用性的目的.
* 设置为0关闭了该特性.
* 该参数单位为秒.超过7200秒的设置对于维护一个合理的备库延迟没有太大用处.
* 推荐设置为1800秒(30分钟).设置太小会导致频繁日志切换,会影响性能.

1，测试：
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/archive/orcl/
Oldest online log sequence     39
Next log sequence to archive   41
Current log sequence           41
SQL> show parameter archive_lat
SQL> show parameter archive_lag

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
archive_lag_target                   integer                          0
SQL> alter system set archive_lag_target=300;

System altered.

SQL> show parameter archive_lag;

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
archive_lag_target                   integer                          300

SQL> select sequence#, to_char(first_time, 'YYYYMMDD HH24MISS')
  from v$archived_log
 where first_time>sysdate-1/24
 order by 1;  2    3    4 

 SEQUENCE# TO_CHAR(FIRST_TIME,'YYYYMMDDH
---------- ---------------------------------------------------------------------------
        62 20130123 131414
        63 20130123 132021
        64 20130123 132625
        65 20130123 133235
        66 20130123 133855
        67 20130123 134508
        68 20130123 135110
        69 20130123 135716
        70 20130123 140322

9 rows selected.
==〉日志切换间隔约300秒。

2，在非归档模式下该参数有效吗？

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     8156
Current log sequence           8158
SQL> show parameter archive_lag_target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
SQL> select to_char(sysdate,'YYYYMMDD HH24MISS') from dual;

TO_CHAR(SYSDATE
---------------
20130110 104609

SQL> select sequence#, to_char(first_time, 'YYYYMMDD HH24MISS')
  2    from v$log_history
  3   where sequence#>=8157;

 SEQUENCE# TO_CHAR(FIRST_T
---------- ---------------
      8157 20130109 005637

SQL> alter system set archive_lag_target=300;

System altered.

SQL> select to_char(sysdate,'YYYYMMDD HH24MISS') from dual;

TO_CHAR(SYSDATE
---------------
20130110 123303

SQL> select sequence#, to_char(first_time, 'YYYYMMDD HH24MISS')
  2    from v$log_history
  3   where sequence#>=8157;

 SEQUENCE# TO_CHAR(FIRST_T
---------- ---------------
      8157 20130109 005637
      8158 20130109 205201
      8159 20130110 104657
      8160 20130110 105157
      8161 20130110 105656
      8162 20130110 110155
      8163 20130110 110655
      8164 20130110 111157
      8165 20130110 111657
      8166 20130110 112156
      8167 20130110 112655
      8168 20130110 113155
      8169 20130110 113657
      8170 20130110 114157
      8171 20130110 114656
      8172 20130110 115156
      8173 20130110 115655
      8174 20130110 120157
      8175 20130110 120657
      8176 20130110 121156
      8177 20130110 121655
      8178 20130110 122158
      8179 20130110 122703

23 rows selected.

SQL> alter system set archive_lag_target=0;

System altered.

SQL> select to_char(sysdate,'YYYYMMDD HH24MISS') from dual;

TO_CHAR(SYSDATE
---------------
20130110 132437

SQL> select sequence#, to_char(first_time, 'YYYYMMDD HH24MISS')
  2    from v$log_history
  3   where sequence#>=8178;

 SEQUENCE# TO_CHAR(FIRST_T
---------- ---------------
      8178 20130110 122158
      8179 20130110 122703

==〉
对于非归档数据库，参数archive_lag_target也会影响日志切换频率。

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

转载于:http://blog.itpub.net/18922393/viewspace-753121/