Oracle数据库的DBID变更

有的时候相同的DBID是有问题的，如：在同一台机器上做逻辑DG。<？XML:NAMESPACE PREFIX = O />修改的方式如下：关闭数据库SHUTDOWN IMMEDIATE启动数据库到mount的状态STARTUP MOUNT
使用nid 命令进行更改，如下：
[Oracle@dg2 ~]$ nid target=sys/password@LHZ
DBNEWID: Release 10.2.0.1.0 - Production on Mon Jan 16 09:18:00 2012
Copyright （c） 1982, 2005, Oracle. All rights reserved.
Connected to database LHZ （DBID=1330247278）
Connected to server version 10.2.0 Control Files in database: /u01/app/oracle/oradata/lhz/control01.ctl /u01/app/oracle/oradata/lhz/control02.ctl /u01/app/oracle/oradata/lhz/control03.ctl Change database ID of database LHZ？（Y/[N]） => Y Proceeding with operationChanging database ID from 1330247278 to 1342602440 Control File /u01/app/oracle/oradata/lhz/control01.ctl - modified Control File /u01/app/oracle/oradata/lhz/control02.ctl - modified Control File /u01/app/oracle/oradata/lhz/control03.ctl - modified Datafile /u01/app/oracle/oradata/lhz/system01.dbf - dbid changed Datafile /u01/app/oracle/oradata/lhz/undotbs01.dbf - dbid changed Datafile /u01/app/oracle/oradata/lhz/sysaux01.dbf - dbid changed Datafile /u01/app/oracle/oradata/lhz/users01.dbf - dbid changed Datafile /u01/app/oracle/oradata/lhz/example01.dbf - dbid changed Datafile /u01/app/oracle/oradata/lhz/temp01.dbf - dbid changed Control File /u01/app/oracle/oradata/lhz/control01.ctl - dbid changed Control File /u01/app/oracle/oradata/lhz/control02.ctl - dbid changed Control File /u01/app/oracle/oradata/lhz/control03.ctl - dbid changed Instance shut down Database ID for database LHZ changed to 1342602440.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 ID.DBNEWID - Completed succesfully.
运行完上述命令之后需要将数据库resetlogs 的方式打开。
[oracle@dg2 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 16 09:30:32 2012
Coyright （c） 1982, 2005, Oracle. All rights reserved.
SQL>conn /as sysdba
Connected.
SQL>alter database open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database openSQL> alter database open resetlogs;Database altered.
SQL> exit
SQL> select dbid,name from v$database;
DBID NAME---------- ---------1342602440 LHZ
SQL> CentOS 安装PostgreSQL 9.1Oracle 10g R2 数据库的克隆---物理拷贝克隆相关资讯 oracle数据库教程

Oracle raw数据类型介绍（01/29/2013 10:05:53）
监听器注册与ORA-12514 错误分析（11/13/2012 14:30:08）
Oracle SQL的cursor理解（11/13/2012 14:16:17）

Oracle 如何强制刷新Buffer Cache （01/29/2013 10:02:46）
dblink致Oracle库的SCN变成两库的（11/13/2012 14:24:41）
Linux操作系统下完全删除Oracle数（11/13/2012 08:25:52）

本文评论查看全部评论（0）