Using DB_RECOVERY_FILE_DEST and LOG_ARCHIVE_DEST - error ORA-16019
741847Mar 24 2011 — edited Mar 25 2011Hello,
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.