Note:15390.1 *Subject: * How to Determine and Change DB_NAME or ORACLE_SID rm On 11/10/05, J. Dex <cemail_219@xxxxxxxxxxx> 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/ > > -- > //www.freelists.org/webpage/oracle-l > > >