High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center