Originally posted on “Databases at CERN” blog
What is the best way to handle archived logs deletion in environments with standby and downstream capture databases? One could use own scripts, to delete for example all backed up archived logs, older than n days. But better way, will be to set RMAN archived log deletion policy, because then, additional options could be specified, to delete archived logs which are not only
BACKED UP N TIMES, but also
SHIPPED to other databases in the environment. Then, with proper settings, we should not end up with standby database which needs already deleted archived log… Of course unless there are some bugs causing problems with correct handling of archived logs deletion, so it’s good idea to double-check your configuration, before real deletion occurs, which usually happens when there is space pressure in FRA.