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

Cause:

The archiver process received an error while trying to archive a redo log due to archive location or FRA getting full.

Solution:

This can solved in two ways.

1. Increase FRA
2. Clear old archives.

Increase FRA:

SQL> show parameter db_recovery_file_dest;
NAME                                 TYPE        VALUE
———————————— ———– ——————————
db_recovery_file_dest                string      C:oracleproduct12.2.0.1flash_recovery_area
db_recovery_file_dest_size           big integer 2G

SQL> ALTER SYSTEM SET db_recovery_file_dest_size=’10G’ SCOPE=BOTH;

Clear old archives:

Find the space used in flash recovery area by using following SQL:

col ROUND(SPACE_LIMIT/1048576) heading “Space Allocated (MB)” format 999999
col round(space_used/1048576) heading “Space Used (MB)” format 99999
col name format a40
select name, round(space_limit/1048576) As space_limit,round(space_used/1048576) As space_used
from v$RECOVERY_FILE_DEST;

If Flashback log is using more space decrease and increase the FRA.

If archives are using more space move archives to different space or use the below command to remove archives.

 RMAN>delete archivelog until time ‘SYSDATE-1’;
 or,
 RMAN>delete archivelog all;

  • June 28, 2018 | 31 views
  • Comments