Home » RDBMS Server » Backup & Recovery » Recovering a DB with different name (Windows,10.2.0.3)
Recovering a DB with different name [message #468837] Mon, 02 August 2010 05:11 Go to next message
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 #468854 is a reply to message #468837] Mon, 02 August 2010 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to use DBNEWID utility.

But you can have several databases with same name on the server, it is the instance name that must be different.

Regards
Michel
Re: Recovering a DB with different name [message #468991 is a reply to message #468854] Mon, 02 August 2010 21:37 Go to previous messageGo to next message
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 #469042 is a reply to message #468991] Tue, 03 August 2010 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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.

Are you sure of that on Windows?

Regards
Michel
Re: Recovering a DB with different name [message #469076 is a reply to message #469042] Tue, 03 August 2010 03:27 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
DB_UNIQUE_NAME in 10g and above replaces LOCK_NAME_SPACE in 9i.

See MOS Note#736863.1 or #467525.1 for examples of using DB_UNIQUE_NAME to allow two databases (primary and standby) on the same server.

Hemant K Chitale

[Updated on: Tue, 03 August 2010 03:28]

Report message to a moderator

Re: Recovering a DB with different name [message #469077 is a reply to message #469042] Tue, 03 August 2010 03:31 Go to previous messageGo to next message
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
Re: Recovering a DB with different name [message #469078 is a reply to message #469076] Tue, 03 August 2010 03:35 Go to previous message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the notes.

Regards
Michel
Previous Topic: Recovery of Deleted datafile
Next Topic: RMAN-06555: datafile 11 must be restored from backup created before
Goto Forum:
  


Current Time: Mon Sep 01 19:44:40 CDT 2014

Total time taken to generate the page: 0.19972 seconds