1 minutes readHow to Change DBID and DBNAME?

How to change DBID?

STEP 1 Shutdown the database

STEP 2 Start database but not open.

STEP 3 execute following command on command prompt.

CMD>nid target=sys/password

STEP 4 Startup database with resetlogs option.

Important:

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.

How to change DBNAME?

STEP 1 SQL> select dbid, name from v$database; (Note Down Output)

STEP 2 SQL> shutdown imemdiate;
             SQL> startup mount;

STEP 3 SQL> host nid target=sys/Passworda DBNAME=INDIAN (New DB Name) setname=Y

STEP 4 SQL> !export ORACLE_SID=INDIAN
             SQL> conn / as sysdba
             Connected to an idle instance.
             SQL> startup nomount
             SQL> show parameter db_name
             SQL> alter system set db_name=INDIAN scope=spfile;
             SQL> shutdown immediate;
             SQL> startup
             SQL> select name,dbid from v$database;

Modify parameter file and generate a new password file before restarting