oracle出現ora-00257報錯

標籤：oracle   ora-00257   oracle串連報錯   oracle出錯解決方案   

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報錯