国内最全IT社区平台 联系我们 | 收藏本站
阿里云优惠2流量王
您当前位置:首页 > 数据库 > 数据库应用 > DBCA出错:ORA-19809: limit exceeded for recovery files处理过程

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

来源:程序员人生   发布时间:2016-03-01 08:40:21 阅读次数:918次

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,解决方案之1rman删除旧归档

进入rman删除旧的归档日志

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

3,解决方案之2扩大归档空间限制

首先找到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>
生活不易,码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
程序员人生
------分隔线----------------------------
分享到:
------分隔线----------------------------
关闭
程序员人生