网站宣传页面模板,精品课程网站建设项目验收单,国外idc网站,找做网站的公司DBNEWID 是一个数据库实用程序#xff0c;用于更改 Oracle 数据库的 DBNAME 和 DBID。可以更改 DBID 或 DBNAME 或两者。 DBNAME 是在创建数据库时指定的数据库名称#xff0c;DBID 是创建数据库时分配给数据库的唯一编号。 以下步骤演示如何使用 DBNEWID 实用程序更改 Oracl…DBNEWID 是一个数据库实用程序用于更改 Oracle 数据库的 DBNAME 和 DBID。可以更改 DBID 或 DBNAME 或两者。 DBNAME 是在创建数据库时指定的数据库名称DBID 是创建数据库时分配给数据库的唯一编号。 以下步骤演示如何使用 DBNEWID 实用程序更改 Oracle 数据库的 DBNAME 和 DBID。 重要提示开始此过程之前请确保拥有数据库的完整备份。 Step 1开始之前找出数据库当前的 DBNAME 和 DBID
SQL SELECT DBID,NAME from V$DATABASE;DBID NAME
---------- ---------
2426088413 MYORDBStep 2第一步是启动实例并挂载数据库但不打开数据库。
sqlplus / as sysdbaSQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startup mount
ORACLE instance started.Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 553648592 bytes
Database Buffers 511705088 bytes
Redo Buffers 4603904 bytes
Database mounted.SQL exit
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - ProductionStep 3. 通过指定连接字符串和数据库的新名称来运行 DBNEWID 实用程序。 连接字符串中指定的用户应具有 SYSDBA 权限。
nid targetsys/MYPASSMYORDB dbnameMYNEWDB setnameYES
DBNEWID: Release 11.2.0.1.0 - Production on Tue May 30 12:50:01 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Connected to database MYORDB (DBID2436089413)Connected to server version 11.2.0Control Files in database:C:ORADATAMYORDBCONTROL01.CTLC:ORADATAMYORDBCONTROL02.CTLChange database name of database MYORDB to MYNEWDB? (Y/[N]) YProceeding with operation
Changing database name from MYORDB to MYNEWDBControl File C:ORADATAMYORDBCONTROL01.CTL - modifiedDatafile C:ORADATAMYORDBSYSTEM01.DB - wrote new nameDatafile C:ORADATAMYORDBSYSAUX01.DB - wrote new nameDatafile C:ORADATAMYORDBUNDOTBS01.DB - wrote new nameDatafile C:ORADATAMYORDBUSERS01.DB - wrote new nameDatafile C:ORADATAMYORDBMYORDBDAT01.DB - wrote new nameDatafile C:ORADATAMYORDBMYORDBIDX01.DB - wrote new nameDatafile C:ORADATAMYORDBTEMP01.DB - wrote new nameControl File C:ORADATAMYORDBCONTROL01.CTL - wrote new nameControl File C:ORADATAMYORDBCONTROL02.CTL - wrote new nameInstance shut downDatabase name changed to MYNEWDB.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.Step 4: Shut down the database.
SQL shutdown immediateStep 5将初始化参数文件中的DB_NAME初始化参数设置为新的数据库名称。
sqlplus / as sysdbaSQL show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string MYORDBSQL alter system set db_nameMYNEWDB scopespfile;
System altered.Step 6: 创建一个新的密码文件。
orapwd fileorapwMYNEWDB passwordMYPASSStep 7: 启动DB
SQL startup mountStep 8验证名称更改
SELECT DBID,NAME from V$DATABASE;DBID NAME
---------- ---------
2426088413 MYNEWDB
