Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: lost of redo logs

Re: lost of redo logs

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 6 Mar 2002 06:41:10 +1100
Message-ID: <a63717$cqk$1@lust.ihug.co.nz>


Let us know! (You've only 10 more minutes to wait!!)

Regards
HJR

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


"Jeff" <jeff_at_work.com> wrote in message
news:a62h5v$llm$1_at_cronkite.cc.uga.edu...

> In article <a60blh$v2k$1_at_lust.ihug.co.nz>, "Howard J. Rogers"
<dba_at_hjrdba.com> wrote:
> >Just as a more-precise follow-up. I realise what follows is not the most
> >exciting spool file ever produced, but it illustrates that it takes about
> >half an hour for the automatic status change to come about:
>
> It must take a lot longer here. On one database, the last archive log
file is
> timestamped at approximately 5am. The corresponding redolog is indeed
> inactive. On another database, the last timestamp is ~6:30am, but the
redolog
> is still active. It's 8:20am now. Perhaps the magic number here is 2
hours?
Received on Tue Mar 05 2002 - 13:41:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US