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

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

Details: This error occurs when attempting to login via sqlplus

Cause:One of the drives was out of space, the one that stored archive logs.

Solution:Removing old archive logs by starting RMAN and running the following script:

run {
delete noprompt archivelog all completed before 'sysdate-7';
}

The above will remove all archive logs older than 7 days

How to find archive logs location

Execute from sqlplus:

1) archive log list;

2) show parameter db_recovery_file_dest;

or query V$ARCHIVE_DEST

3) select dest_name, status, destination from v$archive_dest;