修改oracle数据库名

原创

wenxue_813 2012-08-09 22:53:37 博主文章分类：数据库技术 ©著作权

©著作权归作者所有：来自51CTO博客作者wenxue_813的原创作品，请联系作者获取转载授权，否则将追究法律责任

在测试使用rman复制数据库时，之前为了好区分，我把一个数据库命名为standby，但是貌似这是个保留字，不能使用。又不想重新建数，所以想修改数据库名。
修改数据库名有两种方法：一种方法是重建控制文件，一种方法是使用DBNEWID工具。重建控制文件步骤比较繁杂，所以我使用DBNEWID工具。

1，正常关闭数据库
sqlplus / as sysdba
SQL>shutdown immediate

2，启动数据库到mount模式
SQL>startup mount

3，确认LISTENER是启动的
lsnrctl status

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 09-DEC-2010 09:36:00

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=redhat6)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date                09-DEC-2010 09:34:47
Uptime                    0 days 0 hr. 1 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/soft/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/soft/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat6)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "standby" has 1 instance(s).
Instance "standby", status READY, has 1 handler(s) for this service...
Service "standby_XPT" has 1 instance(s).
Instance "standby", status READY, has 1 handler(s) for this service...
The command completed successfully

4，修改数据库名。使用DBNEWID工具修改数据库名时，比较以sysdba登录数据库，且要指定修改后的数据库名和使用setname选项。

nid target=sys/sys@standby dbname=demo setname=y

DBNEWID: Release 10.2.0.5.0 - Production on Thu Dec 9 09:36:04 2010

Connected to database STANDBY (DBID=1547703384)

Connected to server version 10.2.0

Control Files in database:
/u01/soft/oradata/standby/control01.ctl
/u01/soft/oradata/standby/control02.ctl
/u01/soft/oradata/standby/control03.ctl

Change database name of database STANDBY to DEMO? (Y/[N]) => y

Proceeding with operation
Changing database name from STANDBY to DEMO
Control File /u01/soft/oradata/standby/control01.ctl - modified
Control File /u01/soft/oradata/standby/control02.ctl - modified
Control File /u01/soft/oradata/standby/control03.ctl - modified
Datafile /u01/soft/oradata/standby/system01.dbf - wrote new name
Datafile /u01/soft/oradata/standby/undotbs01.dbf - wrote new name
Datafile /u01/soft/oradata/standby/sysaux01.dbf - wrote new name
Datafile /u01/soft/oradata/standby/users01.dbf - wrote new name
Datafile /u01/soft/oradata/standby/temp01.dbf - wrote new name
Control File /u01/soft/oradata/standby/control01.ctl - wrote new name
Control File /u01/soft/oradata/standby/control02.ctl - wrote new name
Control File /u01/soft/oradata/standby/control03.ctl - wrote new name
Instance shut down

Database name changed to DEMO.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.

5，修改参数文件，把原来的DB_NAME=standby修改为DB_NAME=demo
6，重新密码文件，orapwd file=/u01/soft/product/10.2.0/db_1/dbs/orapwdemo password=admin
7，使用修改后的pfile文件启动数据库

SQL> startup pfile='/u01/soft/admin/standby/pfile/init.ora.1025201033256'

8，创建spfile

SQL> create spfile from pfile='/u01/soft/admin/standby/pfile/init.ora.1025201033256';

9，重新启动数据库

SQL> shutdown immediate

SQL> startup

下面是nid命令的参数信息：

DBNEWID: Release 10.2.0.5.0 - Production on Thu Dec 9 09:50:02 2010

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