Re: How To Test Disaster Recovery?

From: John P. Higgins <jh33378_at_deere.com>
Date: Wed, 18 Nov 1998 20:56:02 -0600
Message-ID: <365388C1.23C3F05E@deere.com>

Well, try this:

Declare your building destroyed, kaput!

Now retrieve your backups from their off site vault and take them to your disaster recovery partner site. Configure a machine to look like your production machine, restore, recover and start up. Let your users connect via dial-up.

You may find that building and configuring the machine is the hard part. It doesn't have to be, but it takes planning. Also, machines evolve, so keep your rebuild plans current.

Full site disasters are rare. Practice for these once every 5 years.

Single disk crashes are frequent. Use RAID to prevent what you can. Practice for these several times a year. Try all combinations of lost files -- SYSTEM, data, index, temp, rollback, logs. You want to learn how to minimize the loss of service: recover a non-SYSTEM tablespace while the rest of the system stays on-line. Practice.

Gene Hubert wrote:

I'm looking for some realistic scenarios to test disaster
recovery in Oracle.  I've restored from a a full backup and
rolled forward, but would like to devise something more
realistic.
I would appreciate any ideas or references on the kinds of stuff
I ought to be testing.
I'm running Oracle 8.0.3 on NT 4.0.


Gene Hubert
Qualex Inc.
Durham, NC

  Received on Wed Nov 18 1998 - 20:56:02 CST