ORA-19809&&ORA-03113
来源:互联网 发布:apache api文档 编辑:程序博客网 时间:2024/05/13 19:10
ORACLE 例程已经启动。
Total System Global Area 3407261696 bytes
Fixed Size 2180504 bytes
Variable Size 2348812904 bytes
Database Buffers 1040187392 bytes
Redo Buffers 16080896 bytes
数据库装载完毕。
ORA-03113: 通信通道的文件结尾
进程 ID: 6416
会话 ID: 5 序列号: 3
查看告警日志:
************************************************************************
Errors in file d:\app\lenovo\diag\rdbms\orcl\orcl\trace\orcl_arc1_4252.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 14319616 bytes disk space from 4102029312 limit
ARC1: Error 19809 Creating archive log file to 'D:\APP\LENOVO\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_12_29\O1_MF_1_284_%U_.ARC'
Errors in file d:\app\lenovo\diag\rdbms\orcl\orcl\trace\orcl_ora_5368.trc:
ORA-19815: ??: db_recovery_file_dest_size ?? (? 4102029312 ??) ??? 100.00%, ?? 0 ?????
************************************************************************
官方给出的原因及解决方案:
ORA-19809: limit exceeded for recovery files
Cause: The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: There are five possible solutions: 1) Take frequent backup of recovery area using RMAN. 2) Consider changing RMAN retention policy. 3) Consider changing RMAN archived log deletion policy. 4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE. 5) Delete files from recovery area using RMAN.
这里采用第四种方案:
idle>startup nomount;
ORACLE 例程已经启动。
idle>alter system set db_recovery_file_dest_size=8g scope=both;
系统已更改。
idle>shutdown immediate;
ORA-01507: ??????
ORACLE 例程已经关闭。
idle>startup
ORACLE 例程已经启动。
Total System Global Area 3407261696 bytes
Fixed Size 2180504 bytes
Variable Size 2348812904 bytes
Database Buffers 1040187392 bytes
Redo Buffers 16080896 bytes
数据库装载完毕。
数据库已经打开。
- ORA-19809&&ORA-03113
- ORA-03113,ORA-07445
- ORA
- ora
- ORA-16038,ORA-19809,ORA-00312
- ORA-16038,ORA-19809,ORA-00312
- ORA-16038,ORA-19809,ORA-00312问题解决
- ORA-16038:ORA-19809:ORA-00312:
- ORA-03113 ORA-24324 ORA-01041
- ORA-24324 ORA-01041 ORA-03113
- ORA-19809
- ora-03113
- ORA-03113
- ORA-03113
- ORA-03113
- ora-03113
- ORA-03113
- ORA-03113
- iOS xcode4 NSString字符格式化类型
- js解析xml文件
- Java--函数(重载)
- 聊天系统的各种技术的实施
- 网站的虚拟路径
- ORA-19809&&ORA-03113
- opencv sift特征及匹配
- HADOOP基本操作命令
- c#连接Sql 数据库步骤图解
- Java transient Serializable Externalizable 关键字使用
- Java环境变量设置
- JavaScript 学习笔记
- 关于SSL/TLS中AES安全性|BEAST攻击的详细步骤以及RC4强度的一些笔记
- 将android 系统自动的app导出来(备份出来)