Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: lost of redo logs
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...Received on Tue Mar 05 2002 - 13:41:10 CST
> 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?