Re: lost of redo logs

Loss of current redo log... incomplete recovery.

Loss of active log... depends. It's active because either it hasn't been archived or because the checkpoint hasn't completed. If it was lost before the archive was produced, that wouldn't necessarily imply any recovery was required at all... your database is perfectly fine, give or take a redo log. You'd of course have a gap in your archive sequence, and so it would be prudent to take a new backup. But there's no law that says the loss of an inactive is guaranteed to crash your database... and therefore, no rule that says any recovery at all is needed.

Loss of inactive... well, you could do a 'clear' if you wanted to. Can't really see why you wouldn't just drop the group and create it fresh (actually, you'd do it the other way round, of course!). But you're right. No recovery required.

Scenario 4 dealt with above.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"godmann" <allanwtham_at_yahoo.com> wrote in message
news:95cd51c.0202281826.26770596_at_posting.google.com...


> Hi there,

>

>   I just need to confirm the following.

>

>

>    Scenarios                              Recovery

>    ----------                             --------

>   1. Lost of current redo log group -   Incomplete

>   2. Lost of active redo log group -    Incomplete

>   3. Lost of inactive redo log group -  clear logfile group

>   4. Lost of unarchived redo log group - Incomplete

>

>   Maybe Howard can shed some lights on this!

>

> Allan W. Tham

> Oracle DBA