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

MOSC Banner

Removing archivelogs that have allready been shipped to standby before role transition

Here is my scenario. I have a physical standby database and my RMAN backups are performed from that side. On the primary side I have enough space for around 8 days worth of archivelogs so it has quite a few logs before the policy deletes the ones that are reclaimable. During role transition my first backup of the new standby always takes a very long time because the number of these archivelogs that are on disk. Since these archivelogs had been shipped to the standby already they technically have been already backed up as well.

I am just wondering how someone else has handled this situation? Should I do an archivelog backup and delete input before role transition? Or simply run a delete archivelog all completed before sysdate -1 for example? Backing up these archivelogs that had already been shipped seems a bit redundant.

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