Oracle怎么修改數(shù)據(jù)庫(kù)名稱

178次閱讀

共計(jì) 3285 個(gè)字符，預(yù)計(jì)需要花費(fèi) 9 分鐘才能閱讀完成。

這篇文章主要講解了“Oracle 怎么修改數(shù)據(jù)庫(kù)名稱”，文中的講解內(nèi)容簡(jiǎn)單清晰，易于學(xué)習(xí)與理解，下面請(qǐng)大家跟著丸趣 TV 小編的思路慢慢深入，一起來研究和學(xué)習(xí)“Oracle 怎么修改數(shù)據(jù)庫(kù)名稱”吧！

1. 關(guān)閉監(jiān)聽，正常關(guān)閉 Oracle

[oracle@node3 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 19-FEB-2019 09:35:04

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

SQL shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

2. 重啟數(shù)據(jù)庫(kù)到 mount 狀態(tài)

SQL startup mount force

ORACLE instance started.

Total System Global Area 2.1379E+10 bytes

Fixed Size 2262656 bytes

Variable Size 2.0401E+10 bytes

Database Buffers 939524096 bytes

Redo Buffers 36073472 bytes

Database mounted.

3.nid 修改數(shù)據(jù)庫(kù)名稱

nid target=sys/xxx dbname=BDDEV1 logfile=nid_0219.log

查看日志文件：

[oracle@node3 ~]$ more nid_0219.log

DBNEWID: Release 11.2.0.4.0 – Production on Tue Feb 19 09:33:15 2019

Connected to database BDDEV2 (DBID=2430401913)

Connected to server version 11.2.0

Control Files in database:

/opt/app/oracle/oradata/BDDEV1/control01.ctl

/opt/app/oracle/fast_recovery_area/BDDEV1/control02.ctl

Changing database ID from 2430401913 to 2391707803

Changing database name from BDDEV2 to BDDEV1

Control File /opt/app/oracle/oradata/BDDEV1/control01.ctl – modified

Control File /opt/app/oracle/fast_recovery_area/BDDEV1/control02.ctl – modified

Datafile /opt/app/oracle/oradata/BDDEV1/system01.db – dbid changed, wrote new name

Datafile /opt/app/oracle/oradata/BDDEV1/sysaux01.db – dbid changed, wrote new name

Datafile /opt/app/oracle/oradata/BDDEV1/undotbs01.db – dbid changed, wrote new name

Datafile /opt/app/oracle/oradata/BDDEV1/users01.db – dbid changed, wrote new name

Datafile /opt/app/oracle/oradata/BDDEV1/tbs_soe.db – dbid changed, wrote new name

Datafile /opt/app/oracle/oradata/BDDEV1/temp01.db – dbid changed, wrote new name

Control File /opt/app/oracle/oradata/BDDEV1/control01.ctl – dbid changed, wrote new name

Control File /opt/app/oracle/fast_recovery_area/BDDEV1/control02.ctl – dbid changed, wrote new name

Instance shut down

Database name changed to BDDEV1.

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

Database ID for database BDDEV1 changed to 2391707803.

All previous backups and archived redo logs for this database are unusable.

Database is not aware of previous backups and archived logs in Recovery Area.

Database has been shutdown, open database with RESETLOGS option.

Succesfully changed database name and ID.

DBNEWID – Completed succesfully.

如果日志文件中有報(bào)錯(cuò)信息，比如：NID-00135: There are 1 active threads，則可能是因?yàn)闆]有正常關(guān)閉數(shù)據(jù)庫(kù)導(dǎo)致的。

4. 修改參數(shù)文件中 db_name 后，啟動(dòng) Oracle

SQL startup nomount

ORACLE instance started.

Total System Global Area 1185853440 bytes

Fixed Size 2252664 bytes

Variable Size 436207752 bytes

Database Buffers 738197504 bytes

Redo Buffers 9195520 bytes

SQL alter system set db_name=BDDEV1 scope=spfile;

System altered.

SQL shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL startup mount

ORACLE instance started.

Total System Global Area 1185853440 bytes

Fixed Size 2252664 bytes

Variable Size 436207752 bytes

Database Buffers 738197504 bytes

Redo Buffers 9195520 bytes

Database mounted.

resetlogs 方式打開數(shù)據(jù)庫(kù)：

SQL alter database open resetlogs;

Database altered.

5. 打開監(jiān)聽

lsnrctl start

感謝各位的閱讀，以上就是“Oracle 怎么修改數(shù)據(jù)庫(kù)名稱”的內(nèi)容了，經(jīng)過本文的學(xué)習(xí)后，相信大家對(duì) Oracle 怎么修改數(shù)據(jù)庫(kù)名稱這一問題有了更深刻的體會(huì)，具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是丸趣 TV，丸趣 TV 小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章，歡迎關(guān)注！

正文完