Re: Comments?

"Ed Prochak" <edprochak_at_gmail.com> wrote in message news:612b755c-df6b-4fd1-98f5-93b2516b05c1_at_34g2000hsh.googlegroups.com...
> On Jul 22, 8:28 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> 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