RE: O/S copies of datafiles

From: Rao, UmaSankara S (CAP) <UmaSankara.Rao_at_Gecis.GE.com>
Date: Thu, 09 Aug 2001 00:30:43 -0700
Message-ID: <F001.00365760.20010809003555@fatcity.com>

Hi,

What is the size of the database?If it is less than 4 or 5 GB better go for exp/imp.

There are various factors, first of all can u afford to shutdown the prod instance if so how long?

yes it is possible to copy the datafiles at OS level and up the DB on test machine.

Regds,
Uma

-----Original Message-----
Sent: Wednesday, August 08, 2001 9:06 PM 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: Rao, UmaSankara S (CAP)
  INET: UmaSankara.Rao_at_Gecis.GE.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 - 02:30:43 CDT