Re: Logs full

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 16 Jun 2004 19:05:50 +1000
Message-ID: <40d00d55$0$6201$afc38c87@news.optusnet.com.au>

"DB2 Convert" <db2convert_at_yahoo.com> wrote in message news:15fb8792.0406160047.3ced173a_at_posting.google.com...
> Hi,
>
> When my redo logs are full and I am running NO Archive Log mode,
> will the whole thing just hang?
>
> Thanks.
>
> DB2 Convert

Nope. The logs just recycle, and hence the redo generated by earlier transactions is over-written by later ones. That actually happens whether you're in archivelog mode or not... the only difference is, do we take a backup of the log before recycling it or not?

If you *were* in archivelog mode, then your system can actually hang! If you've said 'take a backup before recycling' (which is what archivelog mode means), but you don't actually switch on the ARCH background process to do the actual backing up, then the system hangs, waiting for the backup to take place.

But in noarchivelog mode, then no hang happens.

Regards
HJR Received on Wed Jun 16 2004 - 04:05:50 CDT