If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Changing DB and Instance name

Dear all,
I need to change a database and instance name of a database name.
Except the init.ora and tnsnames.ora and listener.ora.
What more shall have be done to have 2 different machines hosting identical databases for statnd by purposes. The problem is that the databases has been installed with different names.

If you have 2 servers then there is no need to change DB or SID name.
Copy you backup to standby server ,create standby controlfile ,etc.
Another words follow all steps necessary to create standy database .

One, who thinks that the other one who thinks that know and does not know, does not know either!

If you are intend make your life easier for standby failover with same instance names for primary and secondary follow BV1963 steps.

Take hot backup of primary and copy it to standby location with standby controlfile and standby init.ora and bring up the instance. Lot simpler.. If you think its time consuming task based on the size of the database network transfer time for your backup copies, backup controlfile to traqce and change instance name by editing controlfile. Follow the instructions carefully for both tasks.

Standby server seems to have some difficulties like that the stndby database is not possible to mount complaining about that db name is not mtching the db name in the init.ora in the standby databse. Viewing the controlfile generated from primary database by strings commend shows that the database name and other directory name are diffrerent from the init.ora file.
Do we have to edit control file in some way to fix the names to match the init file and how.
or just put the standby control file generated in the primary database and put into work in the standby database that does not work at this time

Re: Changing DB and Instance name

Originally posted by hamhey Dear all,
I need to change a database and instance name of a database name.
Except the init.ora and tnsnames.ora and listener.ora.
What more shall have be done to have 2 different machines hosting identical databases for statnd by purposes. The problem is that the databases has been installed with different names.

Copy init file from primary server to the standby server and if necessary change name and location for control file(s)
Transfer full backup (cold or hot) to the standby server and place file into the same folders where they come from
Generate standby controlfile on primary site and put it on standby server as per init.ora file
Set oracle sid to the same value as primary ,
go to svrmgrl or sqlplus and :
startup nomount;
alter database mount stadby database.

Please post exact error that occur.

One, who thinks that the other one who thinks that know and does not know, does not know either!