Creating/renaming a clone database

From: J. Dex <cemail_219_at_hotmail.com>
Date: Thu, 10 Nov 2005 21:59:56 -0500
Message-ID: <BAY106-F7F16984FCAE916D10A4FEA5590@phx.gbl>

I have database #1 on a server that I want to clone/restore from a cold backup so that it becomes database #2. Database #2 wiill be on the same server as #1 but I want to rename it. Other than creating a new directory structure and recreating the controlfile with all the new info, is there anything else that I need to do? Do you have to alter anything within the database (file names/structures) or will recreating the controlfile take care of it?

I don't want to bring the database up as the old SID because the SID already exists on that server so if something does have to be altered, I am not sure how to do it in this scenario.

Thanks for your help.

---

Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 10 2005 - 21:02:40 CST