oracle出现ora-00257报错

ORA-00257: 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 the 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.



大致是说oracle保存redo file的时候失败了，让登陆数据库查看是不是archive_log_dest是否有问题
先进入数据库查看下是不是
SQL> select * from v$flash_recovery_area_usage;
可以看到PERCENT_SPACE_USED的一个值是99.7而他对应的FILE_TYPE是ARCHIVELOG.所以大致可以知道是ARCHIVELOG已经满了！

select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage 可以查看archivelog占了多大的空间，而show parameter recover可以知道系统分配了多少archivelog空间。

然后退出数据库，进入rman，准备删除archivelog
ramn target /

执行删除操作
RMAN> delete archivelog all

删除完成以后，在此访问连接显示正常

本文出自 “斗月” 博客，请务必保留此出处http://douyue.blog.51cto.com/10174393/1652843

oracle出现ora-00257报错

原文：http://douyue.blog.51cto.com/10174393/1652843