Re: Help: How to deal with tempfile

Joe, Group,

I think you can try two things :

1. quick & dirty : in init.ora: instance_name=<newname>, and set lock_name_space=<any> this would allow you to open the "same" database, copied onto the same server. details : dataguard manuals on www.tahithi.com (and you do not need a gui to do this ;-)
2. better (IMHO): on original db : backup control file to trace, and use this to re-create controlfile(s) for the new database, this will allow you to bring up a 2nd, differnent, db on the same server. details : look for "cloning a database", anywhere.

Regards,

PdV
Oracle DBA
Disclaimers : AU, DTMWFI, JMTC, YMWV, YGTP

"joe bayer" <joebayerii(no-spam)@hotmail.com> wrote in message news:<0Hh_a.410$jw4.223_at_nwrdny03.gnilink.net>...
> I am using 9.2.0.3 on red hat linux.
> I am trying to clone a database on the same box.
>
> Here is what I did
> 1) shut down the original database A.
> 2) copy all the redo log file, datafile, control file and tempfile to the
> new location
> 3) edit the init file to point to the new controlfile,
> 4) mount the database
> 5) alter database rename datafile 'xxx' to 'yyyy'
> it works fine with ll the datafile and redo log file,
> but I can not rename tempfile
> 6 )start, mount and then open the cloned database B.
>
> but I can not start the database A now, because the database can not
> recognize the tempfile any more.
>
> What is the correct way of doing it?
>
> Your help is highly appreciated.
Received on Wed Aug 13 2003 - 01:02:45 CDT