Hi,

You can get ” ORA-02097: parameter cannot be modified because specified value is invalid ” error, when you set  db_recovery_file_dest parameter.

 

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

 

When i set db_recovery_file_dest parameter, i got following errors.

SQL> alter system set db_recovery_file_dest='/backup/recovery_area' scope=both;
alter system set db_recovery_file_dest='/backup/recovery_area' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

 

 

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

To solve this problem, firstly set DB_RECOVERY_FILE_DEST_SIZE like following.

 

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=200G scope=both;

System altered.

 

Then try to set db_recovery_file_dest, but i got following error.

SQL> alter system set db_recovery_file_dest='/backup/recovery_area' scope=both;
alter system set db_recovery_file_dest='/backup/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

 

 

 

ORA-19802 ORA-16019 ORA-02097

 

To solve this error, firstly reset log_archive_dest parameter.

SQL> alter system set log_archive_dest='' scope=both;

System altered.

 

 

Then set db_recovery_file_dest again, now problem has ben solved.

SQL> alter system set db_recovery_file_dest='/backup/recovery_area' scope=both;

System altered.

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )