Using NID to Change DB Name (zt)

最新推荐文章于 2023-06-05 15:43:44 发布

转载最新推荐文章于 2023-06-05 15:43:44 发布 · 67 阅读

介绍了来自Sun Microsystems的DBA Darl Kuhn的技巧。在Oracle9i Database Release 2之前，重命名数据库需重建控制文件，而在Oracle9i Database Release 2中，可使用“nid”工具自动完成此任务。

http://www.dbonline.cn/source/oracle/20031215/STR_using%20NID%20to%20change%20DB%20name.html

This tip comes from Darl Kuhn, DBA at Sun Microsystems, in Broomfield, CO.
Description: Prior to Oracle9i Database Release 2, you were required to rebuild the controlfile to rename your database.
Now with Oracle9i Database Release 2, you can use the "nid" utility automates this task.

For example, if you want to change your database name to BRDSTN here are the steps:
1. Shutdown database
2. Startup mount
3. $ nid target=/ dbname=BRDSTN
4. Shutdown database
5. Change init.ora/spfile name, i.e.: initBRDSTN.ora
6. Change db_name parameter in init.ora/spfile, i.e.: db_name='brdstn'
7. Change ORACLE_SID to point to new database name
8. Startup mount
9. Alter database open resetlogs
10. Take a backup

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84342/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-84342/