Re: Urgent! How to copy an instance?

Shut down 'OLD' database. If you have time, cold backup! decide on a new SID (lets say 'NEW')
create a new initNEW.ora file - copy the old one but give it the new name. edit the new file to show the new position of the control files set ORACLE_SID to NEW
startup mount
alter database rename file 'old file' to 'newfile' (make sure you get the path right) for each and every file, including log files. At Unix (NT?) level, rename all OLD datafiles temporarily - belt & braces - makes sure files can't be opened by mistake!

alter database open - all should be ok
rename OLD files back to what they should be set ORACLE_SID to OLD
startup your OLD instance

Good luck
Knut Lassmann <knut.lassmann_at_mytoys.de> wrote in message news:399950ED.6F05677F_at_mytoys.de...
> Hi,
>
> I have an instance A and want to have an instance B which is
> an exact copy of A. When I copy all the data and control files
> to a new location where do I have to make changes in instance B
> to use the new (copied) datafiles. I have to avoid instance B
> using the datafiles of A.
> I need help because all this has to be done during the next 3
> houres (that's why I don't have the time to RTFM).
>
> Thank you in advance,
>
> Knut
>
> --
> Knut Lassmann myToys.de GmbH +49-30-72 62 01 411
> I had joy, I had fun, I had Pacman on a SUN(E3500).
Received on Tue Aug 15 2000 - 09:40:41 CDT