top of page
Writer's pictureblkrishnarao

Archivelog Space Filled up or Archivelog is 100% full | Oracle Database

Updated: Apr 16

The following opinions expressed in this post are my own and in no way connected to my employer. 


Issue:

You may see an error message in Database Alert log regarding Archive Log Space getting 100% filled.


Solution:

Try below to delete archivelogs or cleanup space or to increase allocated space:


Delete Expired Archivelogs:

rman target /
crosscheck archivelog all;
delete expired archivelog all;
crosscheck backup;

Delete Archivelogs older than 30 days:

rman target /
run{ 
allocate channel c1 type disk; 
delete force noprompt archivelog until time 'SYSDATE-30'; 
release channel c1; 

You can also increase space allocated to avoid the error, but check if you have diskspace available to do so:


alter system set db_recovery_file_dest_size=200G scope=both;

0 views0 comments

Recent Posts

See All

Комментарии


bottom of page