| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: O/S copies of datafiles
Just be sure that if you copy your listener.ora file from the first box you change the hostname! Otherwise you'll risk shutting down the listener on the original box.
-----Original Message-----
Sent: Thursday, August 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Yes, what this is doing is the same as restoring from a cold backup. If the machines are the same, you can just shutdown Oracle and copy data files, control files, redo logs and the contents $ORACLE_HOME across to an identical directory structure on a new machine, change any settings like tnsnames.ora and listener.ora which might be machine specific, then start the database on the new machine and you're all set. If the version of Oracle is only a minor revision, then datafiles, control files et al will be compatible, just move everything except the software.
We use a similar technique with Sun Jumpstart to create new instances for our developers.
g
-----Original Message-----
Sent: Thursday, August 09, 2001 3:06 AM
To: Multiple recipients of list ORACLE-L
Hi,
This might be a stupid question, but I'll give it a go anyway.
I have two Unix boxes - a production and a newly created test box. The production box has 8.0.5 and the test has 8.0.6 installed.
Is it possible to stop the database, take a backup of all the datafiles
(through the operating system) and then move them to the test server (in
the
same directory structure they were in in the production box). Would the
database open successfully?
Thanks in advance for all your help.
Regards,
Sujatha
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sujatha Madan
INET: sujatha.madan_at_cmc.cwo.net.au
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).
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).
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).
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 Aug 09 2001 - 15:09:48 CDT
 |
 |