Re: Dataguard in data warehousing

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_at_gmail.com> 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_at_gmail.com> 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.
>> --
>>
>>
>> --

*Kellyn Pot'Vin-Gorman*
DBAKevlar Blog <http://dbakevlar.com>
President Denver SQL Server User Group <http://denversql.org/> about.me/dbakevlar

--
http://www.freelists.org/webpage/oracle-l