ORA-00257 archiver error Connect internal only, until freed

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

This could be caused by due to archiver background process unable to write logs in archivelog destination because of archive destination is full. Until free make free size on archive destination database will not allow any transactions.

Using rman tool we can free the archive destination is the best way.

connect to the target machine
rman target /

rman>crosscheck archivelog all;
rman> delete noprompt obsolete;
rman> delete noprompt expired archivelog all; or
rman> delete archivelog all before 'sysdate-1'; or
rman> delete noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-1';

It will delete all the obsolate archivelogs from the archivelog location before present day.