Re: Has anyone done standby database or replication from OPS?

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1998/02/10
Message-ID: <34E10702.B37@deere.com>#1/1

I think the problem with using a standby database with OPS is that each instance of an OPS database records its own redo logs.

Don Granaman wrote:
>
> I have a large (80-90 GB) OLTP OPS database that needs to be replicated
> to another Oracle database. Does anyone out there have any experience
> with either:
>
> 1) Replication from OPS (2 node Sun PDB) to exclusive Oracle (Sun ES5000)?
>
> 2) Standby database - from OPS to exclusive Oracle?
>
> Everything I've heard leads me to think that (1) leads to horrible
> performance. Choice (2) is not supported, but two rather knowledgable DBAs
> have said it could probably be done by creating two threads in the single
> instance database - to "fake it out". Oracle and most DBAs I've talked to
> simply say that you can't do a standby database from OPS.
>
> Thanks!
Received on Tue Feb 10 1998 - 00:00:00 CST