RE: Archive logging

  • From: "Thomas Jeff" <jeff.thomas@xxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>, <steven.hovington@xxxxxxxxxxxxxx>
  • Date: Fri, 24 Sep 2004 12:24:53 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Saturday, September 18, 2004 12:53 PM
To: steven.hovington@xxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx> 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
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: