RE: DG for nologging
Date: Thu, 08 Mar 2018 06:26:58 +0100
Message-ID: <1620413a0d0.278e.f39e3e69b57dc29d82f1c76ed37cd589_at_gmail.com>
Important point.😋
Le 8 mars 2018 12:54:59 AM Noveljic Nenad <nenad.noveljic_at_vontobel.com> a écrit :
> Obviously, there are many pros and cons to both of the solutions.
>
> I’d just like to add a point that I think hasn’t been mentioned so far.
>
> As we all know, Data Guard (DG) is underpinned by database recovery. This
> means that it is rather redo blocks instead of data blocks that are shipped
> across. Consequently, unlike in SAN-based replication, corrupted data
> blocks won’t be propagated to the standby site when using DG.
>
> Nenad
>
> http://nenadnoveljic.com/blog/
>
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Mladen Gogala
> Sent: Mittwoch, 7. März 2018 22:58
> To: Sheehan, Jeremy; arjen.visser_at_gmail.com; Andrew Kerber
> Cc: nupendra_at_hotmail.com; oracle-l_at_freelists.org
> Subject: Re: DG for nologging
>
>
> On 03/07/2018 04:10 PM, Sheehan, Jeremy wrote:
> Despite the downsides, I personally think it is better than Data Guard.
>
> There is no such thing as "better" or "worse". There is only "it is a
> better fit to my situation and budget". There are several solutions:
>
> * Data Guard
> * DbVisit
> * SAN replication
> * Snapshot based discrete backups, like SnapVault by NetApp.
> * Database replication, like GG or SharePlex.
>
> Corporate giants like Citigroup, Exxon Mobile or Walmart will probably
> chose different solution than some smaller companies. Fortunately, I am not
> a DBA any more, so I don't have to chose the solution any more. That is
> also the reason why this debate will never reach any meaningful end.
>
>
>
> --
>
> Mladen Gogala
>
> Database Consultant
>
> Tel: (347) 321-1217
> ____________________________________________________
> Please consider the environment before printing this e-mail.
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
> <html xmlns="http://www.w3.org/1999/xhtml">
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <style type="text/css">p { font-family: Arial;font-size:9pt }</style>
> </head>
> <body>
> <p>
> <br>Important Notice</br>
> <br>This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.</br>
> <br>E-mail transmission may not be secure or error-free as information
> could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete. Also processing of incoming e-mails cannot be guaranteed. All
> liability of the Vontobel Group and its affiliates for any damages
> resulting from e-mail use is excluded. You are advised that urgent and time
> sensitive messages should not be sent by e-mail and if verification is
> required please request a printed version.<br/>
> </p>
> </body>
> </html>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 08 2018 - 06:26:58 CET