Database Backup and Recovery (MOSC)

MOSC Banner

Data Guard vs FlashBack for Logical Data corruption

edited Mar 20, 2013 10:27AM in Database Backup and Recovery (MOSC) 7 commentsAnswered
I am looking for a couple of opinions from members of this community who have been doing this kind of stuff probably a lot longer than I have.

Scenario

We have an approximately 1.5 terabyte database (10.2.0.5) with about 1.2 terabytes in readonly tablespaces that we archive off the files once they become readonly then skip on rman backups.  We have a manual data guard setup that we have kept around since 9i setup on the same node effectively being used only for logical corruption protection.. as we don't use it for read only querying and everything is on the same box as we don't have resources for another offsite machine for effective dr. We do use rman to take nightly backups (skipping readonly)

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