Re: Error message:Archival required?

My apoligies to Sara for correcting her. After re-looking into this problem, My solution might not be right.

Regards,
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

In article <785ebc$hdi$1_at_plug.news.pipex.net>,   "Sara Berks" <sara.berks_at_dial.pipex.com> wrote:
> 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
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 19:03:06 CST