Re: Comments?

"gazzag" <gareth_at_jamms.org> wrote in message news:28dd705b-5d2c-4962-a960-cdb88031e91a_at_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

Our off site DBA.

I've been harping about RMAN since I first started here (as a contractor before being hired in). Other than having my head bit off I was told he wasn't using RMAN because he didn't have an RMAN repository set up. I think I got in trouble for calling him on the fact that the repository isn't mandatory for using RMAN. Received on Wed Jul 23 2008 - 15:28:21 CDT