ORA-00257: archiver error. Connect internal only, until freed.



Last updated on July 17th, 2015 at 06:05 pm

The error “ORA-00257: archiver error. Connect internal only, until freed” happens when the archive destination become full and oracle cannot archive the redo log further

Solution

a) Increase the DB_RECOVERY_FILE_DEST_SIZE 
show parameter db_recovery_file_dest;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 1000g;
b)  Change the DB_RECOVERY_FILE_DEST 
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ‘/u001/oracle’;
or

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ‘+FLASH_ARCH’;

c) Delete the files used in DB_RECOVERY_FILE_DEST_SIZE 
SELECT * FROM V$RECOVERY_FILE_DEST;

If the archive are not required or backup completed. We can delete the old archives
$rman target /
RMAN>delete archivelog
until time ‘SYSDATE-3’;
or,
RMAN>delete archivelog all;
or

delete archivelog UNTIL TIME = ‘SYSDATE-1.5’ backed up 1 times to sbt_tape;

Other useful command in this case

LIST COPY   OF ARCHIVELOG ALL         COMPLETED AFTER ‘SYSDATE-1’;
DELETE NOPROMPT BACKUP COMPLETED BEFORE ‘SYSDATE-4’;
LIST COPY   OF ARCHIVELOG UNTIL TIME = ‘SYSDATE-18’;BACKUP ARCHIVELOG COMPLETION TIME BETWEEN  ‘SYSDATE-28’ AND ‘SYSDATE-7’;


Leave a Reply