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.1