First verify the space of Archive logs :
show parameter db_recovery_file;
select name
, floor(space_limit / 1024 / 1024) "Size MB"
, ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest
order by name
if you want to grant more space for Archive logs :
alter system set db_recovery_file_dest_size = 5G;
To delete Archive log older than one week use the command by connecting RMAN:
DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
No comments:
Post a Comment