Re: Logs full

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Sat, 19 Jun 2004 05:00:05 GMT
Message-ID: <pLPAc.38455$sj4.23287@news-server.bigpond.net.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

The short answer is no. The oldest redo log file will be overwritten.

See p.7-3 of the "Oracle 10G Database Administrator's Guide".

Douglas Hawthorne Received on Sat Jun 19 2004 - 00:00:05 CDT