Re: Comments?

From: Dereck L. Dietz <>
Date: Wed, 23 Jul 2008 16:28:21 -0400
Message-ID: <LtMhk.30977$>

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

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


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

Original text of this message