Re: Standby redo logs

  • From: Nassyam Basha <nassyambasha@xxxxxxxxx>
  • To: justin@xxxxxxx
  • Date: Thu, 31 Jul 2014 11:53:11 +0530

Yes, I forgot to add that point regarding data loss. There is no such zero
data loss with maximum performance. But if you configure FAST SYNC then you
can get almost and maximum zero data loss with maximim performance until
unless rare situations.. its called catastrophic failure.


On Thu, Jul 31, 2014 at 8:53 AM, Justin Mungal <justin@xxxxxxx> wrote:

> Be careful with your wording, because even with standby redo logs you
> can't ensure zero data loss unless you're running in maximum protection
> mode.
>
> I would recommend configuring standby redo logs because instead of
> applying redo in batches as archive logs arrive at the standby, you can use
> real-time apply (requires standby redo logs) to stream redo continuously to
> the standby. This generally lowers potential data loss and can also improve
> fail over times.
>
> Oh, and while you're busy reading the docs... check out the Data Guard
> Broker if you haven't already...
>
>
> On Wed, Jul 30, 2014 at 9:35 PM, Michael Cunningham <
> napacunningham@xxxxxxxxx> wrote:
>
>> Are there dangers with not having standby redo logs in a 12c physical
>> standby db? The docs do indicate they are necessary to insure zero data
>> loss. Any other experience out there?
>>
>> Thanks,
>> Michael Cunningham
>>
>
>


-- 
Nassyam Basha.
Oracle DBA
*The Pythian Group * <http://www.pythian.com/>
11g OCP Certified, Blogger
Co-Author: Oracle Data Guard 11gR2
<http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900>
Member of Oraworld-team <http://www.oraworld-team.com>

Visit My Blog <http://www.oracle-ckpt.com>
Let's Connect - Linkedin Profile <http://in.linkedin.com/in/nassyambasha/>
My Twitter <https://twitter.com/nassyambasha>
My Facebook <https://www.facebook.com/nassyambasha>

Other related posts: