Can I Restore hot backups with no archive logs???Yes...Offcourse...You have to perform an incomplete recovery for that..using until time option.

Joe
----- Original Message -----
From: Scarpelli, Debra
To: LazyDBA.com Discussion
Sent: Friday, May 30, 2003 6:07 PM
Subject: Can I Restore hot backups with no archive logs???


Hello all!
I have to restore a hot backup from last month to a test environment and have no archive logs.
Is there any way to restore from hot backup WITHOUT archive logs?

I'm using Oracle 9irel2, but compatibility is set to 8.1.7.

It's okay if I restore to a time before the backup was taken, but I think I still need at least one archive log to restore?

My alternative is to use the export file, and it will take DAYS to import all the data.
Your help will be greatly appreciated!





This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.

Oracle LazyDBA home page