上班第一天遇到ORA_00257

一个月的假期结束,今天第一天上班,我正在做数据库点检,被用户告知数据无法连接,数据库报ORA_00257错误

ORA_00257:大多数据情况下是由归档路径空间不足引起的

ORACLE的解释如下:

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.

运行df –h查看空间使用情况,发现归档路径已满,清理14天以前的归档问题解决

放假前以做归档自动清理排定计划(前提是归档已备份),检查清理日志,发现清理正常(其他服务器也正常),为什么会产生这情况没有查明原因,记录下这个问题备查.

ITPub博客

上班第一天遇到ORA_00257