Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Tell me the Recover Method !!!

Tell me the Recover Method !!!

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Thu, 21 Dec 2000 17:13:35 +0900
Message-Id: <10717.125086@fatcity.com>


Hello Gurus,

  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 .

                      I want to see all the production data in Test server.

Production server and test server OS are same i.e Sun solaris. Orcale Version is :8.0.5
If i will do all the Step below can I see all the data which was in production server.  

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. Received on Thu Dec 21 2000 - 02:13:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US