在Oracle12.1中使用NID 修改数据库的DBID和DBName【实战】

2025-04-17 技术教程

在异机恢复完成后，使用NID 修改数据库的DBID和DBName，重新启动数据库。

主要步骤如下：

1、开启数据库：

SQL>startupORA-32004:obsoleteordeprecatedparameter(s)specifiedforRDBMSinstanceORACLEinstancestarted.TotalSystemGlobalArea4.2950E+10bytesFixedSize4508576bytesVariableSize2.6172E+10bytesDatabaseBuffers1.5569E+10bytesRedoBuffers1203449856bytesDatabasemounted.Databaseopened.

2、创建pfile,用于对DBName进行参数修改

SQL>createpfilefromspfile;

3、查询当前的DBID和DBNAME

selectname,dbidfromv$database;

4、关闭数据库

SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>exit

5、备份数据文件，尤其是控制文件

cpproddatadata(简单进行冷备份)

6、将数据库启动到mount状态

[orapbf@erptestdbs]$exportORACLE_SID=PROD[orapbf@erptestdbs]$echo$ORACLE_SIDPROD

[orapbf@erptestdbs]$sqlplus/assysdbaSQL>startupmount;

7、查看nid命令简单帮助文档

[orapbf@erptest dbs]$ nid

DBNEWID:Release12.1.0.2.0-ProductiononWedMar1422:40:192018Copyright(c)1982,2014,Oracleand/oritsaffiliates.Allrightsreserved.KeywordDescription(Default)----------------------------------------------------TARGETUsername/Password(NONE)DBNAMENewdatabasename(NONE)LOGFILEOutputLog(NONE)REVERTRevertfailedchangeNOSETNAMESetanewdatabasenameonlyNOAPPENDAppendtooutputlogNOHELPDisplaysthesemessagesNO

8、使用nid修改dbid和DBName

[orapbf@erptestdbs]$nidtarget=sys/oracledbname=PBFDBNEWID:Release12.1.0.2.0-ProductiononWedMar1422:41:412018Copyright(c)1982,2014,Oracleand/oritsaffiliates.Allrightsreserved.ConnectedtodatabasePROD(DBID=357998902)Connectedtoserverversion12.1.0ControlFilesindatabase:/mnt/data/PBF/db/proddata/cntrl01.dbf/mnt/data/PBF/db/proddata/cntrl02.dbf/mnt/data/PBF/db/proddata/cntrl03.dbfChangedatabaseIDanddatabasenamePRODtoPBF?(Y/[N])=>yProceedingwithoperationChangingdatabaseIDfrom357998902to2995320870ChangingdatabasenamefromPRODtoPBFControlFile/mnt/data/PBF/db/proddata/cntrl01.dbf-modifiedControlFile/mnt/data/PBF/db/proddata/cntrl02.dbf-modifiedControlFile/mnt/data/PBF/db/proddata/cntrl03.dbf-modifiedDatafile/mnt/data/PBF/db/proddata/system01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system05.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/ctxd01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/owad01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_queue02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/odm.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/olap.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/sysaux01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/apps_ts_tools01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system12.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_data04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind06.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_ref03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_int02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/sysaux02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system13.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system14.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system15.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system16.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system17.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system18.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system19.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system20.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system21.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system22.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system23.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system24.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system25.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_ref04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_ref05.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_ref06.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/undo02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/cux_data01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/cux_ind01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/undo03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/undo04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/undo05.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/sysaux03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media05.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind07.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind08.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_data05.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_data06.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_queue03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/ctxd0-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media06.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media07.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/sysaux04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media08.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media09.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/sysaux05.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind09.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_data07.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media10.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media11.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media12.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media13.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media14.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media15.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media16.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media17.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media18.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_queue04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media19.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media20.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media21.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system10.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system06.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/portal01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system07.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system09.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system08.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/system11.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/undo01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_data01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_ref01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_int01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_summ01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_nolog01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_archive01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_queue01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_media01.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_data02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_data03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind03.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind04.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_txn_ind05.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/a_ref02.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp11.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp21.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp12.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp22.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp32.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp42.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp13.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp33.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp43.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp31.db-dbidchanged,wrotenewnameDatafile/mnt/data/PBF/db/proddata/temp41.db-dbidchanged,wrotenewnameControlFile/mnt/data/PBF/db/proddata/cntrl01.dbf-dbidchanged,wrotenewnameControlFile/mnt/data/PBF/db/proddata/cntrl02.dbf-dbidchanged,wrotenewnameControlFile/mnt/data/PBF/db/proddata/cntrl03.dbf-dbidchanged,wrotenewnameInstanceshutdownDatabasenamechangedtoPBF.Modifyparameterfileandgenerateanewpasswordfilebeforerestarting.DatabaseIDfordatabasePBFchangedto2995320870.Allpreviousbackupsandarchivedredologsforthisdatabaseareunusable.DatabaseisnotawareofpreviousbackupsandarchivedlogsinRecoveryArea.Databasehasbeenshutdown,opendatabasewithRESETLOGSoption.SuccesfullychangeddatabasenameandID.DBNEWID-Completedsuccesfully.

