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