ORA-19815报错解决方法

ZhangQi

查看某一个数据库告警日志，报错信息如下：

2025-08-25T22:15:36.575562+08:00

Errors in file /home/oracle/app/oracle/diag/rdbms/jlpspd/jlpspd/trace/jlpspd_m003_4174555.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of10737418240 bytes is 98.16% used, and has 198004224 remaining bytes available.

2025-08-26T01:15:42.721262+08:00

Errors in file/home/oracle/app/oracle/diag/rdbms/jlpspd/jlpspd/trace/jlpspd_m004_1858364.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of10737418240 bytes is 91.48% used, and has 914929152 remaining bytes available.

2025-08-26T22:16:33.537872+08:00

Errors in file/home/oracle/app/oracle/diag/rdbms/jlpspd/jlpspd/trace/jlpspd_m003_4174555.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of10737418240 bytes is 99.95% used, and has 4847616 remaining bytes available.

2025-08-26T22:16:33.537949+08:00

************************************************************************

You have following choices to free up space from recoveryarea:

1. Consider changing RMAN RETENTION POLICY. If you areusing Data Guard,

   then considerchanging RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such as tape using RMAN

   BACKUP RECOVERYAREA command.

3. Add disk space and increase db_recovery_file_dest_sizeparameter to

   reflect the newspace.

4. Delete unnecessary files using RMAN DELETE command. Ifan operating

   system command wasused to delete files, then use RMAN CROSSCHECK and

   DELETE EXPIREDcommands.

************************************************************************


原因：归档文件储存在快速恢复区（FRA）中，空间即将用尽，已多次触发空间不足警告


解决方法：参考报警日志给出的建议方式，这里选择通过RMAN备份或删除过期文件以释放空间

在这里，已通过定制RMAN备份脚本自动清理了过期备份及7天前的归档日志，并完成了数据备份，后续不再报错


脚本如下所示：

登录/注册后可看大图