ORA-19809: limit exceeded for recovery files

ORA-19809: limit exceeded for recovery files


Login as sys user

Check db_recovery_file_dest_size

SQL>  show parameter db_recovery_file_dest_size

NAME                                      TYPE             VALUE
------------------------------------ -----------          ------------------------------
db_recovery_file_dest_size      big integer       5G

SQL> alter system set db_recovery_file_dest_size=50G scope=both;


SQL>  show parameter db_recovery_file_dest_size

NAME                                      TYPE             VALUE
------------------------------------ -----------          ------------------------------
db_recovery_file_dest_size      big integer       50G