Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Tell me the Recover Method !!!
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
![]() |
![]() |