GLOBAL_NAMES

You might also have to reset the global names parameter

ALTER DATABASE RENAME GLOBAL_NAME TO new_db_name;

We use the re-create the control file technique to quickly copy our production database to our testing machine. A few FTP command, re-create the control file and presto! a new database for testing.

John

-----Original Message-----
From: Parisa Haratian [mailto:parisa.haratian_at_unisys.com] Posted At: Thursday, September 02, 1999 11:01 PM Posted To: server
Conversation: How to Rename a Database? Subject: Re: How to Rename a Database?

Thank you very much. It worked fine.

Thiru <tmgn_at_excite.com> wrote in message news:37CEA195.DE77DC0C_at_excite.com...
> 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 Fri Sep 03 1999 - 09:48:36 CDT