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

标题: 数据库启动报错ORA-03113，告警日志出现ORA-16038、ORA-19809、ORA-19815报警 [打印本页]

作者: denglj 时间: 2022-11-3 13:41
标题: 数据库启动报错ORA-03113，告警日志出现ORA-16038、ORA-19809、ORA-19815报警

问题描述：数据库启动报错ORA-03113，告警日志出现ORA-16038、ORA-19809、ORA-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;

此后成功开启数据库.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)