Re: Copying existing instance to create a new instance

Sean Phillips wrote:
>
> Hello Guru's,
>
> I have been trying to make a new copy of my 'DEV' instance called 'TEST'
> on an HP-UX machine. I have done the following:
>
> 1. copied all my datafiles to proper new locations
>
> 2. SVRMGRL> alter database backup controlfile to trace ;
>
> 3. modified my trace file (called create_TEST.sql) , and changed all
> references of DEV to TEST
>
> 4. modified initTEST.ora and configTEST.ora files -- they now have
> correct parameters
>
> 5. shutdown the DEV instance
>

I'm no guru but have been doing a lot of this so here are my thoughts...

the DEV instance should be shut down after doing the backup to trace and * before * copying the files.

you didn't say you deleted the control files from the TEST instance - make sure they're gone

hope that helps.

fdp

	  Fred Pierce (DNRC)- QSS Group Inc. Oracle DBA
	Mid Atlantic Aviation on the Web - www.avialantic.com 
       MAAM WWII Commemorative Weekend June 5-7 /maamwwii.html
       --------------------------------------------------------