数据库启动发现报错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';
清理后发现磁盘空间使用下降
