Re: Dataguard in data warehousing

From: Vishnu Potukanuma <vishnupotukanuma_at_gmail.com>
Date: Sun, 24 Nov 2019 04:34:11 +0530
Message-ID: <CAP-RywzJe+Q=LJzxjZN9CN0HLigxj-+N3JD+A6rRFggc3itBAg_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 24 2019 - 00:04:11 CET

Original text of this message