Note:15390.1 *Subject: * How to Determine and Change DB_NAME or ORACLE_SID
rm
On 11/10/05, J. Dex <cemail_219_at_hotmail.com> wrote:
>
> 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
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 10 2005 - 21:08:42 CST
