Dataguard in data warehousing
Date: Sat, 23 Nov 2019 15:59:29 -0600
Message-ID: <CAHSa0M2vuTQPtKB-S_P0Z4iX8WsTCYft63ZFt_a8FP9yG=S2Aw_at_mail.gmail.com>
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 Sat Nov 23 2019 - 22:59:29 CET