Posts

Showing posts from June 5, 2012

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 with operation Changing database ID from 1335025255 to 3538211719 Changing d