Re: Archival

John Phan wrote:
>
> Hello,
> I've got problem with log archival when importing data. The following error
> message occured:
> "Warning-The following error occured during Oracle redo log archival:
> Oracle Instance dev-Can not allocate log, archival requried
> Press ?ENTER? to acknowledge message."
>
> Any idea what I could do to avoid that error message?
>

John,

Connect internal and execute this command:

SVRMGR> archive log list;

I'll bet that you don't have automatic archiving set. try this:

SVRMGR> alter system archive log current;

that should free things up for a little while.

What you want to do is set automatic archival on

SVRMGR> archive log start;

and set the log_archive_start paratemer to true in the init.ora file. Received on Mon Oct 16 2000 - 01:46:33 CDT