#2186

There are five possible solutions to solve ORA-19809: limit exceeded for recovery files: 1) Take frequent backup of recovery area using RMAN. 2) Consider changing RMAN retention policy. 3) Consider changing RMAN archived log deletion policy. 4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE. 5) Delete files from recovery area using RMAN.

Source: How to Resolve ORA-19809 Limit Exceeded for Recovery Files – Ed Chen Logic

Check current parameters :

show parameter db_recovery

Increase DB Recovery max size :

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=200G SCOPE=BOTH;

Error code : ORA-00257, ORA-19809, ORA-16038

archivelog, database, error, ORA, oracle

How to Install Zabbix Agent and Add Windows Host to Zabbix Monitoring – Part 4 [Oracle] How-To