Re: How to set Archivelog mod ?

From: Adam Buczynski <Adam.Buczynski_at_motorola.com>
Date: Tue, 28 May 2002 10:24:52 +0200
Message-ID: <acvet3$jfq$1@newshost.mot.com>

Didn`t you forget to:

SHUTDOWN IMMEDIATE STARTUP MOUNT ALTER DATABASE ARCHIVELOG ALTER DATABASE OPEN Adam

"vigi98" <vigi98_at_caramail.com> wrote in message news:cafa5ee3.0205272338.41ad1985_at_posting.google.com...
> Hi all,
>
> In my init.ora, I tried lots of parameters in order to set my database
> in archivelog mode. There's nothing to do : I always have this :
>
> SQL> archive log list;
> Database log mode No Archive Mode
> Automatic archival Enabled
> Archive destination /u08/backup
> Oldest online log sequence 4771
> Current log sequence 4778
>
> As you can see, something is enabled (I wonder what it means...) but
> I'm not in archivelog mode. So what have I to do ?
>
> Following, the archive section of my init.ora :
> #--- Archive Mode ---
> log_archive_start = true
> #log_archive_dest_1 = "location=/u08/backup/"
> log_archive_dest_1 = "LOCATION=/u08/backup MANDATORY"
> #log_archive_dest = "location=/u08/backup/"
> log_archive_format = arch_%t_%s.arc
> log_archive_max_processes = 1 #AHU
> log_archive_dest_state_1 = ENABLE
>
>
> Thanks in advance for your help.
Received on Tue May 28 2002 - 03:24:52 CDT