ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n

 Error:

When i tried to set the log_archive dest value then i got the following error:

SQL> ALTER SYSTEM SET log_archive_dest='D:oraclexe';
ALTER SYSTEM SET log_archive_dest='D:oraclexe'
*
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 or
DB_RECOVERY_FILE_DEST

Cause:
If you have configured Flash Recovery Area (default in 10gR2) with DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST parameter
then you cannot use the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST parameters any more. You must always use the LOG_ARCHIVE_DEST_n parameters in case you have configured flash recovery area. If you try to use LOG_ARCHIVE_DEST with a Flash Recovery Area configured you will receive errors.

Solution
Use the LOG_ARCHIVE_DEST_n parameter for configuration

SQL> ALTER SYSTEM SET log_archive_dest_1='location=D:oraclexe reopen';
System altered.

Related posts

Error: ORA-16765: Redo Apply is running

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB