I'd strongly suggest you take a copy of the Oracle Backup and Recovery
manual and read it. It also depends on which of your backups you want to use
to restore the database with. While the database can't be physically
restored using the imp/exp facilities, if this is the logical image of the
data you want to restore then the process is much different than if you use
a physical backup.

RF


Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.

 



-----Original Message-----
From: Bernita Joseph [mailto:[Email Address Removed] Thursday, October 31, 2002 11:12 AM
To: LazyDBA.com Discussion
Subject: oracle cold backup restore


HI Gurus,

Our working environment is Oracle 8.1.7 on windows NT. The database is on
nonarchive mode since it doesn't have to be up and running 24/7. The db
size is about 30Gb.

Now three days a week I shutdown the database and backup all
file in the orant8/oradata/ files. Also I do a full export everyday.

I want to test the restore in another machine. What are the things I need to
prepare before doing such test.
Basically I want someone to direct me on this as I never done something like
this before.

Thank you so much!


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page