由于db_recovery_file_dest_size满导致数据库无法启动

数据库启动发现报错ORA-03113无法启动

SQL> startup ;
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2260088 bytes
Variable Size             922747784 bytes
Database Buffers         3338665984 bytes
Redo Buffers               12107776 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 15766
Session ID: 232 Serial number: 3

查看日志发现db_recovery_file_dest_size空间已满，归档日志无法归档所以无法启动

启动数据库至Nomount进行修改，然后启动数据库
startup nomount;
alter system set db_recovery_file_dest_size=10G;
alter database mount;
alter database open;
show parameter db_recovery_file_dest_size;
select * from v$recovery_file_dest;

启动后使用rman将之前过期的日志进行清理
[oracle@oraclehost oracle]$ rman nocatalog

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Feb 13 12:02:36 2023

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target /

connected to target database: ORCL (DBID=1632038687)
using target database control file instead of recovery catalog

RMAN> delete archivelog all completed before 'sysdate - 30';

清理后发现磁盘空间使用下降