您當(dāng)前位置：首頁(yè) > 數(shù)據(jù)庫(kù) > 數(shù)據(jù)庫(kù)應(yīng)用 > DBCA出錯(cuò)：ORA-19809: limit exceeded for recovery files處理過(guò)程

DBCA出錯(cuò)：ORA-19809: limit exceeded for recovery files處理過(guò)程

來(lái)源：程序員人生發(fā)布時(shí)間：2016-03-01 08:40:21 閱讀次數(shù)：3334次

1，dbca建庫(kù)后臺(tái)報(bào)錯(cuò)問(wèn)題描寫

[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刪除舊歸檔

進(jìn)入rman刪除舊的歸檔日志

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

3，解決方案之2擴(kuò)大歸檔空間限制

首先找到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>

生活不易，碼農(nóng)辛苦
如果您覺(jué)得本網(wǎng)站對(duì)您的學(xué)習(xí)有所幫助,可以手機(jī)掃描二維碼進(jìn)行捐贈(zèng)
程序員人生