Re: Hot Standby Database

In article <4e0scr$s0o_at_cloner3.netcom.com>, Balkrishna Kute <kute_at_ix.netcom.com> wrote:
>
>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
>...

I've been working on the same thing. There are several pages on this in the Oracle Backup and Recovery Handbook (published by Oracle Press). That got me started, but a few of the steps were a little fuzzy. Oracle has a bulletin which is also helpful (Bulletin # 9460130.61).

You're on the right track - applying the archive logs is the right idea. But there are a few tricks - for example, the standyby database must be kept mounted, but not open. If you ever open it, you can't apply the redo logs anymore.

Personally, I can't wait until 7.3 ships. It has a hot standby feature built into it, and we won't have to mess with this anymore!

-- 

  Sue Brunkow                 brunkow_at_brooktree.com
  Brooktree Corp              (619) 535-3231
  San Diego, CA