Hi Saroj,
If your cold backup of the database is good (i.e. tapes are readable) and
the test server has the right oracle version, the steps you outlined in your
e-mail should get the db running on the test server. You will probably need
to setup the oratab file in /etc (or /opt) directory, if auto startup of
database after machine reboot is desired. You will also need the init.ora
file in the proper directory. The 'startup' command from your 4th step will
expect the init.ora file in the $ORACLE_HOME/dbs directory. Other than that
it should work just fine.
Good Luck..
- Kirti Deshpande
> -----Original Message-----
> From: Dash, Saroj (CAP,CEF) [SMTP:Saroj.Dash_at_gecapital.com]
> Sent: Friday, January 05, 2001 3:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Data Move from production to Test server
>
>
> 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).
Received on Fri Jan 05 2001 - 07:19:20 CST
