Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Archive logging

Re: Archive logging

From: Jared Still <jkstill_at_gmail.com>
Date: Sat, 18 Sep 2004 10:53:22 -0700
Message-ID: <bf4638040918105328fee326@mail.gmail.com>


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=true scope=spfile;

HTH Jared

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US