如何更改数据库DBID

小编给大家分享一下如何更改数据库DBID，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！
更改数据库DBID当克隆一个数据库到另外一台机器上，具有相同的数据库名称或者如果一个新的数据库名称是通过重建的控制文件，
那么需要改变DBBID，特别是如果是新的数据库在相同的rm免费主机域名an catalog是注册。
尤其是如果使用rman catalog，rman catalog中只允许注册一个DBID,相同DBID不能注册在同一catalog当中，下面演示改变DBID：
1、关闭数据库，启动到mount状态
SYS@jzh>shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@jzh>startup mount
ORACLE instanc免费主机域名e started.
Total System Global Area 626327552 bytes
Fixed Size 2230952 bytes
Variable Size 444597592 bytes
Database Buffers 176160768 bytes
Redo Buffers 3338240 bytes
Database mounted.
2、确认sys用户可以连接
[oracle@jzh6 ~]$ sqlplus sys/oracle@jzh as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 13 08:43:52 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
3、更改DBID
[oracle@jzh6 ~]$ cd $ORACLE_HOME/bin
[oracle@jzh6 bin]$ ./nid target=sys/oracle@jzh
DBNEWID: Release 11.2.0.3.0 – Production on Sun Sep 13 08:45:08 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to database JZH (DBID=233255254)—-当前数据库DBID
Connected to server version 11.2.0
Control Files in database:
/u01/app/oracle/oradata/jzh/control01.ctl
/u01/app/oracle/fast_recovery_area/jzh/control02.ctl
Change database ID of database JZH? (Y/[N]) =>y—-是否更改DBID，输入Y
Proceeding with operation
Changing database ID from 233255254 to 249044244 —–DBID从233255254更改为249044244
Control File /u01/app/oracle/oradata/jzh/control01.ctl – modified
Control File /u01/app/oracle/fast_recovery_area/jzh/control02.ctl – modified
Datafile /u01/app/oracle/oradata/jzh/system01.db – dbid changed
Datafile /u01/app/oracle/oradata/jzh/sysaux01.db – dbid changed
Datafile /u01/app/oracle/oradata/jzh/undotbs01.db – dbid changed
Datafile /u01/app/oracle/oradata/jzh/users01.db – dbid changed
Datafile /u01/app/oracle/oradata/jzh/test01.db – dbid changed
Datafile /u01/app/oracle/oradata/jzh/temp01.db – dbid changed
Control File /u01/app/oracle/oradata/jzh/control01.ctl – dbid changed
Control File /u01/app/oracle/fast_recovery_area/jzh/control02.ctl – dbid changed
Instance shut down
Database ID for database JZH changed to 249044244.
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.—-数据库被shutdown,以resetlogs打开。
Succesfully changed database ID.
DBNEWID – Completed succesfully.
4、打开数据库
SYS@jzh>startup mount
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2230952 bytes
Variable Size 444597592 bytes
Database Buffers 176160768 bytes
Redo Buffers 3338240 bytes
Database mounted.
SYS@jzh>alter database open resetlogs;
Database altered.
5、检查新的DBID
[oracle@jzh6 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 – Production on Sun Sep 13 08:50:45 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: JZH (DBID=249044244)—-新的DBID
由于更改DBID会导致以前的备份失效，因此在更改DBID时还需要慎重考虑。
以上是“如何更改数据库DBID”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注云技术行业资讯频道！

相关推荐: 有关Mysql面试题有哪些

本篇内容主要讲解“有关Mysql面试题有哪些”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“有关Mysql面试题有哪些”吧!1. 数据库的三范式是什么？第一范式：强调的是列的原子性，即数据库表的每一列都是不可分割的原…