Hi guys.
I want to link a new database with some old datafiles from another database. Can it be done with just changing the path of my new CONTROLFILE to the old one????
Full Version: Datafiles
no is not possible
I have two servers with 2 databases that connect to the same datafiles (the datafiles are on shared drivers). one is primar and the other is secondar, theyre 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!!!!!
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!!!!!
You could clone the database to the server you need them on.
Check out this tip from Don Burleson:
http://www.dba-oracle.com/oracle_tips_db_copy.htm
It is not possible for two databases to share the same physical datafiles.
Check out this tip from Don Burleson:
http://www.dba-oracle.com/oracle_tips_db_copy.htm
It is not possible for two databases to share the same physical datafiles.
QUOTE (Urian @ Jun 26 2008, 08:27 PM) 
I have two servers with 2 databases that connect to the same datafiles (the datafiles are on shared drivers). one is primar and the other is secondar, theyre 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!!!!!
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!!!!!
QUOTE (Urian @ Jun 26 2008, 01:27 PM)
I have two servers with 2 databases that connect to the same datafiles (the datafiles are on shared drivers). one is primar and the other is secondar, theyre 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!!!!!
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!!!!!
you really dont have two database connected to the same set of datafiles - not possible
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.