Re: Archive logging

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: steven.hovington@xxxxxxxxxxxxxx
  • Date: Sat, 18 Sep 2004 10:53:22 -0700

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@xxxxxxxxxxxxxx> 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
>
--
//www.freelists.org/webpage/oracle-l

Other related posts: