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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s