Re: Can not allocate log, archival required

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 03 Jul 1999 18:19:24 +0800
Message-ID: <377DE3AC.14D7@yahoo.com>

grahams wrote:
>
> I am trying to open the Enterprise Manager for the first
> time. There is an error message:
> " ORACLE instance orc1 - Can not allocate log, archival
> required " .
> I am using Oracle 8.05 Enterprise Edition under NT 4.0 .
>
> I need help .
>
> Thanks.
>
> **** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****

Sounds like you have ARCHIVELOG mode set and not the automatic archival running...

Thus you have filled up your online redo logs and they have not been flushed out to archive logs and database has now stalled...

Fix your immediate problem by issuing 'archive log all' in server manager (or equivalent) and ensure that the archiver is turned on in your init.ora

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Jul 03 1999 - 05:19:24 CDT