Re: How to Rename a Database?

FRom My Earlier Posting :

You need to REcreate the Control file to achieve this .

1. SVRMGR>Alter Database backup controlfile to trace; # this will generate an Ascii Trace file in $USER_DUMP_DEST directory which

will have the Control File Creation Script.

2. Shutdown the Database and Do a Physical Backup of all the Datafiles,Controlfiles,RedoLog files,Archived Redo log files etc etc...for Safety.

3. Rename the Init<oldSID>.ora and config<OLDSID>.ora to Init<NEWSID>.ora and
Config<NewSid>.ora files in $ORACLE_HOME/dbs This is to prevent any errors

during Database Startups looking for default 'pfile' names.

4. Edit the Config<NewSid>.ora file and Change db_name = <New_Sid>

5.Rename the Old Controlfiles to say control01.old etc This is to Create New
Controlfile and not reuse the existing one.

6 Edit the Control File creation Script ..It should read like

 Startup nomount;
  Create Controlfile set Database 'NEW_SID' Resetlogs ...... <all others remain the Same>
;
7.alter database open resetlogs;

8.Edit /etc/oratab or /var/opt/oracle/oratab files to reflect the Change in the Name of the SID..
.
Hope this helps

-Thiru

Parisa Haratian wrote:

> Hi All
>
> How can I rename a database?
> I'd like to make a copy of an existing one and then rename it. I cannot
> use Export.
>
> Thank you in advance
>
> PH
Received on Thu Sep 02 1999 - 11:11:01 CDT