ORA-16019: Cannot Use Db_recovery_file_dest With LOG_ARCHIVE_DEST Or LOG_ARCHIVE_DUPLEX_DEST

SQL> alter system set log_archive_dest_2='service=ocp_dr noaffirm async valid_for=(online_logfiles,primary_role) db_unique_name=ocp_dr';
alter system set log_archive_dest_2='service=ocp_dr noaffirm async valid_for=(online_logfiles,primary_role) db_unique_name=ocp_dr'
*

ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_2 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST

ORA-16019 Description

DB_RECOVERY_FILE_DEST and LOG_ARCHIVE_DEST destinations we cannot use at the same time. The value of anyone should have a null value.

Solution of ORA-16019

Use the following steps to solve the error.

Step 1: Set null value for log_archive_dest.

SQL> alter system set log_archive_dest='';
System altered.

Step 2: Now set the value for DB_RECOVERY_FILE_DEST using the following command.

SQL> alter system set DB_RECOVERY_FILE_DEST='/u01/app/fast_recovery_area';
System altered.

Note: May be you will face destination size error during change so before running the above command you must set DB_RECOVERY_FILE_DEST_SIZE then try again.

Solution of ORA-12919

Find more ORA-ERROR SOLUTION