Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to set Archivelog mod ?
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