Re: Replication in Oracle 8.1.5

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:957907827.9432.0.pluto.d4ee154e_at_news.demon.nl...
>
> sreedhar <swarsree_at_my-deja.com> schreef in berichtnieuws
> 8f9q23$s75$1_at_nnrp1.deja.com...
> > Hi All Oracle DBA Experts,
> > I am a newbie trying to implement Replication. I need to
 implement the
> > Oracle's advanced replication option. I have Oracle
 Enterprise Edition
> > 8.1.5 on sun solaris 2.6.
> > Scenario Description
> > we have two unix boxes with two different databases running
 on each
> > box. one of them is the production server and the other is
 the backup
> > server. I need to replicate all the dynamic tables and few
 sequences
> > from the production server to the backup server. For some
 reason if the
> > production server fails then the equaliser will
 automatically route the
> > requests to the backup server. SO, AT ANY POINT OF TIME,
 BOTH THE
> > PRODUCTION SERVER AND BACKUP SERVER SHOULD BE IN SYNC.
> > I referred to oracle documentation which talks about
 propogating the
> > changes at a later time. Is there any way I can make
 implement
> > replication to achieve the above functionality(changes to
 the
> > production server should be propogated to the backup server
 immediately
> > and in the same order).
> > Any HELP is greatly appreciated.
> > thanks
> >
> > --
> > Sreedhar
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> SO, AT ANY POINT OF TIME, BOTH THE
> PRODUCTION SERVER AND BACKUP SERVER SHOULD BE IN SYNC
>
> You need to setup a standby database, not a replicated one.
 Replication will
> always show delays. The hot standby database is synced on file
 level by
> applying redo logs automatically.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>

Another option is to connect both of the servers to shared disk cabinets or disk arrays.

To use both servers at the same time, you'd need Oracle Parallel Server.

Without OPS, then the second server would be a configured as Received on Tue May 09 2000 - 00:00:00 CDT