Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: O/S copies of datafiles

RE: O/S copies of datafiles

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Thu, 09 Aug 2001 13:09:48 -0700
Message-ID: <F001.0036639C.20010809132116@fatcity.com>

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
  INET: guy.hammond_at_avt.co.uk
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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Smith, Ron L.
  INET: rlsmith_at_kmg.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.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 Aug 09 2001 - 15:09:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US