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;
Комментарии