Solutions for archiving logs caused by too small flash_recovery_area

Source: Internet
Author: User


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 ".

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.