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

Home -> Community -> Usenet -> c.d.o.server -> How to set Archivelog mod ?

How to set Archivelog mod ?

From: vigi98 <vigi98_at_caramail.com>
Date: 28 May 2002 00:38:41 -0700
Message-ID: <cafa5ee3.0205272338.41ad1985@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 - 02:38:41 CDT

Original text of this message

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