How to quickly resolve archiver error in oracle database 11g, 12c, 19c (ORA-00257: archiver error. Connect internal only, until freed.)

 How to quickly resolve archiver error in oracle database 11g, 12c, 19c

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

First check the location and size of the archive log location with below command:

SQL>  show parameter recovery

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      +FRA

db_recovery_file_dest_size           big integer 1000G

recovery_parallelism                 integer     0

As you can see, the locations is +FRA inside ASM storage and the size is 1TB.

Next check the free space you have available in your ASM location with below query:

SQL> select name , total_mb/1024, free_mb/1024 from v$asm_diskgroup;

NAME                           TOTAL_MB/1024 FREE_MB/1024

------------------------------ ------------- ------------

DATA                                212432   133635.047

DBFS_DG                        946.3125   935.105469

FRA                                 35430.125   9797.95313

SQL> 

Here in the FRA diskgroup, we have 9TB free, so the quickest thing to resolve this error is to increase the db_recovery_file_dest_size parameter in the database while connected as sysdba.

Run below command to increase the size of the db_recovery_file_dest_size from 1TB to 2TB:

alter system set db_recovery_file_dest_size=2000G;

after that, then switch log files 3 times to release archivelogs and re-establish connections to the database with below command:

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> exit

Disconnect

Finally, try to connect with client to ensure that the issue has been resolved.