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