0

When I was connecting to my database through SQL Developer tool I was getting error message as below:

ORA-00257, 00000, "archiver error. Connect internal only, until freed."
Cause:  The archiver process received an error while trying to archive
  a redo log.  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 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.

So I archive the log files by,

 alter system archive log all;

Still the same issue was there. So I checked the space using below commands:

SQL>  select name, round(space_limit/1048576),round(space_used/1048576), 
round((
round(space_used/1048576)*100)/(round(space_limit/1048576))) pct_used
2  from  v$RECOVERY_FILE_DEST;
NAME
--------------------------------------------------------------------------------
ROUND(SPACE_LIMIT/1048576) ROUND(SPACE_USED/1048576)   PCT_USED
-------------------------- ------------------------- ----------
C:\app\oracle\fast_recovery_area
                    104448                     63931         61

Lots of space are still available and I checked the below command also:

SQL> show parameter log_archive;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string      DG_CONFIG=
(jordan_local,india_
                                             local)
log_archive_dest                     string
log_archive_dest_1                   string      location=c:\app\oracle\f 
                                              ast_recovery_area\local\ARCHIV
                                                 ELOG\ valid_for=(all_logfiles,
                                                 all_roles) db_unique_name=loca
                                             l
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
log_archive_dest_2                   string      SERVICE=local LGWR SYNC db_uni
                                                 que_name=india_local

I checked archive log list too:

SQL> archive log list;

Database log mode                     Archive Mode

Automatic archival                    Enabled

Archive destination                   %ORACLE_HOME%\RDBMS

Oldest online log sequence            10655

Next log sequence to archive          10655

Current log sequence                  10657

What could be the reason for the error?

  • 1
    How do you select log_archive_dest_2? – miracle173 May 17 '17 at 18:00
  • Please provide both the SQL command you're using (or, the program and process, if this is a GUI interaction), and the exact error message. – RDFozz May 17 '17 at 18:34
  • It seems, that you completely changed the question (including the title). Anyway, check if the disk of C:\app\oracle\fast_recovery_area is full (I think this is disk c:). – miracle173 May 18 '17 at 7:37
  • Disk C is not at all full. Still lot of space is left(61 GB). – Joe Joy Valiyaveettil May 18 '17 at 9:33
  • According to your information(parameters), you are using Oracle Data Guard. If so what's about the standby database status? What's was there in the alert log ? on both of the databases primary as well as standby? – JSapkota May 18 '17 at 10:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.