Pages

Wednesday, July 3, 2019

How to solve ORA-00257 archiver error

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