[orapbf@erptestdbs]$exit登出

9、修改参数文件

[orapbf@erptest~]$cd$ORACLE_HOME/dbs[orapbf@erptestdbs]$lshc_PROD.datinitPROD.oralkPRODsnapcf_PROD.fspfilePROD.ora[orapbf@erptestdbs]$viinitPROD.ora*.compatible='12.1.0'...*.db_name='PBF'...*._sort_elimination_cost_ratio=5*._system_trig_enabled=TRUE*._TRACE_FILES_PUBLIC=FALSE*.aq_tm_processes=1*.AUDIT_SYS_OPERATIONS=TRUE*.compatible='12.1.0'*.control_files='/mnt/data/PBF/db/proddata/cntrl01.dbf','/mnt/data/PBF/db/proddata/cntrl02.dbf','/mnt/data/PBF/db/proddata/cntrl03.dbf'#RestoreControlfile*.cursor_sharing='EXACT'#Required11isettting*.db_block_checking='FALSE'*.db_block_checksum='TRUE'*.db_block_size=8192*.db_files=512#Max.no.ofdatabasefiles*.db_name='PBF'*.db_recovery_file_dest_size=214748364800*.db_recovery_file_dest='/mnt/data/PBF/db/db_recovery_dest'*.diagnostic_dest='/mnt/data/PBF/db/12.1.0/admin/PBF_erptest'*.dml_locks=10000*.event='10995tracenamecontextforever,level16'*.job_queue_processes=10*.local_listener='PBF_LOCAL'*.log_archive_dest_1='LOCATION=/mnt/data/PBF/db/archive'"initPROD.ora"76L,2920C已写入

10、创建新的密码文件

orapwdfile=/mnt/data/PBF/db/12.1.0/dbs/initPBFpassword=oracleformat=12

11、使用resetlogs 选项打开数据库

[orapbf@erptestdbs]$sqlplus/assysdbaSQL*Plus:Release12.1.0.2.0ProductiononWedMar1422:46:592018Copyright(c)1982,2014,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupnomount;ORA-32004:obsoleteordeprecatedparameter(s)specifiedforRDBMSinstanceORACLEinstancestarted.TotalSystemGlobalArea4.2950E+10bytesFixedSize4508576bytesVariableSize1.1274E+10bytesDatabaseBuffers3.0467E+10bytesRedoBuffers1203449856bytesSQL>alterdatabasemount;Databasealtered.SQL>alterdatabaseopenresetlogs;SQL>selectname,dbidfromv$database;NAMEDBID-------------------PBF2995320870Databasealtered.sqlplus/assysdbastartup

12、创建新的spfile文件

createspfilefrompfile;