While I was running ADG happily for some time, I started to notice the archivelogs transferred to the standby database where starting to fill up the FRA area of the ADG..Why would I keep those old logs around (going back for a few months!) while they where already applied? No reason for me to do this, so I decided to clean them up.
First: remove the completed archivelogs to clear the space:
Log into RMAN on the standby and enter this command:
RMAN> delete archivelog all completed before 'sysdate';
or if you still wanted to keep some, play around with ‘sysdate-7’ if you wanted to keep a weeks worth of completed archivelogs.
Since I don’t want to schedule a job for this, or worse: get surprised when I don’t remember to do this on time, I applied this policy:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
Please read up on this setting, and the consequences it may have to your backup strategy!
Have a good day!