ORA-19802: cannot use DB_RECOVERY_FILE

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

Post published:February 19, 2024

Today in this article, we will discuss about how to resolve if you encounter ORA-19802 error.

Problem :

SQL> alter system set db_recovery_file_dest=’/oradata01/TEST1/TEST2/data/fra’ scope=both;
alter system set db_recovery_file_dest=’/oradata01/TEST1/TEST2/data/fra’ 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

Solution :

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=20G scope=both;
System altered.

SQL> alter system set db_recovery_file_dest='/oradata01/TEST1/TEST2/data/fra' scope=both;

System altered.

SQL>

Hope this article helps!! Also, you can get a reference from the Oracle Doc too.

Our Related Articles :

ORA-38301: can not perform DDL/DML over objects in Recycle Bin