Oracle bug-6704410

Source: Internet
Author: User
Tags metalink

The logical standby architecture was completed yesterday and runs in the maximum performance mode of the default mode. When trying to change to the maximum available mode today, the primary database reports the following error. No answer was found on Google or Baidu. A query on Metalink found a record, saying that Oracle's bug. Oracle still does not provide the correction program, nor does it solve the problem, but also returns the maximum performance mode.
The error is as follows:
Lgwr: Error 4030 disconnecting from destination log_archive_dest_2 standby host 'its'
Tue Feb 05 13:12:36 2008
Errors in file D: \ It \ dump \ bdump \ it_lgwr_3508.trc:
ORA-04030: Out of process memory when trying to allocate bytes (,)

Lgwr: Error 4030 creating archivelog file 'its'
Lgwr: failed to archive log 1 thread 1 sequence 35 (4030)
Thread 1 advanced to log sequence 35

The original Metalink text is as follows:
Bug no. 6704410
Filed 19-dec-2007 updated 24-Jan-2008
Product ORACLE Server-Enterprise Edition product version 10.2.0.3
Platform Microsoft Windows Server 2003 R2 (64-bit amd64 and Intel em64t) platform version no data
Database Version 10.2.0.3 affects platforms generic
Severity severe loss of service status duplicate bug. To filer
Base bug 5618471 fixed in Product Version no data

Problem Statement:

RFS process acquire huge memory.
--------------------------------------------------------------------------------


* ** 12/19/07 am *** tar :----. problem: -------- in customer's site, when instance of primary node 2 starts up, RFS process acquire huge memory .. -- result of V $ sesstat. spid program SID Name Memory ------ ------------------ --------------------------- ---------- 7152 oracle. EXE (shad) 410 session PGA memory 2284412296 <-- 7152 oracle. EXE (shad) 410 session PGA memory Max 2284412296 7152 oracle. EXE (shad) 410 session UGA memory 158464 7152 oracle. EXE (shad) 410 session UGA memory Max 158464. moreover, lgwr of primary nodes face the following error and lgwr can not transfer redo log .. fri Dec 07 22:09:15 2007 lgwr: Error 4030 disconnecting from destination log_archive_dest_2 standby host 'life _ Dr 'Fri Dec 07 22:09:15 2007 errors in file .... ORA-04030 :..... diagnostic Analysis :--------------------. workaround: ----------- N/. related bugs :-------------. reproducibility :----------------. test Case: ---------- N/. stack trace :------------. supporting information :-----------------------. 24 hour contact information for P1 bugs :----------------------------------------. dial-in information :--------------------. impact Date :------------. * ** 12/19/07 am ***** 12/19/07 pm *** (chg: sta-& gt; 16) * ** 12/19/07 pm *** (chg: ASG-& gt; new owner) *** 12/21/07 am *** (chg: sta-& gt; 10) *** 12/21/07 am *** 01/14/08 PM *** (chg: sta-& gt; 16) * ** 01/14/08 PM ****** 01/15/08 PM *** (chg: sta-& gt; 10) * ** 01/15/08 PM ****** 01/20/08 PM *** (chg: sta-& gt; 16) * ** 01/20/08 PM ****** 01/20/08 PM *** (chg: sta-& gt; 11 subcomp-& gt; dataguard_psby) * ** 01/20/08 PM ****** 01/20/08 PM ****** 01/20/08 PM ***** (add: impact/symptom-& gt; memory/other resourc... * ** 01/20/08 PM ***** 01/20/08 PM *** (chg: ASG-& gt; new owner) * ** 01/20/08 PM ***** 01/21/08 AM *** (chg: Confirmed flag-& gt; y) * ** 01/21/08 AM *** (chg: ASG-& gt; new owner) * ** 01/21/08 AM ****** 01/23/08 AM ****** 01/23/08 AM ****** 01/24/08 AM ******/08 am ****** 01/24/08 AM **** (chg: sta-& gt; 36) *** 01/24/08 AM *** 01/24/08 AM ***

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.