ora-16038 ora-19809 ora-00312报错处理

启动报错
SQL> startup
ORACLE instance started.

Total System Global Area 1.0033E+10 bytes
Fixed Size                  8935488 bytes
Variable Size            1677721600 bytes
Database Buffers         8321499136 bytes
Redo Buffers               24616960 bytes
Database mounted.
ORA-16038: log 2 sequence# 64 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '+DATA/ORCL/ONLINELOG/group_2.262.1144618405'
ORA-00312: online log 2 thread 1: '+ARCH/ORCL/ONLINELOG/group_2.257.1144618413'

日志报错
Errors in file /home/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_arc1_702.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 104857600 bytes disk space from 10737418240 bytes limit
ARC1 (PID:702): Error 19809 Creating archive log file to '+ARCH'
ARC1 (PID:702): Stuck archiver: inactive mandatory LAD:1
ARC1 (PID:702): Stuck archiver condition declared
2023-11-03T01:45:26.976548+08:00
Errors in file /home/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_arc0_698.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 174063616 bytes disk space from 10737418240 bytes limit
2023-11-03T01:45:26.976593+08:00
ARC0 (PID:698): Error 19809 Creating archive log file to '+ARCH'
2023-11-03T01:45:27.103230+08:00

处理过程：
SQL> startup mount
ORACLE instance started.

Total System Global Area 1.0033E+10 bytes
Fixed Size                  8935488 bytes
Variable Size            1711276032 bytes
Database Buffers         8287944704 bytes
Redo Buffers               24616960 bytes
Database mounted.
SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +ARCH
db_recovery_file_dest_size           big integer 10G
recovery_parallelism                 integer     0
remote_recovery_file_dest            string

问题原因是归档日志大小超过了闪回区的大小重启rac db时无法应用日志从而报错

增加闪回区大小
SQL> alter system set db_recovery_file_dest_size=50G;

System altered.

SQL> alter database open;

Database altered.