Re: lost of redo logs

Jeff wrote:
>
> In article <a63717$cqk$1_at_lust.ihug.co.nz>, "Howard J. Rogers"
> <dba_at_hjrdba.com> wrote:
> > Let us know! (You've only 10 more minutes to wait!!)
>
> It's more than 2 hours. Maybe it's 3 hours... or, heck, maybe
> it's just random.

No, not random. You're likely just waiting for a checkpoint to complete. The log, even though it has been archived, contains information newer than the oldest (earliest) checkpoint_change# in v$database. That means the log, though archived, is still needed for instance recovery - i.e. it contains information not yet written to one or more datafiles.

Regards,
Sean Received on Tue Mar 12 2002 - 22:54:31 CST