Re: Oracle Agent for backup Exec and archive log error

"Clemens Hoffmann" <choffmann_at_heeg.de> wrote in message news:<baknb7$6us$1_at_charly.heeg.de>...
> Hello,
>
> we just installed the Oracle Agent for Backup Exec. Now we get
> some strange behavior in Oracle (It is 8.1.7 on Windows 2000 client).
> After the backup with Backup Exec we can connect to the database
> and perform select statements. The first insert or update statement
> opens a DOS box with the following contents
>
> +---------------------------------------------------------------------------
> --+
> ¦
> ¦
> ¦ Warning - The following error occured during ORACLE redo log archival:
> ¦
> ¦
> ¦
> +---------------------------------------------------------------------------
> --+
> ORACLE Instance nils - Can not allocate log, archival required
> +---------------------------------------------------------------------------
> --+
> ¦ Press <ENTER> to acknowledge message.
> ¦
> +---------------------------------------------------------------------------
> --+
>
> greetings
>
> Clemens Hoffmann
> www.heeg.de

welcome to archivelog.
connect via sqlplus as sys or system (or via svrmgrl if you choose) and type

SVRMGR> archive log start

and in the init.ora file located in %ORACLE_BASE%\admin\%ORACLE_SID%\pfile\init.ora

change the parameter to the following value:

log_archive_start = true

you can tell if the database is in archivelog mode by executing

SQL> select * from v$database;

Pd Received on Fri May 23 2003 - 11:13:18 CDT