Hi all,
We have been requested to come up with a solution for the
following problem: We have a production system that is about 200Gb. We
want to be able to build a parallel database that will resemble the
production and cannot be out of sync with the production by more than
24 hrs. Dataguard was suggested as an option.
With dataguard, my understanding is that the standby will
have to be on a server of the same OS level, patch level, disk layout,
etc. We do not have such a scenario here. Also they want to be able to
work from the parallel environment (they may be making changes on their
own). This means dataguard will not work as the standby will have to be
in managed recovery mode. Even if we put it in OPEN mode and work on
it, there is going to be a huge backlog of logs to be applied later on.
I would think that would cause a big delay in refreshing? I was
checking the redo log generated in prod for the past month. The average
per day seems to be 20GB and maximum of ~60GB/day and min of
5G/day. Not sure how long it would to take to apply 60GB. Also this
kind of setup would require manual intervention from the DBA everyday
to put in managed recovery mode, open etc.
Can the listers suggest options available for the
problem. 10g. We plan on using this in other systems too, which are
much smaller.
Thanks.