| Recovering a DB with different name [message #468837] |
Mon, 02 August 2010 05:11  |
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
|
Senior Member |
|
|
Hi,
I have a cold backup of a database named ABC,I want to restore it on a server but that server already has a database named ABC running in it.So I tried to rename the restorind database by changing the name in the create ccontrol file command but it says database name in the system datafile header doesnot match with the database name in the control file..What should I do?
|
|
|
|
|
|
| Re: Recovering a DB with different name [message #468991 is a reply to message #468854] |
Mon, 02 August 2010 21:37  |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
>But you can have several databases with same name on the server, it is the instance name that must be different.
Not from the same ORACLE_HOME, unless DB_UNIQUE_NAME is different for each database.
Two databases cannot have the same DB_NAME in one ORACLE_HOME. Instance startup uses a hash of the ORACLE_HOME and DB_NAME.
To separate two databases with the same DB_NAME, set different DB_UNIQUE_NAMEs --- that is how a Standby database on the same server is supported.
Hemant K Chitale
|
|
|
|
|
|
|
|
| Re: Recovering a DB with different name [message #469077 is a reply to message #469042] |
Tue, 03 August 2010 03:31 |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
Do you mean to say that, on Windows, you *can* have two databases with the same DB_NAME (not having set DB_UNIQUE_NAME) running from the same ORACLE_HOME ?
This is not possible on Unix/Linux.
Hemant K Chitale
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
