------- 修改數(shù)據(jù)庫(kù)db_name的方法 

我們注重客戶提出的每個(gè)要求，我們充分考慮每一個(gè)細(xì)節(jié)，我們積極的做好網(wǎng)站設(shè)計(jì)制作、成都網(wǎng)站建設(shè)服務(wù)，我們努力開(kāi)拓更好的視野，通過(guò)不懈的努力，創(chuàng)新互聯(lián)贏得了業(yè)內(nèi)的良好聲譽(yù)，這一切，也不斷的激勵(lì)著我們更好的服務(wù)客戶。 主要業(yè)務(wù)：網(wǎng)站建設(shè),網(wǎng)站制作,網(wǎng)站設(shè)計(jì),小程序開(kāi)發(fā),網(wǎng)站開(kāi)發(fā),技術(shù)開(kāi)發(fā)實(shí)力，DIV+CSS，PHP及ASP，ASP.Net，SQL數(shù)據(jù)庫(kù)的技術(shù)開(kāi)發(fā)工程師。

SQL>  startup mount 

ORACLE instance started.

Total System Global Area  413372416 bytes

Fixed Size    2213896 bytes

Variable Size  335546360 bytes

Database Buffers   71303168 bytes

Redo Buffers    4308992 bytes

Database mounted.

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

[oracle@OEL6 dbs]$ nid target=sys/yuanlei@orcl2 dbname=orcl

DBNEWID: Release 11.2.0.1.0 - Production on Tue Aug 19 22:22:39 2014

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

Connected to database ORCL2 (DBID=836865814)

Connected to server version 11.2.0

Control Files in database:

    /u01/app/oracle/oradata/orcl2/control01.ctl

    /u01/app/oracle/oradata/orcl2/control02.ctl

Change database ID and database name ORCL2 to ORCL? (Y/[N]) => y

Proceeding with operation

Changing database ID from 836865814 to 1383851439

Changing database name from ORCL2 to ORCL

    Control File /u01/app/oracle/oradata/orcl2/control01.ctl - modified

    Control File /u01/app/oracle/oradata/orcl2/control02.ctl - modified

    Datafile /u01/app/oracle/oradata/orcl2/system01.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/sysaux01.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/undotbs01.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/users01.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/example01.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl01.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl02.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl03.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl04.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl05.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl06.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl07.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/tbs_yl08.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/rcatalog.db - dbid changed, wrote new name

    Datafile /u01/app/oracle/oradata/orcl2/temp01.db - dbid changed, wrote new name

    Control File /u01/app/oracle/oradata/orcl2/control01.ctl - dbid changed, wrote new name

    Control File /u01/app/oracle/oradata/orcl2/control02.ctl - dbid changed, wrote new name

    Instance shut down

Database name changed to ORCL.

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

Database ID for database ORCL changed to 1383851439.

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.

分享文章：Oracle修改db_name方法
URL網(wǎng)址：http://www.chinadenli.net/article0/peciio.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站內(nèi)鏈、App開(kāi)發(fā)、商城網(wǎng)站、微信公眾號(hào)、企業(yè)網(wǎng)站制作、網(wǎng)站設(shè)計(jì)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)