Re: Data Move from production to Test server

Saroj,

   You have it right. As long as machines are the same and directory hierarchies are the same, it should work all right (assuming of course that you do not forget to set the proper ORACLE_SID in your environment).. The only things you have to be careful about are ancillary files, namely tnsnames.ora files on client machines - the tns alias will stay the same, but the HOST will be different. Which also means that yo must be certain that /etc/hosts files or their equivalent everywhere 'know' both your production and test machine, and that firewalls are suitably configured as well. Do not forget all the boring stuff which usually revolves around a production database - cron jobs, misc scripts, etc.

Trying it once will not be a loss of time ...

HTH, Stephane Faroult
Oriole Corporation

>Hello Gurus,
>
>Good Morning.
>
> In production server the OS is UNIX. Suppose UNIX OS has crashed. The
>database is in Noarchive log mode.
>We don`t have any file system backup.
> We kept all the datafiles, redo log files and control files are well
>backed up in a Tape.We don`t have export .dmp file.
> Only cold backs are fine .
>
> Question is : How can I get all the production data in Test machine.I
>don`t have export dmp file.
>
>Production server and test server OS are same i.e Sun solaris.
>Orcale Version is :8.0.4
>If i will do all the Step below can I see all the data which was in
>production server.if any othe steps please tell me.
>
>
>STEP 1 .If I deleted all the datafiles, redo log files and control files
>from test server and
>STEP 2: Create the directory structure in Test server same as Production
>database
>STEP3 : No need of re-creating the database script in test server
>STEP4 : Only copied all datafiles,redolog files and control files from tape
>to test server
>STEP4 : startup
>
> Can I get all the data in test server which was in production server .
>
>Please tell me what are the steps to be required in this situation.
>
>Regards,
>Saroj.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.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).
>
>

--
This mail was sent through http://www.mail-inspector.de
Mail Inspector is a free service of http://www.is-fun.net CHECK OUT !