Why in dataguard standby side RFS, LNS, LGWR or ARCn generate large trace file without any errors or issues?
My standby database side i observed trace files for rfs process are growing in GBs always.
its due to parameter log_archive_trace value set in instance level in standby side.
if log_archive_trace value set for non zero, the trace files size will grow. resolution is to set it to zero value.
In my case, i can see the value is 255.
SQL> show parameter log_archive_trace
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_trace integer 255
My standby database side i observed trace files for rfs process are growing in GBs always.
its due to parameter log_archive_trace value set in instance level in standby side.
if log_archive_trace value set for non zero, the trace files size will grow. resolution is to set it to zero value.
In my case, i can see the value is 255.
SQL> show parameter log_archive_trace
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_trace integer 255
i set it to 0, its fixed the proble,.
SQL> alter system set log_archive_trace=0 scope=both;
System altered.
if you are using DB brocker. set this value also to consistent in instance level and DG brocker level.
DGMGRL> show instance 'ORCL' 'LogArchiveTrace';
LogArchiveTrace = '255'
DGMGRL> edit instance 'ORCL' SET PROPERTY 'LogArchiveTrace'=0;
Property "LogArchiveTrace" updated
DGMGRL> show instance 'ORCL' 'LogArchiveTrace';
LogArchiveTrace = '0'
No comments:
Post a Comment