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

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 27 08:31:46 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:

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

Fast solution is to simply increase the value for db_recovery_file_dest_size.

Steps:

  1. SQL> sho parameter db_recovery_file
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /recoveryarea
db_recovery_file_dest_size           big integer 200G
SQL>

 

2.Overall space usage in /recoveryarea mountpoint

$ df -h /recoveryarea/$ORACLE_SID/archivelog/
Filesystem             size   used  avail capacity  Mounted on
/recoveryarea           98G    55G    42G    57%    /recoveryarea

Space usage in database /recoveryarea directory.

$ du -sh /recoveryarea/$ORACLE_SID/archivelog/
  10G    /recoveryarea/$ORACLE_SID/archivelog

3. SQL> alter system set db_recovery_file_dest_size = 15G;

SQL> alter system set db_recovery_file_dest_size = 15G;

System altered.

SQL>

 

 

Hits: 0

Leave a Reply

Your email address will not be published. Required fields are marked *