How i can RENAME a database ?
Please write step by step.
Thanx
Printable View
How i can RENAME a database ?
Please write step by step.
Thanx
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.
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
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