【ORA-00257: archiver error. Connect internal only, until freed】
来源:互联网 发布:app游戏下载软件 编辑:程序博客网 时间:2024/05/21 05:18
========= 删除归档日志 =========
第一步: 直接删除 物理数据 rm
第二步:通过 rman 删除:
oracle@linux112:/opt/dbbak/log_archive_dest_1> rman
RMAN> connect target sys/sys_passwd
执行如下命令:
(1) crosscheck backup;
(2) delete obsolete;
(3) delete expired backup;
(4) crosscheck archivelog all;
(5) delete expired archivelog all;
(6) host;
此问题属于归档日志满了。
解决办法:
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ARCHIVELOG 99.9 0 3
FLASHBACKLOG 0 0 0
可以看出,ARCHIVELOG日志已经达到99.9%了。要把它清除掉
- 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
- pdf转换为ppt最佳转换方法
- SQL Server 查询处理中的各个阶段(SQL执行顺序)
- devstack安装openstack日志
- 多重背包转化为01背包的方法与思路
- CSU 1511 残缺的棋盘
- 【ORA-00257: archiver error. Connect internal only, until freed】
- 初之oAuth
- UITextField 只能输入数字、一个小数点、只能有两位小数
- 关于分类方法和数据我的选择
- php的stream_filter_append和stream_filter_prepend
- Android 获取SD卡路径和判断SD卡是否存在
- C#基础学习之【6】委托的使用
- unity游戏开发之[英雄联盟]的美女设计师:Katie De Sousa
- CentOS6.4安装vsftpd