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
You must be aware of DBID and DBNAME before reading this post which explains how to change DBID and DBNAME. In this post different steps are given to change both terms. The steps described are easily understandable. I really like your post.
Post a Comment