ORA-00257:archiver error.Connect internal only, until freed
来源:互联网 发布:淘宝vr购物在哪里打开 编辑:程序博客网 时间:2024/05/17 09:47
产生原因:出现ORA-00257错误(空间不足错误),通过查找资料,绝大部分说这是由于归档日志太多,占用了全部的硬盘剩余空间导致的,通过简单删除日志或加大存储空间就能够解决。
解决办法:
1,SecureCRT登录服务器,切换用户Oracle,连接oracle
[root@userbeta~]# su - oracle
[oracle@userbeta~]$ sqlplus /nolog
SQL> connect /as sysdba
2,检查flash recovery area的使用情况,可以看见archivelog已经很大了,达到99.94
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
可以看出,ARCHIVELOG日志已经达到99.9%了。要把它清除掉!
然后执行 exit命令 退出sql窗口,,,接下来开始进入rman
3,现在来清理一下archivelog归档日志
进入RMAN
方法如下:
敲入rman nocatalog(这里是nocatalog的方式)
接着再敲入connect target /。
检查一些无用的archivelog
RMAN> crosscheck archivelog all;
删除截止到前一天的所有archivelog
RMAN> delete archivelog until time 'sysdate-1' ;
6,再次查询flash recovery area的使用情况:
先按照步骤1,进入sqlplus环境,然后使用下面命令查询发现,只使用0.66%,说明清除归档日志成功!
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
- ERROR: ORA-00257: archiver error. Connect internal only, until freed.
- ERROR: ORA-00257: archiver error. Connect internal only, until freed.
- ERROR: ORA-00257: archiver error. Connect internal only, until freed.
- ORA-00257: archiver error. Connect internal only, until freed.
- ORA-00257: archiver error. Connect internal only, until freed
- ORA-00257: archiver error. Connect internal only, until freed 问题解决
- ORA-00257: archiver error, connect internal only, until freed
- ORA-00257 : archiver error. Connect internal only, until freed
- Oracle ORA-00257: archiver error. Connect internal only, until freed
- ORA-00257 archiver error.connect internal only,until freed
- ORA-00257: archiver error. Connect internal only, until freed
- Oracle ORA-00257: archiver error. Connect internal only, until freed
- ORA-00257 : archiver error. Connect internal only, until freed
- ORA-00257: archiver error. Connect internal only, until freed.
- ORA-00257: archiver error. Connect internal only, until freed.
- ORA-00257:archiver error.connect internal only,until freed
- ORA-00257:archiver error. Connect internal only, until freed.
- ORA-00257:archiver error.Connect internal only,until freed
- dede网页和数据库编码不一致
- egret[12.23]
- android gradle配置文件
- Java数据结构(1)
- postgresql使用及操作
- ORA-00257:archiver error.Connect internal only, until freed
- 【腾讯云的1001种玩法】如何使用腾讯云做博客
- 子类不能抛出新的异常
- 如何用EDIUS手绘遮罩功能
- java怎么实现多线程同步
- bzoj 1070: [SCOI2007]修车(费用流)[省选计划系列]
- 技术总结
- poj Find The Multiple(DFS,BFS)
- YOLO源码详解(二)- 函数剖析