Re: Error message:Archival required?

Hi,

you need 3 init.ora parameters for automatical archiving:

log_archive_dest        = /oracle7/archive/arch_bt00_
log_archive_format      = %s.arc
log_archive_start       = true

where log_archive_dest must include the first letters of the archived files. Here they will be

/oracle7/archive/arch_bt00_1.arc
/oracle7/archive/arch_bt00_2.arc
/oracle7/archive/arch_bt00_3.arc

But: This files will be in OS-Filesystem and you must write them to tape or your filesystem will be full in a few time.

Torsten

David Schwartz wrote:
>
> 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 Thu Jan 21 1999 - 01:57:01 CST