重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1394|回复: 0
打印 上一主题 下一主题

[Oracle] 数据库启动报错ORA-03113,告警日志出现ORA-16038、ORA-19809、ORA-19815报警

[复制链接]
跳转到指定楼层
楼主
发表于 2022-11-3 13:41:55 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
问题描述:数据库启动报错ORA-03113,告警日志出现ORA-16038ORA-19809ORA-19815报警,如下所示:
数据库:oracle 11.2.0.464
系统:centos 7.964
SQL>startup
ORACLEinstance started.
TotalSystem Global Area 1586708480 bytes
FixedSize                  2253624 bytes
VariableSize             956304584 bytes
DatabaseBuffers          620756992 bytes
RedoBuffers                7393280 bytes
Databasemounted.
ORA-03113:end-of-file on communication channel
ProcessID: 2415
SessionID: 191 Serial number: 3
Trace文件如下:
Errors infile /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2653.trc:
ORA-19815:WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, andhas 0 remaining bytes available.
************************************************************************
You havefollowing choices to free up space from recovery area:
1.Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOGDELETION POLICY.
2. Backup files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Adddisk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Deleteunnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files,then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
ARCH:Error 19809 Creating archive log file to '/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2022_10_28/o1_mf_1_7788_%u_.arc'
Errors infile /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2653.trc:
ORA-16038:log 3 sequence# 7788 cannot be archived
ORA-19809:limit exceeded for recovery files
ORA-00312:online log 3 thread 1: '/u01/app/oracle/oradata/orcl/redo03.log'
USER(ospid: 2653): terminating the instance due to error 16038
Systemstate dump requested by (instance=1, osid=2653), summary=[abnormal instancetermination].
SystemState dumped to trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_2615_20221028211446.trc
Dumpingdiagnostic data in directory=[cdmp_20221028211446], requested by (instance=1,osid=2653), summary=[abnormal instance termination].
Instanceterminated by USER, pid = 2653
异常原因:
快速恢复区使用率达到100%.
处理过程:
将数据库启动到mount状态后,
1、  系统层面删除快速恢复区的归档日志.
2、  进入rman,crosscheckarchivelog all
3、  deleteexpired archivelog all
4、  altersystem set db_recovery_file_dest_size=25g;
此后成功开启数据库.
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-25 20:27 , Processed in 0.105523 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表