Hi,
I don't know why the archive destination in my db is pointing to ..\archive2 instead of ..\archive (a mandatory destination). I want to change it to ..\archive but couldn't do it. Here is the
scenario.

> archive log list;

Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\oracle\oradata\mydb\archive2
Oldest online log sequence 1999
Next log sequence to archive 2001
Current log sequence 2001


These are the entries in my init file:

##### For archiving if archiving is enabled #####
log_archive_start = true
log_archive_dest_1 = "location=C:\oracle\oradata\mydb\archive MANDATORY"
log_archive_dest_2 = "location=C:\oracle\oradata\mydb\archive2"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

If I want to change my archive destination to ...\mydata\archive (instead of ..\archive2)
directory how would I do that? I tried both of the following commands but none of them work.


SQL> alter system set log_archive_dest='C:\oracle\oradata\mydb\archive';
alter system set log_archive_dest='C:\oracle\oradata\mydb\archive'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n


SQL> alter system archive log start to 'C:\oracle\oradata\mydb\archive';
alter system archive log start to 'C:\oracle\oradata\mydb\archive'
*
ERROR at line 1:
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST

Do I have other options?? Please advise. Thanks