Re: O/S copies of datafiles

Sujatha
        Yes, it will work assuming your production and test boxes are of the same OS, version etc. Technically, at least with the same endianness. You should take copy all the files including control files , init files, data files and redo log files to the test server. Then you could bring up the database. Since you are running 8.0.6 in the test server and the database you have restored is 8.0.5, you need to upgrade it from 8.0.5 to 8.0.6. I guess, you have to run upgrade script u0800050 to upgrade. Refer to the migration document for this upgrade.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com

Sujatha Madan <sujatha.madan_at_cmc.cwo.net.au> Sent by: root_at_fatcity.com
08/08/01 09:05 PM
Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:        
        Subject:        O/S copies of datafiles

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