Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Testing Refresh Procedure

Re: Testing Refresh Procedure

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 22 Mar 2006 14:49:13 -0600
Message-ID: <de807caa0603221249v377d5776k21a4e266f08264df@mail.gmail.com>


Kelley,

Is the database backed up on a regular basis? Do you trust the procedure? How recently has it been tested? Ever?
I advocate where possible, creating the test and development databases by recovering a backup. Nobody has enough time to test backups. But if you can combine it with the request to create a test or development database then you have a double winner.

Dennis Williams

On 3/21/06, Coleman, Kelley (HAC) <Kelley.Coleman_at_va.gov> wrote:
>
> Does anyone have a standard procedure for doing db refreshes that they'd
> be willing to share? I'd be going from Production down to test and
> development dbs. These were usually done by a co-worker who recently moved
> on to greener pastures. He didn't leave any desk procedures, so I've been
> winging it, but it seems like I'm making it harder than it needs to be.
>
>
>
> Should I drop relevant schemas before importing, so it's basically from
> scratch?
>
>
>
> I know the pastures guy would essentially do two imports, one just of
> table structures – no rows – then one just of data. Does that seem like a
> sound procedure?
>
> Kelley Coleman
> Database Administrator
> VA Health Administration Center
> Denver, Colorado
> 303-331-7521-o
>
> Confidentiality Note: This e-mail is intended only for the person or
> entity to which it is addressed, and may contain information that is
> privileged, confidential, or otherwise protected from disclosure.
> Dissemination, distribution, or copying of this e-mail or the information
> herein by anyone other than the intended recipient is prohibited. If you
> have received this e-mail in error, please notify the sender by reply
> e-mail, phone, or fax, and destroy the original message and all copies.
> Thank you
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 22 2006 - 14:49:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US