Re: using a cold backup taken from aproduction db to update the test db

On 19 Mar 2003 09:24:49 -0800, natalia.poggi_at_spm.com.ar (Nat) wrote:

>I am new as an Oracle dba and I would like to know what are the steps
>involved in using a cold backup taken from a production db to update
>the test db.
>I have all the control files, data files, etc.
>I need to know which files have to be changed in order to correct the
>path - or wathever needs to be changed - accordingly to the test
>database init.ora file
>
>Thanks in advance
>
>Nat

Hi Nat,

1. Go to www.deja.com
2. Type "oracle cloning database create controlfile"
3. Among the ~95 hits, several nicely describe how to make a clone of a db, which seems to be what you need.
   • Kenneth Koenraadt