DBCA出错：ORA-19809: limit exceeded for recovery files处理过程

最新推荐文章于 2025-09-14 15:05:09 发布

原创最新推荐文章于 2025-09-14 15:05:09 发布 · 1w 阅读

0 ·

CC 4.0 BY-SA版权

oracle problem 专栏收录该内容

61 篇文章

订阅专栏

本文介绍了解决Oracle数据库归档日志空间不足的问题，包括通过RMAN删除旧归档日志和扩大归档空间限制的方法。详细步骤涉及使用RMAN命令删除不必要的归档日志，并通过调整db_recovery_file_dest_size参数来增加归档空间。

1，dbca建库后台报错问题描述

[root@companydb1 rpms]# find / -name *alert*log
/mnt/resource/app/oracle/diag/rdbms/strora/strora/trace/alert_strora.log
/mnt/resource/app/oracle/product/11.2.0/dbhome_1/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
/mnt/resource/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/oc4j_applications/applications/em/em/database/instance/alertlog
[root@companydb1 rpms]# tail -f /mnt/resource/app/oracle/diag/rdbms/strora/strora/trace/alert_strora.log
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.
************************************************************************
Errors in file /oracle/app/oracle/diag/rdbms/strora/strora/trace/strora_arc0_17846.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 15883776 bytes disk space from 5218762752 limit
ARC0: Error 19809 Creating archive log file to '/oracle/app/oracle/flash_recovery_area/strora/archivelog/2015_10_21/o1_mf_1_280_%u_.arc'
^C
[root@companydb1 rpms]#

2，解决方案之一rman删除旧归档

进入rman删除旧的归档日志

RMAN> delete archivelog all;
RMAN> crosscheck archivelog all;

3，解决方案之二扩大归档空间限制

首先找到archive文件的位置

SQL> show parameter background_dump_dest;                                                                                                                                                                                                                                     
                                                                                                                                                                                                                                                                              
NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest		     string	 /oracle/app/oracle/diag/rdbms/
						 strora/strora/trace
SQL>

SQL> archive log list;                                                                                                                                                                                                                                                        
Database log mode              Archive Mode                                                                                                                                                                                                                                   
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     280
Next log sequence to archive   280
Current log sequence	       282
SQL>

可以看到归档日志的位置是DB_RECOVERY_FILE_DEST，精确路径也可以查到

查看空间使用情况：

SQL> SELECT * FROM V$RECOVERY_FILE_DEST;                                                                                                                                                                                                                                      
                                                                                                                                                                                                                                                                              
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/oracle/app/oracle/flash_recovery_area
 5218762752 5208036352		       0	     143


SQL>

然后就可以增加db_recovery_file_dest_size

SQL>  alter system set db_recovery_file_dest_size=16G;                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                              
System altered.

SQL>