RE: Real time apply feature in 10.2

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Thu, 25 Oct 2012 17:16:17 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C9CD65F88_at_ICATMAIL1.ICAT.com>



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_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of satvik Sent: Thursday, October 25, 2012 11:05 AM To: oracle-l_at_freelists.org
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-l

Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 25 2012 - 19:16:17 CEST

Original text of this message