dbnewid修改dbid和库名

dbnewid可用于修改dbid和dbname。
dbnewid是oracle提供的工具程序，通过运行命令nid完成。
[oracle@target ~]$ nid

DBNEWID: Release 10.2.0.1.0 - Production on Tue Feb 18 15:58:50 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Keyword     Description                    (Default)
----------------------------------------------------
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO

1.修改全局数据库名
   不能使用dbnewid，可使用sql语句执行
   sql>conn / as sysdba
   sql>alter database rename global_name to ling.com;
   sql>select * from global_name;
2.修改dbid
  dbid是数据库内部的唯一标识符。因为rman使用dbid区分不同数据库，所以为了在同一恢复目录中备份源数据库和复制数据库，就需要改变dbid。
步骤:
sql>conn / as sysdba
sql>shutdown immediate;
sql>startup mount;
sql>host nid target=sys/ling
BNEWID: Release 10.2.0.1.0 - Production on Tue Feb 18 15:19:11 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to database LING (DBID=606074752)
Connected to server version 10.2.0
Control Files in database:
    /u01/oradata/LING/controlfile/o1_mf_8qk320b3_.ctl
    /u01/flash_recovery_area/LING/controlfile/o1_mf_8qk320mq_.ctl

Change database ID of database LING? (Y/[N]) => y

Proceeding with operation
Changing database ID from 606074752 to 632280239
    Control File /u01/oradata/LING/controlfile/o1_mf_8qk320b3_.ctl - modified
    Control File /u01/flash_recovery_area/LING/controlfile/o1_mf_8qk320mq_.ctl - modified
    Datafile /u01/oradata/LING/datafile/o1_mf_system_8qk32cxo_.dbf - dbid changed
    Datafile /u01/oradata/LING/datafile/o1_mf_undotbs1_8qk332sy_.dbf - dbid changed
    Datafile /u01/oradata/LING/datafile/o1_mf_sysaux_8qk339fm_.dbf - dbid changed
    Datafile /u01/oradata/LING/datafile/o1_mf_users_8qk33vwp_.dbf - dbid changed
    Datafile /u01/oradata/LING/datafile/goldengate.dbf - dbid changed
    Datafile /u01/oradata/LING/datafile/o1_mf_temp_8qk33gop_.tmp - dbid changed
    Control File /u01/oradata/LING/controlfile/o1_mf_8qk320b3_.ctl - dbid changed
    Control File /u01/flash_recovery_area/LING/controlfile/o1_mf_8qk320mq_.ctl - dbid changed
    Instance shut down

Database ID for database LING changed to 632280239.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.

sql>exit;
sql>conn / as sysdba
sql>startup mount;
sql>alter database open resetlogs;

3.更改dbname
使用数据库的高级复制特性时，需要两个数据库的库名不一样。修改数据库名有两种方式：1.重建控制文件2.使用dbnewid工具
步骤：
sql>conn / as sysdba
sql>shutdown immediate;
sql>startup mount;
sql>host nid target=sys/ling dbname=ling setname=y

输入y
sql>alter system set db_name=ling scope=both;  --修改初始化参数文件中的库名
sql>host  orapwd file=$ORACLE_HOME/dbs/pwding.ora password=admin

重启数据库：
sql>conn /as sysdba
sql>startup pfile=$ORACLE_HOME/dbs/initling.ora
sql>create spfile from pfile;

 

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

转载于:http://blog.itpub.net/26764468/viewspace-1083309/