Re: Error: Oracle Redo Log Archival

That kind of error is usually reported when Oracle does not have any more space on disk to archive redo log files, so you have to delete old archive log files (my recommendation is to archive them somewhere) to make more space for new ones. The space needed to store one archive log file equals the size of the redo log file. All this applies if your instance is running in ARCHIVE LOG mode.

In article <369fcc60.0_at_news.hkc.net>, thomast_at_hkc.net says...
> 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?
>
> Please help, thank you.
>
>
> Thomas Tsang
>
>
>
>
> begin 666 testALRT.LOG
> M1'5M<"!F:6QE($0Z7&]R86YT7')D8FUS.#!<=')A8V5<=&5S=$%,4E0N3$]'
> M#0I&<FD_at_2F%N(#$U(#$U.C Y.C0S(#$Y.3D-"D]204-,12!6."XP+C0N,"XP
> M("T_at_4')O9'5C=&EO;B!V<VYS=&$], T*=G-N<W%L/6,@=G-N>'1R/3,-"E=I
> M;F1O=W,@3E0_at_5C0N,"P_at_3U,@5C4N,3 Q+"!#4%4@='EP92 U.#8-"D9R:2!*
> M86X@,34@,34Z,#DZ-#,@,3DY.0T*5&AR96%D(#$@8V%N;F]T(&%L;&]C871E
> M(&YE=R!L;V<L('-E<75E;F-E(#4W,PT*06QL(&]N;&EN92!L;V=S(&YE961E
> M9"!A<F-H:79I;F<-"B @0W5R<F5N="!L;V<C(#(@<V5Q(R U-S(@;65M(R P
> B.B!$.EQ/4D%.5%Q$051!0D%315Q,3T=415-4,BY/4D$-"@``
> `
> end
>
>

--

Mate Skoblar
Oracle DBA
Croatian National Bank
+385 1 4564765 Received on Fri Jan 15 1999 - 13:56:53 CST