Re: Comments?

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.
>
>
>
>

Clearly your "DBA" or "Architect" or "Consultant" or whatever he calls himself, has not the faintest clue how to go about things. Sadly, one sees this all too often.

Good luck.
Palooka Received on Wed Jul 23 2008 - 17:53:17 CDT