ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

Issue:

Below error encountered when trying to set LOG_ARCHIVE_DEST_1 while configuring Oracle Data Guard Parameters on Primary Database.

SQL> startup mount
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

Cause:

We cannot use the LOG_ARCHIVE_DEST at the same time with LOG_ARCHIVE_DEST_1

Solution:

If you are using spfile then you can use the following:

SQL> alter system set log_archive_dest=' ' scope=spfile;
SQL> alter system set log_archive_dest_1='<archive log location>' scope=spfile;

Set other standby releated parameters and then Bounce Database to reflect the parameters.

If you are using pfile then follow below steps:

1) Comment out the LOG_ARCHIVE_DEST parameter in pfile
2) Shutdown the database

3) Startup with new pfile and mount the database
    SQL> startup mount pfile='<pfilename>';
   
4) check for the parameter log_archive_dest in not used

5) If parameters are ok, then create spfile from this pfile
    SQL> create spfile from pfile='<pfilename>';
   
6) Shut down the database and start it again so that it will use the spfile newly created
7) Set LOG_ARCHIVE_DEST_1 and other standby related parameters then bounce the database
    SQL> alter system set log_archive_dest_1='<archive log location>' scope=spfile;