I assume both OS are same (Linux).
What you can do is rename the filenames using alter tablespace or alter database rename file. So
1) Copy database files, archive logs etc. to new machine
2) Startup mount
3) Rename files
4) Start recovery
You could also take a backup controlfile to trace then change the file u get in udump to change the file names. Then use it to create a controlfile on the new machine. However using controlfile and creating a new controlfile means you can only do 'resetlogs'.
1) Copy database files to new machine
2) Startup nomount
3) Create controlfile
4) Start recovery
Seema Singh <oracledbam@hotmail.com> wrote:
Hi,
I have hotbackup for x date.I want to create clone to another box on
Linux(Oracle9i).
is it possible to clone with same instance name on diffrent box with
diffrent file location?I think yes.
Can someone send me correct steps how to clone on linux box?
Thx
-Seema
_________________________________________________________________
Get holiday tips for festive fun.
http://special.msn.com/network/happyholidays.armx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Seema Singh
INET: oracledbam@hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fa!
tcity.com
(note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: anu
INET: anu_77_d_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 08 2003 - 19:14:27 CST
