I have a 11.2 primary and standby configuration ( MaxPerformance ).
I want to off load my full backups and archive log backups to the standby.
I need to make absolutely sure that the archive logs are not deleted from the primary site until they are backed up* to tape on the standby site.
configure deletion policy "to applied to all standby" is not good enough, because something can happen to the archive logs after they are applied but before they are backed up to tape n the standby.
My problem is that I do not want to backup the primary at all.
two reasons :
1. my backups generate a strain on the primary database
2. we backup directly to tape and we are paying license fee for the Networker module.
We do not want to spend 2 licenses - one for the primary and one for the standby.
So the plan was to offload the backups to the standby and stop the backups on the primary altogather, thus releasing one license.
But this makes me very nervous as I am never sure , when I am purging the archive logs on the primary , that they are already backed up by the standby...
I guess I can go to the RMAN , query it for the maximum number of archive log that was backed up and purge everything before it.
its not too complicated, but I wish Oracle can add a 'deletion policy' that will account for that ( i.e - delete only what was backed up by ANY of the members of the configuration, be it primary or standby :- ) )
If I understand correctly , the deletion policy on the standby site where the backups are taken needs to be set to NONE ( it should be applied to all standby on the primary which is OK ).
However , let's say I have a couple hours delay, archive logs are accomulating on the standby but are not applied.
I am running a backup and then deleting the backed up archive logs.
whats to prevent RMAN to backup and delete those archive logs that are not yet applied ??
I am asking because I am no busy resolving an archive gap on standby that I believe was a result of exactly that scenario..
archive logs were transfered and waiting to apply , backup was running on the standby and deleting them and they were missing when it was their turn to be applied.
Oh, I resolved the gap, that was not a problem
the archive logs where backed up before they were deleted.
The problem was that they were deleted in the first place , before they were applied
I would think that RMAN will provide a deletion policy for standby so that it will not delete archive logs on a standby node that were not yet applied.
As it is , the deletion policy on the standby is NONE ( as recommended ) and the archive logs will be deleted.
Unless I will develop a script that will figure out the last applied log and only delete those archive logs that were already applied.
I was just thinking it would be nice to instruct RMAN to do it for me via a deletion policy of some sort :-)
I have a question about handling the archivelog in primary. Sorry for bring up this old post.
My question is "Do I need to periodically run RMAN on primary to backup and delete those archivelog in primary?" If yes, those archivelogs will be shown twice in the recovery catalog. And, I still need to run rman backup job in the primary. I am a bit puzzled.
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;