Configure RMAN to automatically purge archive logs after applying on the standby database


RMAN can automatically purge archivelogs from the FRA after archivelogs are applied to the standby database.

rman target /
RMAN > configure archivelog deletion poliyc to applied on all standby;

select a.thread#, a.sequence#, a.applied
from v$archived_log a, v$database d
where a.activation# = d.activation#
and a.applied='YES'
order by a.thread#

RMAN > show retention policy

RMAN > report obsolete;

When there is a space pressure in FRA, the archivelogs will be deleted and you can see it from alert_INSTANCE.log

No comments:

Post a Comment