Re: Error : Can not allocate log, archival required
From: <rspeaker_at_my-dejanews.com>
Date: 1999/01/29
Message-ID: <78st1u$t7h$1_at_nnrp1.dejanews.com>#1/1
> I have Oracle 8.05 on a WinNT machine.
> The following error occured while the tables for the Designer 1.3.2
> repository were being created:
> "Error during ORACLE redo log archival:Can not allocate log, archival
> required"
> The server crashed and when I tried again when I restarted it, the
> repository installation procedure went a little further and then it threw
> the same error message.
> I changed the redo log files size from 1M to 3M but it did't help.
> Any ideas?
> Please mail to me.
> Thanks in advance
>
> ----------------------------
> Vagelis S. Hristidis
> Electrical and Computer Engineering
> National Technical University of Athens
> e-mail:exrist_at_cc.ece.ntua.gr
> URL:http://www.cc.ece.ntua.gr/~exrist
>
>
Date: 1999/01/29
Message-ID: <78st1u$t7h$1_at_nnrp1.dejanews.com>#1/1
it sounds as if you have your database in archivelog mode, but have not enabled automatic archiving in the init<SID>.ora file. Your online redo logs have all been filled and marked for archival but the ARCH process is not running to perform the archive. Try issuing an alter system archive log all; command.
HTH,
Roy
In article <78sje5$8l0$1_at_ulysses.noc.ntua.gr>, "vagelis Hristidis" <exrist_at_cc.ece.ntua.gr> wrote:
> I have Oracle 8.05 on a WinNT machine.
> The following error occured while the tables for the Designer 1.3.2
> repository were being created:
> "Error during ORACLE redo log archival:Can not allocate log, archival
> required"
> The server crashed and when I tried again when I restarted it, the
> repository installation procedure went a little further and then it threw
> the same error message.
> I changed the redo log files size from 1M to 3M but it did't help.
> Any ideas?
> Please mail to me.
> Thanks in advance
>
> ----------------------------
> Vagelis S. Hristidis
> Electrical and Computer Engineering
> National Technical University of Athens
> e-mail:exrist_at_cc.ece.ntua.gr
> URL:http://www.cc.ece.ntua.gr/~exrist
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 29 1999 - 00:00:00 CET