| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Ok two databases..two machines..one database name
I have been tasked with moving a production database to a 'backup' machine. I ran my plan past you a week or so ago. Essentially I will put the DB in backup mode, copy the datafiles, shutdown, copy redo and control files, then recover on the second machine. So far plain vanilla. I understand the above procedure enough to have actually thought of it.
My problem now is this. I need to test this instance on the 'backup' machine before we actually do the move. This is Just to make sure the application is completely in order. One of the developers is telling me that having the two databases up and running with the same SID, even on separate machines MAY cause trouble for the production instance. I believe that if I make sure the tnsnames.ora file for both servers points to their own local instances, that I will not have a problem. The clients will only access the database pointed to in their tnsnames files, so I am confident we are ok there. My question is can I have databases with the same name running simultaneously on two different machines if I make sure the tnsnames for each database points to it's own server? The database is 7.3.4. As soon as I send this off I am going to create a small DB just to test this out, but your input, as usual, is appreciated.
Thanks,
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: steve_at_pactr.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 24 2001 - 18:57:27 CDT
 |
 |