Re: Hot Standby Database
Date: 1996/01/30
Message-ID: <4elsd2$qgt_at_hpcc48.corp.hp.com>#1/1
Balkrishna Kute (kute_at_ix.netcom.com) wrote:
: Database Gurus,
: I am currently working on a Disaster Recovery Database which will be
: our hot standby in case of a disaster. Our database size is approx.
: 40G. What is the best way to implement this system? I am considering a
: procedure that would apply the archived log files to the database which
: will be essencially in recovery mode. Does anyone have any experience
: of implementing this? I would be glad to share my experience as well.
: Thanks,
: Balkrishna Kute
: e-mail: v.kute_at_ocf.compuserve.com or kute_at_ix.netcom.com
:
I've help implemented such a system for two clients. Essentially, you need a daemon running on the production node to transfer the achive logs over to the remote node, and another daemon on the remote node applying the archive logs on the mounted db. If you have o/s mirrorring implemented, you could even have two databases on the remote node: One would be mounted and never open to accept archive logs and another would be open and accessible to users as a "reporting system" (eg, a day old image of production db)
Johnny Chan
Independent Oracle Specialist
Received on Tue Jan 30 1996 - 00:00:00 CET