Re: Comments?

From: Dereck L. Dietz <>
Date: Wed, 23 Jul 2008 20:21:50 -0400
Message-ID: <FUPhk.15185$>

"Ed Prochak" <> wrote in message
> On Jul 22, 8:28 pm, "Dereck L. Dietz" <> wrote:
>> The below is a portion of an email describing how the plan for disaster
>> recovery has been explained to us. This is an Oracle 10g database
>> running
>> on Windows 2003 server.
>> The way we did the disaster recovery backup is:
>> Step1:
>> 1.. Export the entire db (with no rows option) - This will get a copy
>> of
>> export to recreate the database with all users and system settings.
>> 2.. Export the entire schema (with no rows option) - This will get a
>> copy
>> of export to recreate empty table shells with indexes, keys and all
>> procedures, packages, functions and any other metadata for each user.
>> 3.. Export every table by schema (all table data) - This is all the
>> data.
>> Step2: Every export file is zipped and encrypted using gpg
>> Step3: Move the whole archive to USB drive.
>> The entire process takes about 5 full days. Which is ok considering its
>> once a month job. Most of it is automatically done except for moving to
>> usb
>> and preparing the scripts. The total size of this is about 170GB.
>> We have 1tb disks which can hold up to 5 or 6 of these copies.
> Along with other comments, I will add that this is at best half of
> disaster recovery planning. Have you ever actually tried to restore
> from these backups? Until you can successfully do that, you do not
> have a recovery plan.
> Ed

We haven't received the instructions on how to restore nor have we had a chance to practice a restore. Received on Wed Jul 23 2008 - 19:21:50 CDT

Original text of this message