使用nib修改Oracle数据库名称

有两个方法：一是将controlfile 转出来，修改数据库名称重建；另一个是使用nib 工具修改。我这里介绍nib 工具修改操作方法。

工具nib 是oracle 9i 开始提供的，专门用于修改数据库名称。

(墙内链接: http://mikixiyou.iteye.com/blog/1530140 )

第一步，备份整库。

因为这种操作会有可能失败，所以必须要先备份。

第二步，将库正常关闭，再启动到mount 状态。

第三步，使用nib 修改数据库名称

修改命令为  nid target=sys/welcome1 dbname=webdb

修改完成后，提示数据库已经关闭，需要使用open resetlogs 方式打开。

第四步，打开数据库。

打开之前，需要新生成符合新数据库名称的初始化参数文件和密码文件。监听器文件也需要做针对性修改。

 

/u04/webdb_rman@db3=>webreader$nid target=sys/welcome1 dbname=webdb

 

DBNEWID: Release 10.2.0.4.0 - Production on Tue May 15 11:43:33 2012

 

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

 

Connected to database WEBREADER (DBID=4271057885)

 

Connected to server version 10.2.0

 

Control Files in database:

    +VG1/webdb/control01.ctl

    +VG1/webdb/control02.ctl

    +VG1/webdb/control03.ctl

 

Change database ID and database name WEBREADER to WEBDB? (Y/[N]) => Y

 

Proceeding with operation

Changing database ID from 4271057885 to 2506031974

Changing database name from WEBREADER to WEBDB

    Control File +VG1/webdb/control01.ctl - modified

    Control File +VG1/webdb/control02.ctl - modified

    Control File +VG1/webdb/control03.ctl - modified

    Datafile +VG1/webdb/system01.dbf - dbid changed, wrote new name

    Datafile +VG2/webdb/data_salebill05.dbf - dbid changed, wrote new name

    Datafile +VG1/webdb/sysaux01.dbf - dbid changed, wrote new name

    Datafile +VG1/webdb/users01.dbf - dbid changed, wrote new name

    Datafile +VG1/webdb/undotbs02.dbf - dbid changed, wrote new name

   ………………………

    Instance shut down

 

Database name changed to WEBDB.

Modify parameter file and generate a new password file before restarting.

Database ID for database WEBDB changed to 2506031974.

All previous backups and archived redo logs for this database are unusable.

Database has been shutdown, open database with RESETLOGS option.

Succesfully changed database name and ID.

DBNEWID - Completed succesfully.

 

/u04/webdb_rman@db3=>webreader$sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 15 11:42:04 2012

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

 

Total System Global Area 5.1540E+10 bytes

Fixed Size                  2179936 bytes

Variable Size            6425676960 bytes

Database Buffers         4.5097E+10 bytes

Redo Buffers               14594048 bytes

Database mounted.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

 

/u04/webdb_rman@db3=>webreader$export ORACLE_SID=webdb

/u04/webdb_rman@db3=>webdb$sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 15 11:44:47 2012

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

Connected to an idle instance.

 

SQL> startup mount

ORACLE instance started.

 

Total System Global Area 5.1540E+10 bytes

Fixed Size                  2179936 bytes

Variable Size            6425676960 bytes

Database Buffers         4.5097E+10 bytes

Redo Buffers               14594048 bytes

Database mounted.

SQL> show parameter db_name

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_name                              string      webdb

SQL> alter database open resetlogs;

 

Database altered.

 

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            +VG2

Oldest online log sequence     1

Next log sequence to archive   1

Current log sequence           1

SQL>