Database Backup and Recovery (MOSC)

MOSC Banner

Once Again...Backing up Data Guard Databases

I didn't see any recent discussions on this when I searched so I'm asking again, relative to our configuration.

We're running Oracle 19.8, single instance primary, single instance physical standby data guard setup. As usual, we don't anticipate a primary to standby switchover unless there is a PSU or other maintenance to be applied. In order to insure we have everything we need to fully recover all data at any given point in time, which database do we backup on a regular basis: primary, standby or both?

From a top level view, I would say backup the primary only. This means if a switchover is made, backups on the standby (the old primary) are ceased and backups on the primary (old standby) are started. The process is then reversed after switching back. This would only be done if an extended switchover period were in place, not for patch application or other short maintenance periods. How does this strategy sound?

Tagged:

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