容灾环境有套系统，要去测东西，发现数据库卡了，shutdown immediate很久了没反应。
再打了一个窗口，shtudown abort关掉了，但总感觉哪里不对。再次startup的时候悲剧了
去alert日志看看，发现：
Errors in file
/u01/app/oracle/diag/rdbms/fsscdbadg/fsscdbadg/trace/fsscdbadg_ora_16747.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 107374182400 bytes is 99.78% used, and has 236923904 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/fast_recovery_area/FSSCDBADG/archivelog/2022_04_01/o1_mf_1_236_%u_.arc'
Errors in file
/u01/app/oracle/diag/rdbms/fsscdbadg/fsscdbadg/trace/fsscdbadg_ora_16747.trc:
ORA-16038: log 6 sequence# 236 cannot be
archived
ORA-19809: limit exceeded for recovery
files
ORA-00312: online log 6 thread 1:
'/u01/app/oracle/oradata/fsscdbadg/dataredo/group_6.278.1035363745'
ORA-00312: online log 6 thread 1:
'/u01/app/oracle/oradata/fsscdbadg/fraredo/group_6.1214.1035363745'
USER (ospid: 16747): terminating the
instance due to error 16038
System state dump requested by (instance=1,
osid=16747), summary=[abnormal instance termination].
System State dumped to trace file
/u01/app/oracle/diag/rdbms/fsscdbadg/fsscdbadg/trace/fsscdbadg_diag_16713_20220401100310.trc
Dumping diagnostic data in
directory=[cdmp_20220401100310], requested by (instance=1, osid=16747),
summary=[abnormal instance termination].
Instance terminated by USER, pid = 16747
上面的黑体字看到没，归档的空间满了。这个是oracle限制的。其实磁盘还有空间的。
共100G，再加大
alter system set db_recovery_file_dest_size
= 120G;
此时日志发现：
此时，再去open，终于正常了
虽然很简单，但纪录一下。首发墨天轮。
