ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Using NID to Change DB Name (zt)

Using NID to Change DB Name (zt)

原创 Linux操作系统 作者:tolywang 时间:2005-06-23 00:00:00 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle Job 小结(ZT)
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13209616