This content has been marked as final. Show 1 reply
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.
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.