ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

You might encounter ORA-19802 error while setting DB_RECOVERY_FILE_DEST

Error:

SQL> alter system set db_recovery_file_dest='/u01/app/oracle/fra';
alter system set db_recovery_file_dest='/u01/app/oracle/fra'
*
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

Solution:

First set the DB_RECOVERY_FILE_DEST_SIZE parameter, then set the DB_RECOVERY_FILE_DEST

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=10G;

System altered.

SQL> alter system set DB_RECOVERY_FILE_DEST='/u01/app/oracle/fra';

System altered.