Tag Archives: crosscheck archivelog

Error 19809 creating archive log file in Oracle

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
password:
SQL>archive log list;

Solution:
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';

Another way
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;

Advertisements