Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: Testing Refresh Procedure

From: Daniel Fink <>
Date: Tue, 21 Mar 2006 08:29:00 -0800 (PST)
Message-ID: <>


The process that is being used is sound and you know it works.

What a great opportunity for change! There is a wonderful chance to test your backup/recovery at the same time. This is a bit more complicated, so you might not want to do it every time. It also is dependent upon how the backups are being performed. There are also some 'gotchas', such as database links, hard coded connection strings, etc. that you need to work around.

I have used RMAN to refresh non-prod databases from production backups and it works incredibly well (as long as you remember the gotchas including changing the database id). I have also used non-RMAN backups to create these databases.

Dan Fink

"Coleman, Kelley (HAC)" <> 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

 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          

Received on Tue Mar 21 2006 - 10:29:00 CST

Original text of this message