UseNidtoChangedbname

来源：互联网发布：在线教育培训系统源码编辑：程序博客网时间：2024/05/29 03:43

原文链接:

http://www.eygle.com/faq/Use.Nid.to.Change.Your.dbname.htm

Nid是从9iR2开始提供的工具，可以用来更改名称，而无需通过之前重建控制文件等繁琐方式.
需要说明的是，虽然这个工具来自9iR2，但是仍然可以被用于Oracle8i.

先看一下帮助:

C:/>nid-helpDBNEWID:Release10.1.0.2.0-ProductionCopyright(c)2001,2004,Oracle.Allrightsreserved.关键字说明(默认值)----------------------------------------------------TARGET用户名/口令(无)DBNAME新的数据库名(无)LOGFILE输出日志(无)REVERT还原失败的更改否SETNAME仅设置新的数据库名否APPEND附加至输出日志否HELP显示这些消息否

我们通过范例来看一下用法:

1．数据库当前设置

SQL>select*fromv$version;BANNER----------------------------------------------------------------Oracle9iEnterpriseEditionRelease9.2.0.1.0-ProductionPL/SQLRelease9.2.0.1.0-ProductionCORE9.2.0.1.0ProductionTNSfor32-bitWindows:Version9.2.0.1.0-ProductionNLSRTLVersion9.2.0.1.0-ProductionSQL>showparameternameNAMETYPEVALUE-----------------------------------------------------------------------------db_file_name_convertstringdb_namestringeyglevglobal_namesbooleanFALSEinstance_namestringeyglevlock_name_spacestringlog_file_name_convertstringoracle_trace_collection_namestringoracle_trace_facility_namestringoracledplsql_native_make_file_namestringservice_namesstringeyglev

2．Shutdown数据库

SQL>connectsys/orasysassysdbaConnected.SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.

3．Startupmount

SQL>startupmount
ORACLEinstancestarted.

TotalSystemGlobalArea135338868bytes
FixedSize453492bytes
VariableSize109051904bytes
DatabaseBuffers25165824bytes
RedoBuffers667648bytes
Databasemounted.

4.使用NID更改

SQL>hostMicrosoft[Version5.00.2195](C)版权所有1985-2000MicrosoftCorp.C:/>nidtarget=sys/orasysdbname=eyglenDBNEWID:Release9.2.0.1.0-ProductionCopyright(c)1995,2002,OracleCorporation.Allrightsreserved.ConnectedtodatabaseEYGLEV(DBID=677189177)ControlFilesindatabase:E:/ORACLE/ORADATA/EYGLEN/CONTROL01.CTLE:/ORACLE/ORADATA/EYGLEN/CONTROL02.CTLE:/ORACLE/ORADATA/EYGLEN/CONTROL03.CTLChangedatabaseIDanddatabasenameEYGLEVtoEYGLEN?(Y/[N])=>YProceedingwithoperationChangingdatabaseIDfrom677189177to3955758099ChangingdatabasenamefromEYGLEVtoEYGLENControlFileE:/ORACLE/ORADATA/EYGLEN/CONTROL01.CTL-modifiedControlFileE:/ORACLE/ORADATA/EYGLEN/CONTROL02.CTL-modifiedControlFileE:/ORACLE/ORADATA/EYGLEN/CONTROL03.CTL-modifiedDatafileE:/ORACLE/ORADATA/EYGLENYSTEM01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/UNDOTBS01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/CWMLITE01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/DRSYS01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/INDX01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/ODM01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/TOOLS01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/USERS01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/XDB01.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/EYGLE.DBF-dbidchanged,wrotenewnameDatafileE:/ORACLE/ORADATA/EYGLEN/TEMP01.DBF-dbidchanged,wrotenewnameControlFileE:/ORACLE/ORADATA/EYGLEN/CONTROL01.CTL-dbidchanged,wrotenewnameControlFileE:/ORACLE/ORADATA/EYGLEN/CONTROL02.CTL-dbidchanged,wrotenewnameControlFileE:/ORACLE/ORADATA/EYGLEN/CONTROL03.CTL-dbidchanged,wrotenewnameDatabasenamechangedtoEYGLEN.Modifyparameterfileandgenerateanewpasswordfilebeforerestarting.DatabaseIDfordatabaseEYGLENchangedto3955758099.Allpreviousbackupsandarchivedredologsforthisdatabaseareunusable.ShutdowndatabaseandopenwithRESETLOGSoption.SuccesfullychangeddatabasenameandID.DBNEWID-Completedsuccesfully.1<script type="text/javascript"></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>