Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using DB_RECOVERY_FILE_DEST and LOG_ARCHIVE_DEST - error ORA-16019

741847Mar 24 2011 — edited Mar 25 2011
Hello,

My database is currently configured to write archivelog files to two locations: /u01/app/oracle/archivelogs (which is the parameter log_archive_dest and is listed as number 1) and USE_DB_RECOVERY_FILE_DEST (10) which is
under /u01/app/oracle/flash_recovery_area. I want to move both locations to separate disks.

When I attempt to move either one, I get the following errors:


SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/u03/fra/MYDB/flash_recovery_area' SCOPE=BOTH;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/u03/fra/MYDB/flash_recovery_area' SCOPE=BOTH
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

SQL> alter system set log_archive_dest='/u02/archive/MYDB';
alter system set log_archive_dest='/u02/archive/MYDB'
*
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


Any ideas?

Thanks for any help.
This post has been answered by 848583 on Mar 25 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2011
Added on Mar 24 2011
35 comments
26,566 views