Re: Database Mirroring

Oracle DBA handbook suggests creating a mirror DB, setting the master DB in archivelog mode, and applying the archivelogs to the mirror as they are produced. Pretty slick.

regards

Peter Chan wrote:

> I want to set up two databases that have exactly the same schema in two
> different locations.
>
> I would like to know how I can do database mirroring, where both of my
> databases will look exactly the same, that is the data is exactly the
> same or almost the same at any given time.
>
> I was wondering if there are any tools out there that I can use to do
> this type of database mirroring or would I have to develop something
> like a trigger on the databases to propogate the data changes over to
> the mirrored database.
>
> Thanks a bunch.
>
> --
> ====================================================================
> PETER CHAN, Northern Telecom
> PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
> ====================================================================
Received on Mon May 11 1998 - 00:00:00 CEST