Home » RDBMS Server » Enterprise Manager » Linking a new database with some existing datafiles (Windows 2003 server)
Linking a new database with some existing datafiles [message #329778] Thu, 26 June 2008 08:48 Go to next message
urian
Messages: 7
Registered: January 2008
Location: Albania
Junior Member

Hi guys,


I have two servers with 2 databases that connect to the same datafiles (the datafiles, controlfiles and redolog files are on shared driversn and are the same for both databases). one is primar and the other is secondar, they reflect each other changes.

The problem is that I need to remove one of this servers and replace it with an other, I have created an identic database in the other server,as in the server I have to remove, now I need to connect it with the shared datafiles.

WHAT CAN I DO????

is enaugh if I change the path of the controlfiles ine the new server to that in the old server?

Thank you in advance,
Re: Linking a new database with some existing datafiles [message #329779 is a reply to message #329778] Thu, 26 June 2008 08:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guideline as stated in URL above

Here is what we know.

You think you have a problem.

Here is what we do not know:
Operating System name
Operating System version
Oracle version to 4 decimal places

You're On Your Own (YOYO)!
Re: Linking a new database with some existing datafiles [message #329780 is a reply to message #329779] Thu, 26 June 2008 09:03 Go to previous messageGo to next message
urian
Messages: 7
Registered: January 2008
Location: Albania
Junior Member

operating system: windows server 2003
oracle 9i enterprise edition
Re: Linking a new database with some existing datafiles [message #329781 is a reply to message #329780] Thu, 26 June 2008 09:08 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
Do you mean you have a 2 node RAC

regards

Alan

[Updated on: Thu, 17 July 2008 11:15] by Moderator

Report message to a moderator

Re: Linking a new database with some existing datafiles [message #329783 is a reply to message #329778] Thu, 26 June 2008 09:12 Go to previous messageGo to next message
urian
Messages: 7
Registered: January 2008
Location: Albania
Junior Member

its not a 2 node rac, its just a device (matrix device) that make possible that the 2 servers have some local drivers and some shared drivers that are the same for both servers. the databases use multiple listeners for not getting mixed up with each other
Re: Linking a new database with some existing datafiles [message #329786 is a reply to message #329783] Thu, 26 June 2008 09:32 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
I have not come across this kind of configuration in the past so am not able to add much, sorry.

regards

Alan
Re: Linking a new database with some existing datafiles [message #329791 is a reply to message #329778] Thu, 26 June 2008 09:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have two servers
>The problem is that I need to remove one of this servers and replace it with an other
>is enaugh if I change the path of the controlfiles ine the new server to that in the old server?

This? Other? new? old?

How many physical, different servers?

With regard to "other", is not this server the other server from an ego centric persprective?

It is too bad for all concerned that your servers don't have names.
Re: Linking a new database with some existing datafiles [message #329794 is a reply to message #329778] Thu, 26 June 2008 09:58 Go to previous message
urian
Messages: 7
Registered: January 2008
Location: Albania
Junior Member

ok I have 3 servers serve 1, 2 and 3. They have 2 local drivers and 5 shared drivers that are the same for the 3 servers. server 1 and 2 have two diferent databases with the same datafiles and controlfiles that are placed one the shared drivers. I want to eleminate server 1 and replaced it with server 3.
I have installed an identic oracle database as server 1 now I need to use the shared (datafiles and controlfiles).

What can I do?
Previous Topic: OEM guidance
Next Topic: Agent Configuration Assistant - OUI 25031
Goto Forum:
  


Current Time: Fri Mar 29 02:24:15 CDT 2024