Re: Standby redo logs
Date: Thu, 31 Jul 2014 08:27:07 +0530
Message-ID: <CAABGLuKWX0h4DRRP1OAFKpGr6cxVDwrNAbX=AVeDi0v1i0JaoQ_at_mail.gmail.com>
Hi Michael,
There are no danger at all if you don't have standby redo logs either in 11g or 12c if DataGuard functioning in maximum performance. Oracle recommends to have real time apply so that even in maximum performance in case of disaster you may have very minimal data loss, To use of real time apply then you must create standby redo logs then the remote file server process writes the redo data to standby redo log files on the standby database. In case you haven't configured SRL then in case of disaster you may have data loss same data as one online redo log transactions/size if you want to overcome this situation then ALWAYS avail real time apply.
When we say maximum protection or availability mode then standby redo logs
is MUST.
So basically its all depends on what protection mode the database is in.
I hope this clear...Thank you.
On Thu, Jul 31, 2014 at 8:05 AM, Michael Cunningham < napacunningham_at_gmail.com> 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> -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 31 2014 - 04:57:07 CEST