RE: Archive logging

Correction, if you have automatic archiving, the LOG_MODE will say ARCHIVELOG. -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Jeff Sent: Friday, September 24, 2004 12:25 PM To: jkstill_at_gmail.com; steven.hovington_at_procession.com Cc: oracle-l_at_freelists.org
Subject: 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=3D20 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=3D3Dtrue scope=3D3Dspfile;

HTH Jared

On Thu, 16 Sep 2004 13:59:37 +0100, Steven Hovington <steven.hovington_at_procession.com> wrote:
> Hi there,
>=3D20
> We're having a problem with a customer's database in Oracle 10g. =20
>It=3D20 has archive logging switched on, and the server also has =
Backup=20
>Exec=3D20 running with the module which backs up the Oracle database.=20
>=3D20 Oracle is coming up with a DOS window with the following=20
>message:=3D20 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:=3D20
>'d:\oracle\....' (etc)
> Press ENTER to acknowledge message
> live; ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1:=3D20 =
=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
--
http://www.freelists.org/webpage/oracle-l