RE: Real time apply feature in 10.2
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Thu, 25 Oct 2012 12:52:56 -0700 (PDT)
Message-ID: <1351194776.29756.YahooMailNeo_at_web161302.mail.bf1.yahoo.com>
Satvik,
Take a look at MOS bug 5956646: REAL TIME APPLY CAN LEAVE STANDBY IN UNRECOVERABLE STATE IF STANDBY NODE CRASHES Even though it is unlikely you run into that bug, it is important to understand the architectural limitation. Enabling flashback on the standby should resolve bug 5956646. Real time apply is recommended in general, but it is optional if you are okay with longer unplanned dataguard failover time.
Date: Thu, 25 Oct 2012 12:52:56 -0700 (PDT)
Message-ID: <1351194776.29756.YahooMailNeo_at_web161302.mail.bf1.yahoo.com>
Satvik,
Take a look at MOS bug 5956646: REAL TIME APPLY CAN LEAVE STANDBY IN UNRECOVERABLE STATE IF STANDBY NODE CRASHES Even though it is unlikely you run into that bug, it is important to understand the architectural limitation. Enabling flashback on the standby should resolve bug 5956646. Real time apply is recommended in general, but it is optional if you are okay with longer unplanned dataguard failover time.
Thanks,
Sai
http://sai-oracle.blogspot.com
*
*
*
- From: "Sweetser, Joe" <JSweetser_at_xxxxxxxx>
- To: "satvik099_at_xxxxxxxxx" <satvik099_at_xxxxxxxxx>, "oracle-l_at_xxxxxxxxxxxxx" <oracle-l_at_xxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2012 17:16:17 +0000 Metalink doc ID 828274.1 might be worth looking at for you but the standard answer of "it depends" seems relevant here. What is your standby DB going to be used for...Reporting? Failover? It is important to you that transactions are applied as quickly as possible to the standby? Hth, -joe -----Original Message----- From: oracle-l-bounce_at_xxxxxxxxxxxxx [mailto:oracle-l-bounce_at_xxxxxxxxxxxxx] On Behalf Of satvik Sent: Thursday, October 25, 2012 11:05 AM To: oracle-l_at_xxxxxxxxxxxxx Subject: Real time apply feature in 10.2 Hi All, I am a newbie to oracle dataguard. I had one doubt regarding real time apply feature in 10.2 Using Real-Time Apply to Apply Redo Data in a physical standby in 10.2 has the following benefits according to the oracle 10.2 dataguard documentation. "If the real-time apply feature is enabled, log apply services can apply redo data as it is received, without waiting for the current standby redo log file to be archived. This results in faster switchover and failover times because the standby redo log files have been applied already to the standby database by the time the failover or switchover begins." are there any advantages other than the above to enable the real time apply feature in 10.2 for a physical standby. what is the recommended way (enable or disable real time apply) and why is that so? Please advise. Regards, Satvik
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 25 2012 - 21:52:56 CEST