Oracle 10g/11g:Change DBID and Name of Database by DBNEWID Utility
Use of DBNEWID Utility. 1.Shut Down the Database.Take Cold Backup of All Datafiles,Control Files and Log files. 2.Start Database in Mount Mode.Check Current DBID. SQL>SQLPLUS /NOLOG SQL>CONN / AS SYSDBA CONNECTED. SQL>STARTUP MOUNT SQL> select dbid from v$database; DBID ---------- 13350**** 3.Execute this Command. SQL> host nid target=sys/blogdb dbname=NEWBLOG DBNEWID: Release 11.1.0.6.0 - Production on Tue Jun 5 11:32:23 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to database BLOGDB (DBID=1335025255) Connected to server version 11.1.0 Control Files in database: E:\APP\ADMINISTRATOR\ORADATA\BLOGDB\CONTROL01.CTL E:\APP\ADMINISTRATOR\ORADATA\BLOGDB\CONTROL02.CTL E:\APP\ADMINISTRATOR\ORADATA\BLOGDB\CONTROL03.CTL Change database ID and database name BLOGDB to NEWBLOG? (Y/[N]) => Y Proceeding...