Oracle nid更改dbname
免费下载
http://docs.oracle.com/cd/E11882_01/server.112/e22490/
dbnewid.htm#SUTIL1544
SQL> create pfile from spfile;
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.6657E+10 bytes
Fixed Size 2234080 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 1.3757E+10 bytes
Redo Buffers 12431360 bytes
Database mounted.
[csyz_oracle:/home/oracle$ps -ef|grep smon
oracle 229542 1 0 Mar 05 - 1:54 ora_smon_ORCL87
oracle 286966 209758 0 15:40:27 pts/2 0:00 grep smon
oracle 270998 1 0 15:39:08 - 0:00 ora_smon_ORCL87
grid 86884 1 0 Mar 05 - 0:08 asm_smon_+ASM
[csyz_oracle:/home/oracle$nid TARGET=SYS DBNAME=ORCL87 SETNAME=YES
DBNEWID: Release 11.2.0.3.0 - Production on Tue Mar 11 15:40:45 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
reserved.
Password:
Connected to database ORCL87 (DBID=4183327063)
Connected to server version 11.2.0
Control Files in database:
+DG_DATA1/ORCL87/controlfile/current.256.840725021
Change database name of database ORCL87 to ORCL88? (Y/[N]) => Y
Proceeding with operation
Changing database name from ORCL87 to ORCL88
Control File +DG_DATA1/ORCL87/controlfile/current.256.840725021
- modified
Datafile +DG_DATA1/ORCL87/datafile/system.260.84072505 - wrote
new name
Datafile +DG_DATA1/ORCL87/datafile/sysaux.261.84072506 - wrote
new name
Datafile +DG_DATA1/ORCL87/datafile/undotbs1.262.84072506 - wrote
new name
Datafile +DG_DATA1/ORCL87/datafile/users.264.84072508 - wrote
new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_large.
266.84183114 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_tab_large.
267.84183121 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/sts_precise_i3_pw.
268.84183128 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_tab_medium.
269.84183144 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_tab_medium.
270.84183163 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_medium.
271.84183176 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_medium.
272.84183190 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_tab_small.
273.84183208 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_tab_small.
274.84183228 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_tab_small.
275.84183249 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_tab_small.
276.84183270 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_small.
277.84183277 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_small.
278.84183297 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_small.
279.84183317 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_small.
280.84183336 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_85_ind_small.
281.84183356 - wrote new name
Datafile +DG_DATA1/ORCL87/datafile/precise_i3_pw_tab_infra.
282.84183370 - wrote new name
Datafile +DG_DATA1/ORCL87/tempfile/temp.263.84072506 - wrote new
name
Control File +DG_DATA1/ORCL87/controlfile/current.256.840725021
- wrote new name
Instance shut down
Database name changed to ORCL88.
Modify parameter file and generate a new password file before
restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.
[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$cp
initORCL87.ora initORCL88.ora
[csyz_oracle:/i3data1/oracle/app/oracle/product/11.2.0/db/dbs$vi
initORCL88.ora
*.db_name='ORCL88'
of 5
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论