Re: Oracle 9i Replication to a Remote Site

On 16 May 2005 03:43:52 -0700, "Edwinah63" <edwinah_at_customercare.com.au> wrote:

>Hi Sybrand,
>
>thanks for your reply. i haven't researched Dataguard yet so please
>bear with my questions:
>
>* is this intended as an intermediate layer between the vb6 interface
>and the oracle server?
>

No, it isn't. Dataguard is the new marketing name for what was called Standby database in 8i. Dataguard is server to server communication, clients are not involved.
Currently there are two modes
a) physical standby. This simply ships archive logs to the standby database, the standby database is posted, and uses them for recovery. b) Logical standby: the archivelogs are transformed in actual inserts/updates/deletes at the remote side.

Note 1) This is transparent. Changes in the datamodel don't result in changes in your replication setup (which is inevitable with Oracle Replication, nowadays called Oracle Streams) Note 2) I don't think all Dataguard modes are available in the Standard Edition. IIRC, only the basic physical standby (described above) is available in Standard.

>* silly question time: should Dataguard be run off a separate server so
>if the main oracle box dies (as opposed to a single tablespace) it will
>flick over to the back up?
>

That's the whole purpose of it.

>i presume i still need to set up replication however between main.world
>and backup.world?

That is to be questioned. The backlog of a standby database could be smaller than the backlog of replication.

>
>any clues to what steps to follow? are there any good websites for
>Dataguard step by step?
>

As usual there is a separate manual for this option at http://tahiti.oracle.com

>regards
>
>Edwinah63
>
>(to email, remove h from edwinah :p)

--
Sybrand Bakker, Senior Oracle DBA