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.
