RENAME DATABASE

[Jani]

How i can RENAME a database ?
Please write step by step.
Thanx

[julian]

1. Run as internal or sys "ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

2. You will get a trace file. Edit it so that it has the SET keyword:

CREATE CONTROLFILE SET DATABASE (new_name_of_the_database) RESETLOGS;

3. Shutdown immediate.

4. Make a cold backup.

5. Remove the existing controlfiles.

6. Edit init.ora to include db_name = (new_name_of_the_database).

6. startup nomount pfile=...;

7. Run the trace file from step 1 in order to create the new control files.

8. Run ALTER DATABASE OPEN RESETLOGS;

9. Make full backup.

[clio_usa]

The most detailed step-by-step instructions to do that:
http://www.dbaclick.com/cgi-bin/ib3/...=161;hl=change

It explains the recovery operation after the db name renaming.

Hope that helps,



--clio_usa
Senior Oracle DBA

[pravin]

In this scneario if he has taken cold backup after shutting down the database ,
he need not restore it right once the opens the database with resetlogs options
bcoz the idea was just to change the SID_NAME in the init.ora file. right ?

The backup one has to take is for precautionary purposes.

--Pravin