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]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 filesORA-limitARC0: Error ‘/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;NAMETYPE VALUE———————————— ———– ——————————background_dump_deststring /oracle/app/oracle/diag/rdbms/strora/strora/traceSQL>SQL> archive log list;Database log modeArchive ModeAutomatic archivalEnabledArchive destinationUSE_DB_RECOVERY_FILE_DESTOldest online log sequence280Next log sequence to archive 280Current log sequence282SQL>
可以看到归档日志的位置是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 52080363520143SQL>
然后就可以增加db_recovery_file_dest_size
SQL> alter system set db_recovery_file_dest_size=16G;System altered.SQL>
发光并非太阳的专利，你也可以发光
