DBA Notes: 2011/09/19

Cheng Li

ORA-16019

The usage of flash recovery area

During our Oracle system upgrade to Oracle 10.2.0.1, we apply the flash recovery area feature.

SQL> alter system set log_archive_dest_1=’LOCATION=/home/oradata/archive/fra/’;

log_archive_dest_1=’LOCATION=/home/oradata/archive/fra/’ *

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLUS_DEST

From this error message, we can make a conclusion: the usage of FRA is not compatible with original archive log setting. It is a complete replacement from archive log mode to FRA. FRA mode is a simplified mode for database backup and recovery.

Solution:

SQL> alter system set log_archive_dest=’’;

System altered.

SQL> alter system set log_archive_dest_1=’LOCATION=/home/oradata/archive/fra/’;

System altered.