如何重命名DB- How to Rename DB_NAME with NID?

如何如何重命名DB- How to Rename DB_NAME with NID?  一般可以Follow 下面的过程:

 

 

rename database 重命名db,原DB_NAME=MACLEANS 需要修改为MACSH

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

 

 

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database Buffers 687865856 bytes
Redo Buffers 7118848 bytes
Database mounted.

 

 
[oracle@mlab1 ~]$ nid target=system/oracle DBNAME=MACSH SETNAME=Y

DBNEWID: Release 11.2.0.3.0 – Production on Tue May 28 12:00:16 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to database MACLEANS (DBID=639200705)

Connected to server version 11.2.0

Control Files in database:
+DATA/macleansh/controlfile/current.272.816564929
+FRA/macleansh/controlfile/current.256.816564929

Change database name of database MACLEANS to MACSH? (Y/[N]) => Y

Proceeding with operation
Changing database name from MACLEANS to MACSH
Control File +DATA/macleansh/controlfile/current.272.816564929 – modified
Control File +FRA/macleansh/controlfile/current.256.816564929 – modified
Datafile +DATA/macleansh/datafile/system.260.81656479 – wrote new name
Datafile +DATA/macleansh/datafile/sysaux.266.81656479 – wrote new name
Datafile +DATA/macleansh/datafile/undotbs1.264.81656479 – wrote new name
Datafile +DATA/macleansh/datafile/users.273.81656479 – wrote new name
Datafile +DATA/macleansh/datafile/example.263.81656499 – wrote new name
Datafile +DATA/macleansh/tempfile/temp.262.81656497 – wrote new name
Control File +DATA/macleansh/controlfile/current.272.816564929 – wrote new name
Control File +FRA/macleansh/controlfile/current.256.816564929 – wrote new name
Instance shut down

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

 
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database Buffers 687865856 bytes
Redo Buffers 7118848 bytes

SQL> alter system set db_name=’MACSH’ scope=spfile;

System altered.

 

SQL> startup force;
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database Buffers 687865856 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.

 

SQL> show parameter db_name

NAME TYPE VALUE
———————————— ———– ——————————
db_name string MACSH
SQL>
SQL>
SQL> select name from v$database;

NAME
———
MACSH

 

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569