Re: Can not allocate log, archival required

I'd hazard a guess that your database is in archivelog mode (meaning "Do not overwrite one of the online redo logs until it has been copied"), but for some reason ARCH has either not been switched on or has hung (ARCH's job is to actually take the copy that noarchivelog demands *be* taken).

Try an alter system archive log start; and see what that gets you.

Alternatively, try an alter system archive log all;

And if either of those works, check your init.ora and make sure you have a line in there that reads LOG_ARCHIVE_START=TRUE (which will then ensure ARCH is switched on every time you bounce your Instance).

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Christoph Kukulies" <kuku_at_gil.physik.rwth-aachen.de> wrote in message
news:9r5qde$b62$1_at_nets3.rz.RWTH-Aachen.DE...


> oracle80.exe is coming up with a DOS text window:

> ----------------------------------------------------------------

> |ORACLE instance test - Can not allocate log, archival required|

> |                                                              |

> |          press <ENTER> to acknowledge message.               |

> |                                                              |

> ----------------------------------------------------------------

>


> Any clues what the cause of this can be?

>


> --

> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de