ARCHIVE_LAG_TARGET: Why So Many Archive Log Getting Generated Even Without Any Transaction in Oracle Database

One day I noticed one of my databases is generating lot of archive logs though it is an idle database. There is no transaction happening in this database for a long time. I came to know when I tried to clone the database to a different server. The recovery is taking so much of time with these archive logs. One thing I noticed is this archive logs are small in size. 

After a research I found about the oracle parameter ARCHIVE_LAG_TARGET. What this parameter does is it will switch the files according to the value specified for this parameter. By default the value for this parameter is 0 and which will not generate any archive logs by its own. The value of this parameter considered in seconds. 
In my database it was set it as 900 seconds which will generate one archive log every 15 mins. I reset the parameter value to 0 to avoid the unwanted archive generation.

See example.  
By Default the value is 0.
SQL> show parameter ARCHIVE_LAG_TARGET
Press Return to Continue

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
archive_lag_target                   integer     0

To generate archive logs every 15 mins
SQL> alter system set archive_lag_target=900;

System altered.

SQL> show parameter ARCHIVE_LAG_TARGET
Press Return to Continue

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

System altered.

DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google