Wednesday, 8 January 2020

ORA-19809: limit exceeded for recovery files


When i try to switch logfile am getting below error.

SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
ALTER SYSTEM ARCHIVE LOG CURRENT
*
ERROR at line 1:
ORA-16038: log 1 sequence# 6865 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '+DATA/ORCL/ONLINELOG/group_1.258.997872353'


 Check recovery dest and recovery dest size properly set or not. in my case recovery dest size set to 20 instead of 20G. it means its can alocate only 20 bytes and not sufficient for archive creation at all.

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DATA
db_recovery_file_dest_size           big integer 20

i corrected it to 20G, issue resolved.

SQL> alter system set db_recovery_file_dest_size=20G;

System altered.

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DATA
db_recovery_file_dest_size           big integer 20G


SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

System altered.


No comments:

Post a Comment