Change the DBID and the DBNAME
This document changes DBNAME AND DBID with NID utility method witch is available since Oracle 9.2 If you change the DBID you must open the database with the RESETLOGS option, which re-creates the online redo logs and resets their sequence to 1 . So your previous backups and archivelogs will be invalidated.. However with NID you can change DBNAME only, without below side effects with NID parameter SETNAME=Y, witch allow you change DBNAME without changing DBID... SQL> select dbid,name,open_mode,activation#,created from v$database; DBID NAME OPEN_MODE ACTIVATION# CREATED ---------- --------- -------------------- ----------- --------- 1423238009 ORCL READ WRITE 1423232377 11-NOV-15 We create a new pfile from spfile in order to modify it later... SQL> create pfile from spfile; File created. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Adva...