Re: Can not allocate log, archival required

Sounds like you are in archivelog mode, but don't have the ARCH process started. You need to have log_archive_start = true in your init.ora.

You can issue a command to archive your logs. Without referring to my book (admin guide) I can't remember what it is off the top of my head. That should take care of it tho.

In article <377DE3AC.14D7_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> 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."
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 03 1999 - 21:53:42 CDT