December 23 2014

ORA-00257 archiver error Connect internal only until freed

ORA-00257 archiver error Connect internal only until freed
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.

查看FLASH_RECOVERY_AREA空间中各部分使用情况
select * from v$recovery_file_dest;
select * from v$flash_recovery_area_usage;
可以看出来是归档所在空间满了。
两个解决方法 :
1.添加空间

alter system set DB_RECOVERY_FILE_DEST_SIZE=20g;
2.删除部分备份和归档
rman target /
DELETE ARCHIVELOG FROM TIME ‘SYSDATE-7’;
DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7’;



Copyright 2019. All rights reserved.

Posted 2014年12月23日 by ucjmh in category "oracle

Leave a Reply

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