删除归档日志 ORA-00257:archiver error.Connect internal only, until freed的问题
来源:互联网 发布:mac字典能用mdx 编辑:程序博客网 时间:2024/05/16 09:50
C:\Users\vidor>sqlplus/nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 9月 18 17:04:09 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/orcl as sysdba
已连接。
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 98.85 0 82
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=10g
2 ;
系统已更改。
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 20.95 0 85
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。
以上方法不能从根源上解决这个问题,但是,可以使当前问题解决。
- 删除归档日志 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 错误的处理方法(日志已满)
- 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
- 把STL容器放入共享内存
- 分享几个高权重的问答平台
- asp.net上传文章大小限制
- 真正的长像
- 标题:FPGA与CPLD的区别
- 删除归档日志 ORA-00257:archiver error.Connect internal only, until freed的问题
- Twitter OAuth1.0认证过程
- wsgi-werkzeug
- 教育,老师,学生??(education teacher student)
- Telegram Encoding and Decoding
- PC上运行平板的命令(有su限制的)
- jQuery easyUI Pagination控件自定义div分页(不用datagrid)
- tomcat运行期优化及问题解决方案
- 自旋锁 互斥锁 读写锁 递归锁