OraFAQ Forum: Enterprise Manager » Linking a new database with some existing datafiles

Home » RDBMS Server » Enterprise Manager » Linking a new database with some existing datafiles (Windows 2003 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Linking a new database with some existing datafiles [message #329778]

Thu, 26 June 2008 08:48

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,

Report message to a moderator

Re: Linking a new database with some existing datafiles [message #329779 is a reply to message #329778]

Thu, 26 June 2008 08:57

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)!

Report message to a moderator

Re: Linking a new database with some existing datafiles [message #329780 is a reply to message #329779]

Thu, 26 June 2008 09:03

urian
Messages: 7
Registered: January 2008
Location: Albania

Junior Member

operating system: windows server 2003
oracle 9i enterprise edition

Report message to a moderator

Re: Linking a new database with some existing datafiles [message #329781 is a reply to message #329780]

Thu, 26 June 2008 09:08

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

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

Report message to a moderator

Re: Linking a new database with some existing datafiles [message #329786 is a reply to message #329783]

Thu, 26 June 2008 09:32

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

Report message to a moderator

Re: Linking a new database with some existing datafiles [message #329791 is a reply to message #329778]

Thu, 26 June 2008 09:51

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.

Report message to a moderator

Re: Linking a new database with some existing datafiles [message #329794 is a reply to message #329778]

Thu, 26 June 2008 09:58

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?

Report message to a moderator

Previous Topic:	OEM guidance
Next Topic:	Agent Configuration Assistant - OUI 25031

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:06:33 CST 2024