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

[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]#

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

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>

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>

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