Re: DG for nologging

From: Arjen Visser <>
Date: Thu, 8 Mar 2018 07:32:36 +1300
Message-Id: <>

Some disadvantages of SAN:

1)With database SAN replication you are replicating database data 3 times so quite inefficient and requiring more bandwidth. Once for all the changes in the data files, once for replicating redo, and once for replicating archive logs. With a standby database you are only replicating the changes once.
2)You do not know if your SAN replicated database will start if you really need it. With a standby database it is always running and ready to take over.
3) The replicated SAN database cannot be used for anything. The standby database can be used for offload reporting, offloading backups, feeding ETL etc.

Regards, Arjen

> On 7/03/2018, at 11:10 PM, Upendra nerilla <> wrote:
> A small detour on the SAN replication..
> I'm trying to understand the advantages and disadvantages of SAN replication over Data guard..
> I felt Data guard is very specific (to the DB replication task), it can validate the recoverability of the database continuously. SAN replication on the other hand, is useful in replicating complex application configuration to the DR site.. Also with SAN replication, we loose the ability to go point-in-time in the DR site (if the need arises?).
> Also if multiple databases are being replicated with the same SAN replication group, we are unable to recover each of the database to its own point-in-time..
> Please share any feedback or thoughts
> Thanks
> From: <> on behalf of Mladen Gogala <>
> Sent: Tuesday, March 6, 2018 7:36 PM
> To:
> Subject: Re: DG for nologging
> +2

>> On 03/06/2018 09:15 AM, Sheehan, Jeremy wrote:
>> +1 for SAN replication.

> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
Received on Wed Mar 07 2018 - 19:32:36 CET

Original text of this message