RE: Replication vs Data Guard

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 11 Jan 2012 16:34:38 +0000
Message-ID: <A250F0C68C23514CA9F3DF63D60EE10E0A493B_at_onews31>

I'm getting about 4 seconds latency on my standby using Data Guard with Real-Time Apply, but this standby can't be used for anything unless I stop the redo apply and open it read-only (or do a switchover or failover). So, if you need to use your secondary/standby/destination database for something other than DR or intermittent read-only access then you need to consider other replication options, or Active Data Guard.

SYS_at_prddb>select * from v$dataguard_stats;

NAME                             VALUE                UNIT                           TIME_COMPUTED


-------------------------------- -------------------- ------------------------------ ------------------------------

apply finish time                +00 00:00:00.0       day(2) to second(1) interval   11-JAN-2012 08:20:16
apply lag                        +00 00:00:04         day(2) to second(0) interval   11-JAN-2012 08:20:16
estimated startup time           8                    second                         11-JAN-2012 08:20:16
standby has been open            Y                                                   11-JAN-2012 08:20:16
transport lag                    +00 00:00:00         day(2) to second(0) interval   11-JAN-2012 08:20:16

For more info on real-time apply:
http://docs.oracle.com/cd/E11882_01/server.112/e25608/log_apply.htm#i1022881

More info on real-time query (Active Data Guard): http://docs.oracle.com/cd/E11882_01/server.112/e25608/manage_ps.htm#i1017111

Regards,
Brandon

---

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 11 2012 - 10:34:38 CST