Hi Lorne,
First let me say one caveat....
I'm not an Oracle backup expert...
You migth want to post to contact Oracle if you have a support agreement. There migth be something else you can do.
Here's what I think happened...
Did you restore a control file? If you did you should try to restore only the
data files (hence the non existant archive log file..)
Easier is if you have a nigthly export file in addition to standard backup? I find the export files easier to work with
then a full backup for partial restores...
You should be able to do a complete or cancel based recovery..
You need..
-dbf files from yesterday
-control file from today is ok or backup controlfile taken using "alter
database backup controlfile command"
-All archived logfiles ( not redologs ) since your yesterdays dbf file
backup
If you meet this requirement,
you can go for either complete recovery (only your current control & redologs are intact ) or cancel based recover ( If U lost your current controlfile and redo log groups ) or timebased recovery....I haven't got time to explain
all in detail but they are covered in the manual..
Hope that helps..
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only