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 <nupendra@xxxxxxxxxxx> 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: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Mladen Gogala <gogala.mladen@xxxxxxxxx>
Sent: Tuesday, March 6, 2018 7:36 PM
To: oracle-l@xxxxxxxxxxxxx
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
