advertisements
_____________________________________________________________________________________________________________________
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_TARGETPress 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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment