You may also want to look into Far Sync for Data Guard:
https://docs.oracle.com/database/121/SBYDB/create_fs.htm
This is my go-to for with large data syncs and those that have network
latency/hybrid cloud solutions.
Kellyn
On Sat, Nov 23, 2019 at 3:05 PM Vishnu Potukanuma <
vishnupotukanuma@xxxxxxxxx> wrote:
I believe Data Guard can handle the load, I have worked on a database
recently where the archive generation rate is about 4-6TB a day, the
maximum gap was only about 10-15 minutes and most of the time about a
minute. so on an average 170 - 256 GB a hour, provided you have necessary
bandwidth at the IO/network layer i dont think you will have any issues.
Thanks,
Vishnu
On Sun, Nov 24, 2019 at 3:30 AM Ram Raman <veeeraman@xxxxxxxxx> wrote:
All,
We are looking into data guard as one of the HA/DR solutions for a big
data warehouse of several TBs in size. (will have more information about
the DW once I gain access to it). 98% or more of the data is fed into the
DW DB using nightly feeds. Given that, if we use data guard solution I am
wondering how the syncing between the primary and standy will happen. I am
also thinking that during the load process, the data will be loaded using
direct load option; this looks like the logs shipped from primary wont be
of much use at the standby.
Do the listers use data guard with a data warehouse env? Can they share
their experiences? Any good paper on that. Thanks.
Ram.
--
--