ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n

ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or
DB_RECOVERY_FILE_DEST

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.