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

时间:2022-10-28 21:58:54
问题描述:数据库启动报错ORA-03113,告警日志出现ORA-16038、ORA-19809、ORA-19815报警,如下所示:
数据库:oracle 11.2.0.4 64位
系统:centos 7.9 64位
SQL> startup
ORACLE instance started.

Total System Global Area 1586708480 bytes
Fixed Size 2253624 bytes
Variable Size 956304584 bytes
Database Buffers 620756992 bytes
Redo Buffers 7393280 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2415
Session ID: 191 Serial number: 3

Trace文件如下:
Errors in file /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, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary 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 in file /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
System state dump requested by (instance=1, osid=2653), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_2615_20221028211446.trc
Dumping diagnostic data in directory=[cdmp_20221028211446], requested by (instance=1, osid=2653), summary=[abnormal instance termination].
Instance terminated by USER, pid = 2653

异常原因:
快速恢复区使用率达到100%.
处理过程:
将数据库启动到mount状态后,
1、系统层面删除快速恢复区的归档日志.
2、进入rman,crosscheck archivelog all
3、delete expired archivelog all
4、alter system set db_recovery_file_dest_size=25g;

此后成功开启数据库.