Archive log deletion with physical standby in place - 11.2.0.2
Hi,
We have a stand alone physical standby (11.2.0.2) with a 2 node 11.2.0.2 PRIMARY RAC database in place
On the PRIMARY database, we are making RMAN backups. Our question is that how do we ensure that RMAN never delete any archive log that has not been yet shipped / applied on the standby?
currently we have the following settings in place for RMAN on primary RAC database
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;