I have the database, how can I rename it without any problems, what are the steps for it?
Thank you.
Printable View
I have the database, how can I rename it without any problems, what are the steps for it?
Thank you.
ORACLE_SID or db_name
I think u ment ot say db_name,
Take Backup:
1)MAke sure no one is using the database
2)alter database backup controlfile to trace;
3)Edit this file and change database name to new one.NORESETLOGS to RESETLOGS.
4)change db_name in your init/config file
5)From svrmgrl , run this script.
Are you using global db_domain
Take Care
GP
In step 4:
-> Change db_name, service_name and instance_name in init.ora and/or config.ora
-
In step 5:
-> run script from svrmgrl @nomount to recreate the controlfile.
---
Suggestion:
Open the db after recreating the controlfile, shutdown the db and restart to make sure that it opens the db cleanly.
[Edited by Halo on 02-26-2001 at 03:49 PM]
Thank you!
To add
service_name is only used in 8i onwards, but is same as db_name if db_domain is null.
Thanks
GP