2018/11/16

ORA-00257问题解决

今天登录Tiptop ERP测试环境时,出现错误“ ORA-00257: archiver error. Connect internal only, until freed”,通过以下方法手动释放归档空间后已OK,做个记录。

> rman target / 
RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';  ---删除7天前的所有归档日志
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
原文:https://blog.csdn.net/wenshuangzhu/article/details/44059809 
关闭归档功能的方法:https://blog.csdn.net/JohnnySun2015/article/details/74196786

定期删除归档脚本:https://blog.csdn.net/liqfyiyi/article/details/7017238 或 http://www.zhoudl.com/linux/1006.htm

没有评论: