RE: Archive logging

Isn't log_archive_start a deprecated parameter in 10g? You only need to
use the ALTER DATABASE ARCHIVELOG command now. It almost sounds like you
have archivelog turned on in MANUAL mode. Check the LOG_MODE of=20 V$DATABASE and see if says AUTOMATIC or MANUAL.

Jeff T.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Saturday, September 18, 2004 12:53 PM To: steven.hovington_at_procession.com
Cc: oracle-l_at_freelists.org
Subject: Re: Archive logging

Hmmm, no one answered this?

You need to turn on automatic archiving.

Do this at the system level by the following SQL command while logged in as SYSDBA:

   SQL> alter system archive log start;

Then change it permanently via the following command:

   SQL> alter system set log_archive_start=3Dtrue scope=3Dspfile;

HTH Jared

On Thu, 16 Sep 2004 13:59:37 +0100, Steven Hovington <steven.hovington_at_procession.com> wrote:
> Hi there,
>=20
> We're having a problem with a customer's database in Oracle 10g. It=20
> has archive logging switched on, and the server also has Backup Exec=20
> running with the module which backs up the Oracle database.
>=20
> Oracle is coming up with a DOS window with the following message:=20
> live; ARC1: Beginning to archive log 1 thread 1 sequence 791
> Press ENTER to acknowledge message
> live; ARC1: Creationg local archive destination LOG_ARCHIVE_DEST_1:=20
> 'd:\oracle\....' (etc)
> Press ENTER to acknowledge message
> live; ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1:=20
> 'd:\oracle\....' (etc)
> Press ENTER to acknowledge message
> live; ARC1: Completed archiving log 1 thread 1 sequence 791
> Press ENTER to acknowledge message
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l