Solutions for archiving logs caused by too small flash_recovery_area

Processing Solution for archiving logs due to too small flash_recovery_area: [SQL] 14:13:26 sys @ ORCL (^ ω ^) select * from v $ version where rownum = 1; www.2cto.com BANNER issue Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod the problem is that a Test Library has not been cleaned up since its installation. [SQL] 13:54:29 idle (^ ω ^) startup ORA-01081: unable to start a running ORACLE-Close it first 13:54:47 idle (^ ω ^) shutdown abort ORACLE routine has been closed. Www.2cto.com 13:55:06 idle (^ ω ^) startup ORACLE routine has been started. Total System Global Area 612368384 bytes Fixed Size 1250428 bytes Variable Size 205523844 bytes Database Buffers 398458880 bytes Redo Buffers 7135232 bytes Database load is complete. ORA-16038: log 3 serial number 48 unable to archive ORA-19809: exceeds the limit on the number of recovery files ORA-00312: Online log 3 thread 1: 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ ONLINELOG \ ow.mf_3_7tqzwzoy_.log 'ORA-00312: Online log 3 thread 1: www.2cto.com 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ FLASH_RECOVERY_AREA \ ORCL \ ONLINELOG \ mongoog 'does not fl the archived logs accumulated over years to SBT, resulting in pressure on the flash_recovery_area space and the new archive cannot be added. [SQL] 13:59:27 idle (^ ω ^) alter database clear unarchived logfile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ ONLINELOG \ O1_MF_3_7TQZWZOY_.LOG '; alter database clear unarchived logfile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ ONLINELOG \ O1_MF_3_7TQZWZOY_.LOG '* row 1st error: ORA-01514: Error in log description: there is no such log ORA-01517: log Member: 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ ONLINELOG \ O1_MF_3_7TQZWZOY_.LOG 'manual clearing of Unarchived logs directly reports an error. [SQL] 14:00:37 idle (^ ω ^) archive log start; processed statement www.2cto.com 14:05:24 idle (^ ω ^) archive log next; ORA-16014: log 3 serial number 48 not archived, no available destination ORA-00312: Online log 3 thread 1: 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ ONLINELOG \ O1_MF_3_7TQZWZOY_.LOG 'ORA-00312: Online log 3 thread 1: 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ FLASH_RECOVERY_AREA \ ORCL \ ONLINELOG \ O1_MF_3_7TQZX11D_.LOG '14:05:34 idle (^ ω ^) show parameter db_recover NAME TYPE Export ---------------------- VALUE export db_recovery_file_dest string D: \ oracle \ product \ 10.2.0/flash _ recovery_area too big integer 3G 14:06:09 idle (^ ω ^) alter system set db_recovery_file_dest_size = 4g; the system has been changed. Www.2cto.com 14:06:51 idle (^ ω ^) archive log next; a log has been archived. 14:07:18 idle (^ ω ^) alter database open; the database has been changed. Recovery is complete. Summary: The problem caused by flash_recovery_area congestion in the production database may be more complicated. We need to "Clean Up" it every other day ".