Re: Error message:Archival required?

David,
Common problem.
There are 2 aspects to enabling archiving. I don't have a db here so I can't remember the exact syntax but ..
If the database is in archivelog mode (alter database archivelog) it knows it needs to archive the logfiles.
The second part of the puzzle is to enable automatic archiving. This is done via the init.ora. Off the top of my head I think it is something like archive_log_start=true
It will probably be in your init.ora
You also need to specify a destination.

To get going for now, issue the command archive log start;
in svrmgr

In summary.
If auto archiving is not enabled, it will fill the available log files but cannot loop back to the first one again as it hasn't been archived.

David Schwartz wrote in message <36A6056B.A3B204DB_at_elucidate.com>...
>I'm using Oracle 8.0.4 for NT. I have it in archive log mode, but this
>occurs even if I turn it off:
> After executing a few statements, or sometimes just when it is
>starting up, the database gives me the following message in a
>command-prompt window:
> Unable to allocate log: archival required.
>Then it hangs.
>
>What does this mean? What am I supposed to do?
> Thanks so much for your help.
>
> David
>
Received on Wed Jan 20 1999 - 14:29:17 CST