This discussion is archived
1 Reply Latest reply: Nov 22, 2012 9:48 AM by mseberg RSS

Late Replication

bijunator Newbie
Currently Being Moderated
Is it possible to have a late replication of primary database to secondary database using data gaurd?
Say for example, my primary database get refreshed every 3 days i.e drops all the tables and recreates them and repopulates them.
This takes roughly another 2 days.
During this time I need the secondary stand by database to be up and running so that reports can be generated from the previous data.
Its ok to have a 2-3 days lag.
As soon as the refresh process in primary database is complete, we can start the data gaurd and the secondary database also gets refreshed with the primary database i.e. the all tables get dropped and recreated and re-populated.

Is this feasible/possible?
  • 1. Re: Late Replication
    mseberg Guru
    Currently Being Moderated
    Hello;

    feasible = Might consider something else. You don't need a standby, you need a point in time copy.

    I might just clone the Primary every so often using RMAN instead.

    Example

    http://www.visi.com/~mseberg/rman/restore_database_without_catalog.html

    With this method all you have to do is shutdown the remote database and have an INIT for its RMAN clone. RMAN will replace everything for you.

    possible = Yes as long as you can keep all that archive around. DEFER would work.

    Best Regards

    mseberg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points