ORA-00257:archiver error.Connect internal only, until freed
来源:互联网 发布:卖狗狗的软件 编辑:程序博客网 时间:2024/05/22 03:02
登录oracle的时候突然出现如下问题:
ORA-00257:archiver error.Connect internal only, until freed.
疑惑,可以猜想得到,可能是归档日志空间不足导致的。
用sysdba用户登录:
查询归档日志的空间的使用率:
归档日志默认的大小是2G
可以这么计算已经使用的空间:
SELECT SUM(A.BLOCK_SIZE * A.BLOCKS) / 1024 / 1024
FROM V$ARCHIVED_LOG A
WHERE A.DELETED = 'NO';
可见空间已经几乎耗尽了。
需要对归档日志进行清除,在删除归档日志之后需要使用rman维护控制文件,否则空间仍然无法释放:
首先检查无用的archivelog:
删除无用的archivelog和删除截止到10天前的归档日志:
- 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
- Tab Control And List Control使用小记
- 国际化
- 3D编程-旋转的三角形
- 【技艺】浅挖不如深钻
- 正确理解javascript的this关键字
- ORA-00257:archiver error.Connect internal only, until freed
- Android OpenGL ES 绘图方法参数解析
- JAVA基础整理
- 深入理解Javascript之this关键字
- container_of宏
- AS3 随机排序
- fedora配置一(开机时关闭独立显卡)
- BUNOJ 11552 Dominating Patterns
- 从春秋战国学习企业管理——管仲