Re: Replication in Oracle 8.1.5

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 Received on Tue May 09 2000 - 00:00:00 CDT