How can I rename the database from xyz to abc?
Thanks.
Printable View
How can I rename the database from xyz to abc?
Thanks.
1. alter system backup controlfile to trace
2. shutdown database (normal or immediate)
3. backup database
4. create new $ORACLE_BASE/admin/$ORACLE_SID directory
5. copy files from $ORACLE_BASE/admin/old_oracle_sid to $ORACLE_BASE/admin/new_oracle_sid
6. edit init.ora and change any references from old SID to new SID
7. create orapw file (orapw file=orapwNEW_SID)
8. edit trace file
8.1 Get rid of garbage before STARTUP NOMOUNT
8.2 Change CREATE CONTROLFILE REUSE to CREATE CONTROLFILE REUSE SET
8.3 Comment out RECOVER DATABASE
8.4 Change ALTER DATABASE OPEN to ALTER DATABASE OPEN RESETLOGS
8.5 Change any references of the old SID to the new SID
9. svrmgrl
10. connect internal
11. @your_trace_file_name_created_in_step_8
12. shutdown (immediate or normal)
13. backup database (don't overwrite step #2)
14. startup database
There was a discussion on this in the past --
http://ora.dbasupport.com/forums/sho...?threadid=5586
- Rajeev
1. backup controlfile to trace
2. take cold backup
3. rename parameters like db_name, service_name, instance_name in init.ora
4. edit the trace file to specify new db name
5. recreate the controlfile at nomount
Take the controlfile to trace. Change it in that. change the DB name init.ora. Create the controlfile
And restart the database.
Jeff:
I followed the steps as suggested and I am getting following error
SVRMGR> @cntrlbak.ctl
LRM-00109: could not open parameter file '/opt/app/oracle/product/8.0.5/dbs/initOLD_DB_NAME.ora'
ORA-01078: failure in processing system parameters
CREATE CONTROLFILE REUSE SET DATABASE "NEW_DB_NAME" NORESETLOGS NOARCHIVELOG
*
ORA-01034: ORACLE not available
ALTER DATABASE OPEN RESETLOGS
*
ORA-01034: ORACLE not available
Let me know, what could be wrong...
Thanks.
set $ORACLE_SID=newsid
Your environment is still set to the old sid, so change it to the new sid and try again from step 9.
Be sure to go and edit oratab, tnsnames.ora and listener.ora
You are right.
I made changes to listerner.
Do I need to shutdown the listerner and startup again?
Thanks.
you can just RELOAD the listener.
lsnrctl> RELOAD
- Rajeev
Hi
I tried it.
when I did lsnrctl status, I am seeing old database name instead of
new database name.
Hi
I tried it.
When I did lsnrctl status , I am seeing old database name instead of new.
Let me know.
Thanks.
stop and restart. At the prompt
$lsnrctl stop
$lsnrctl start
And see the status now.
$lsnrctl status
Thanks every one...
It is now up and running..
Thanks again..