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

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

Cause: The archiver process received an error while trying to archive a redolog. 
If the problem is not resolved soon, the database will stop executing transactions. 
The most likely cause of this message is the destination device is out of space 
to store the redo log file.

Action: Check the archiver trace file for a detailed description of the problem.
Also, verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST 
is set up properly for archiving.

ORA-00257 comes under "Oracle Database Server Messages". 
These messages are generated by the Oracle database server when running any Oracle program.
How to free archive destination device:
Most probably archive destination is full. We should backup archive logs, then remove them.

We can use following steps for this
1. find the location of Archive destination by
 show parameter archive_dest
 lets say it provide  LOCATION=/u10/oradata/mydb/arch

2. move some files to some other location using os command
 cd /u10/oradata/mydb/arch
 mv /u10/oradata/mydb/arch/* /u15/oradata/mydb/arch-bkp/

Or it can be done using RMAN also

rman target /

RMAN> backup archive log all format '/u15/oradata/mydb/arch-bkp';

RMAN> delete archive until time 'trunc(sysdate)';

Related Posts:
- ORA-04031: unable to allocate n bytes of shared memory
- ORA-01157: cannot identify/lock data file string - see DBWR trace file
- ORA-00849: SGA_TARGET cannot be set to more than MEMORY_MAX_TARGET
- ORA-27101: shared memory realm does not exist
- ORA-00604: error occurred at recursive SQL level string
- ORA-00600: internal error code
- ORA-16000: database open for read-only access


  1. You do like this also, as follows;

    RMAN> connect target sys/password@DBname


    run {
    allocate channel t1 type disk;
    backup current controlfile format '/u01/ora_backup/rman/%d_%u_%s';
    backup database format '/u01/ora_backup/rman/%d_%u_%s';
    sql "alter system archive log current";
    backup archivelog all delete input format '/u01/ora_backup/rman/arch_%d_%u_%s';
    release channel t1;

    Ranvir here...

  2. Find out file system usage for Oracle archive destination using OS command:

    $ df -k | grep oraarch

    Ranvir here...

  3. Good work, very informative, keep it up

    1. Thanks Ajay, you must check out Oracle SQL, Oracle PL/SQL and Oracle Tips

  4. This comment has been removed by the author.

  5. Dear Nimish when i connect the system/system@string then same error is showing (ora-00257),how to solve ?