Freelists downtime (was RE: 10.2.0.4 Logical StdBy Hung SQL Apply)
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "japplewhite@xxxxxxxxxxxxx" <japplewhite@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 May 2011 11:55:28 -0400
There were definite problems with FreeLists. From my point of view, there was
an outage from 5/25 at 12:04pm, until 5/27 at 6:04am (all times US-EDT).
I tried to look into it, and even the website was down. Seems that
'freelists.org' was not resolvable in DNS. I looked on the freelists.org main
website, they don't mention anything about an outage.
-Mark
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of japplewhite@xxxxxxxxxxxxx
Sent: Thursday, May 26, 2011 10:13 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: Jared Still
Subject: Fw: 10.2.0.4 Logical StdBy Hung SQL Apply
I sent this earlier today, but haven't seen an Oracle-L posting since
yesterday. Is it just me unable to receive or are there Oracle-L problems?
Thanks.
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk) / 512.935.5929 (pager)
----- Forwarded by Jack Applewhite/AISD on 05/26/2011 09:09 PM -----
From: Jack Applewhite/AISD
To: oracle-l@xxxxxxxxxxxxx
Cc: oracle-l-bounce@xxxxxxxxxxxxx
Date: 05/26/2011 09:09 AM
Subject: 10.2.0.4 Logical StdBy Hung SQL Apply
________________________________
Hi,
It's 64 bit Oracle10g EE on 64 bit RHEL 4 Linux.
According to V$LogStdB my Builder process has been doing this for hours and
hours:
ORA-16245: paging in transaction 5, 45, 347459
I've gone through "Oracle10g Data Guard SQL Apply Troubleshooting (Doc ID
312434.1)", but nothing is revealed. I increased the SQL Apply Max_SGA from
the default of 30 MB up to 2 GB, as well as the number of Appliers. Still no
joy. No errors anywhere that I can find.
Anybody have a suggestion?
Thanks.
Jack C. Applewhite - Database Administrator
Other related posts:
- » Freelists downtime (was RE: 10.2.0.4 Logical StdBy Hung SQL Apply) - Bobak, Mark
