Total Pageviews

Thursday 23 July 2015

How to configure Auto delete of logs in Logical standby database

This one enables automatic deletion of applied arclogs.
    Exec DBMS_LOGSTDBY.APPLY_SET ( 'LOG_AUTO_DELETE' , TRUE ) ;

This one sets the length of time, in minutes, that an applied arclog will be retained until deletion. The default is 1440 or 24 hours. We set in lower so as not to use so much space for the arclogs.
    Exec DBMS_LOGSTDBY.APPLY_SET ( 'LOG_AUTO_DEL_RETENTION_TARGET' , 120 ) ;

No comments:

Post a Comment