Re: Error: Oracle Redo Log Archival

From: OraSaurus <granaman_at_not_home.com>
Date: Mon, 18 Jan 1999 03:20:44 GMT
Message-ID: <gMxo2.4598$xq4.1231@news.rdc1.ne.home.com>

In article <369fcc60.0_at_news.hkc.net>, "thomas" <thomast_at_hkc.net> wrote:
> I am using Oracle 8.0.4 for Windows NT (SP3), and there is a database
>named test. However, when I running some SQL statement using Oralce SQL
>Worksheet (either in server or client) , sometime the process will suddenly
>stop and the following error is shown:
>
>Warning - the following error occured during oracle redo log archival:
>Oracle Instance test - cannot allocate log, archival required
>
> The attached file is created after this error occur, anyone have ideas
>for this error?

Your alert log said: (BTW: you should just append it since its so small)

> Thread 1 cannot allocate new log, sequence 573
> All online logs needed archiving

It means exactly what it says. All the online redo log files need to be archived. Evidently, you have enabled archiving, but are not doing it automatically. Those telling you it has *ANYTHING* to do with disk space are ... well ... not very knowledgable.

OraSaurus --
Remove "not_" to reply... --

Received on Sun Jan 17 1999 - 21:20:44 CST