Re: Solutions for a parallel system

Thanks. If dataguard physical standby works, we will consider it too. Just getting allthe options and deciding on the best one.

On 3/5/08, Bradd Piontek <piontekdd_at_gmail.com> wrote:
>
> Some options:
> 1. Dataguard - Logical Standby (not all the same restrictions). FYI:
> 2. Oracle Streams
> 3. Quest Shareplex
> 4. Materialized views that fast refresh nightly
> 5. Snap-copy (SAN vendor) of the database refreshed nightly at disk level
> 6. Transportable tablespace? (may be a shot in the dark)
>
> On Wed, Mar 5, 2008 at 2:30 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
> > 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.
> >
> >
>
>

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