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