Re: Comments?

From: gazzag <gareth_at_jamms.org>
Date: Wed, 23 Jul 2008 03:11:16 -0700 (PDT)
Message-ID: <28dd705b-5d2c-4962-a960-cdb88031e91a@d1g2000hsg.googlegroups.com>


On 23 Jul, 02:28, "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.

Who devised this "strategy"? Have they not heard of RMAN, for example?

-g Received on Wed Jul 23 2008 - 05:11:16 CDT

Original text of this message