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

Cause:

When try setting up FRA, the below error is triggered due to size not specified

SQL> alter system set db_recovery_file_dest='/data01';
alter system set db_recovery_file_dest='/data01'
*
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

Workaround:

Specify the FRA size and set FRA location then

SQL> alter system set db_recovery_file_dest_size=5G;

System altered.


SQL> alter system set db_recovery_file_dest='/data01';

System altered.

Leave a Reply