This content has been marked as final. Show 7 replies
with 11gR1 Oracle introduced Active DataGuard. Allowing you to open the database read only, while the apply is running.
So this is exactly what you need:
BTW: I would personally upgrade to 220.127.116.11 with the latest PSU.
Thanks. Does that require a separate license?
(Unfortunately) Yes: Active Data Guard license.
But on the other side, you don't have to change a thing.... so it is worth the money instead of building up another standby (e.g. logical), which consumes the double disk space/double machine power, special setup and administration etc.etc.....
Sounds like Active Data Guard may be just what I need. Thanks.
Will it affect the performance of the standby or primary? Can it be configured so that applying logs gets top priority and everything else takes a back seat?
Hi,1 person found this helpful
there is no difference on the primary site between ADG and normal DG. And there is also no difference in shipment of the redo logs.
The apply performance on the standby is minimally slower (< 2%) and only recognizable if you already have problems that the standby keeps up to date. But then again this does not effect your DR.
It only means that a switchover/failover will take minimally longer....
On the other side, there is always headroom to optimize apply performance. See here:
Thanks. You've been very helpful.
Another option to consider is usage of Oracle Golden Gate. But again its a licensed product.
Replication is done with near-zero lag.