Re: recover after lost online redo-log

In article <01bd0ccb$74571380$fc7f3f8f_at_khome>, Kevin Brand <kbrand_at_gtetel.com> wrote:
>
>I understand this, however I am talking about loosing the actual device
>file for an ONLINE redo-log, where all the header info for that log is
>gone.

That is what mirrored online redo log files are for.

>
>-Kevin
>
>
>
>John P. Higgins <jh33378nospam_at_deere.com> wrote in article
><349AE730.2189_at_deere.com>...
>> That is not a trick, that's what hot backups are for. Just restore your
>> backup and all the logs since and recover until cancel. Reply cancel
>> when you have recovered the last log available.
>>
>> Kevin Brand wrote:
>> >
>> > Has anyone figured out a way to recover an instance after loosing an
 online
>> > redo-log? A cold backup will recover to some point in time before the
>> > loss. Is it possible to trick Oracle into letting me then restore a
 Hot
>> > backup and roll the logs forward up to the log that was lost?
>> >
>> > -Kevin Brand
>>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!