Re: Data Move from production to Test server

Just a bit more to check:

make sure that the OS on the test system is the same as the one the production server was -- this includes all OS patches.

Do the same for Oracle as well.

I have always "cloned" databases to new servers this way:

1. ensure the OS is the same level as the one I am cloning
2. copy all Oracle binary directories
3. shutdown the database I want to copy (in Saroj's case this is, unfortunately, not necessary)
4. copy all the relevant database files -- init.ora, tnsnames. ora, config.ora, redo logs, controlfiles, datafiles, anything else I can think of files

startup the database.

This is on Unix only, I've never done this on NT. I've never had a problem either. This method was actually suggested to me by Oracle Support. It's a quick and not-so-dirty way to install Oracle as well

Rachel

>From: sfaroult_at_oriole.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Data Move from production to Test server
>Date: Fri, 05 Jan 2001 02:25:29 -0800
>
>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 !
>
>This mail was sent from host 194.3.142.126
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: sfaroult_at_oriole.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).