SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> !
[oracle@pk ~]$ nid TARGET=system DBNAME=prod1 SETNAME=Y
DBNEWID: Release 10.2.0.1.0 - Production on Sat Aug 17 18:43:12 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Password:
Connected to database DEV1 (DBID=3432497468)
Connected to server version 10.2.0
Control Files in database:
/home/oracle/oracle/product/10.2.0/oradata/dev1/control01.ctl
/home/oracle/oracle/product/10.2.0/oradata/dev1/control02.ctl
/home/oracle/oracle/product/10.2.0/oradata/dev1/control03.ctl
Change database name of database DEV1 to PROD1? (Y/[N]) => Y
Proceeding with operation
Changing database name from DEV1 to PROD1
Control File /home/oracle/oracle/product/10.2.0/oradata/dev1/control01.ctl - modified
Control File /home/oracle/oracle/product/10.2.0/oradata/dev1/control02.ctl - modified
Control File /home/oracle/oracle/product/10.2.0/oradata/dev1/control03.ctl - modified
Datafile /home/oracle/oracle/product/10.2.0/oradata/dev1/system01.dbf - wrote new name
Datafile /home/oracle/oracle/product/10.2.0/oradata/dev1/undotbs01.dbf - wrote new name
Datafile /home/oracle/oracle/product/10.2.0/oradata/dev1/sysaux01.dbf - wrote new name
Datafile /home/oracle/oracle/product/10.2.0/oradata/dev1/users01.dbf - wrote new name
Datafile /home/oracle/oracle/product/10.2.0/oradata/dev1/example01.dbf - wrote new name
Datafile /home/oracle/oracle/product/10.2.0/oradata/dev1/temp01.dbf - wrote new name
Control File /home/oracle/oracle/product/10.2.0/oradata/dev1/control01.ctl - wrote new name
Control File /home/oracle/oracle/product/10.2.0/oradata/dev1/control02.ctl - wrote new name
Control File /home/oracle/oracle/product/10.2.0/oradata/dev1/control03.ctl - wrote new name
Instance shut down
Database name changed to PROD1.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.
This utility won’t change the database name in pfile, so change the database name (DB_NAME) in pfile manually and create password file (if necessary).
Mount the database
SQL> STARTUP MOUNT
Open the database in RESETLOGS mode and resume normal use
SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> select dbid, name from v$database;
Make a new database backup. Because you had reset the online redo logs, the old backups and archived logs are no longer usable in the current incarnation of the database.
