RE: how to rename a database SID

[Vergara, Michael (TEM)]

Title: how to rename a database SID

Uday:

 

You forgot one important step.  In the 'create controlfile' command

line, where you change the database SID you must add the word 'SET'.

 

For example, if the trace file was created as...

CREATE CONTROLFILE REUSE DATABASE "OLDSID" NORESETLOGS ARCHIVELOG

 

...then the new line must be changed to...

CREATE CONTROLFILE REUSE SET DATABASE "NEWSID" RESETLOGS ARCHIVELOG

 

HTH,

Mike

 

---

===========================================================================

Michael P. Vergara              | I’ve got a PBS mind in an MTV world

Oracle DBA                      |

Guidant Corporation             |

-----Original Message-----
From: udaycb [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 11:22 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: how to rename a database SID

Hear are the steps (on Unix),

 

Correct me if i am wrong.

 

1. Connect to svrmgrl,

2. Execute "alter database backup controlfile to trace;"

3. Find the trace file in udump directory. Edit the file and remove all unwanted lines i.e up to line "create control file...."

4. Change the database name save the file as .sql.

5. Shutdown the database.

6. Rename init.ora and config.ora also change the db_name parameters.

7. Connect to svrmgrl and run script which you have save as .sql in step 4.

Hope this info is helpful for you.

Note. Take a backup of your database before doing any off the above steps...

 

Good luck

Uday

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey Bronfin
Sent: Monday, June 18, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
Subject: how to rename a database SID

HI !
How can i rename a database on NT / UNIX ?
Thanks a lot in advance !