ora-16019 when chaging log_archive_dest
253115Oct 9 2007 — edited Oct 9 2007my database is archiving to 2 locations:
1. DB_RECOVERY_FILE_DEST
2. log_archive_dest
I thought this is strange b/c these 2 parameters are incompatible. Instead of log_archive_dest, it should be log_archive_dest_n . Isn't it ?
when I do : archive log list, the value shown is USE_DB_RECOVERY_FILE_DEST
when I do: show parameter log_archive_dest, the only destination that's shown having a value is log_archive_dest.
When I try to change the log_archive_dest location from C:\oracle\archive to D:\oracle\archive , I keep getting an
ORA-16019: cannot use log_archive_dest_1 with log_archive_dest.
How do I change the log_archive_dest parameter to use another location ?