ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with ...

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.

 

131145202_311n.jpg

131145202_321n.jpg

131145202_331n.jpg

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26136400/viewspace-707889/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26136400/viewspace-707889/