您當前位置：首頁 > 數據庫 > 數據庫應用 > DBCA出錯：ORA-19809: limit exceeded for recovery files處理過程

DBCA出錯：ORA-19809: limit exceeded for recovery files處理過程

來源：程序員人生發布時間：2016-03-01 08:40:21 閱讀次數：3343次

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>

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
程序員人生