Archive log destination full raised error 19809
Oracle database is not open its give error in alert log. Error occurred due to archive log space is full. Please check the location where archive log is configured.
You can check the location of archive log by connecting as SYS user
sqlplus sys as sysdba
SQL>archive log list;
Step 1: Go to RMAN terminal.
rman> CONNECT target /
rman> crosscheck archivelog ALL;
rman> DELETE expired archivelog ALL;
After delete some archive log which expired if some space released for sufficient work then you can continue.
Other wise you copy some needed archive in other location.then use the following command for delete archive up to specific date:
Before one day:
RMAN> delete archivelog all completed before 'SYSDATE-1';
Before two day:
RMAN> delete archivelog all completed before 'SYSDATE-2';
If you have enough space on drive you may also increase the size from 20 GB to 50 Gb.
Check the size of db_recovery_file_dest_size
show parameter db_recovery_file_dest_size
Increase the size of db_recovery_file_dest_size parameter
alter system set db_recovery_file_dest_size=50G;