Fw: 10.2.0.4 Logical StdBy Hung SQL Apply
Date: Thu, 26 May 2011 21:12:33 -0500
Message-ID: <OF8CA0FFA1.5F2C6D13-ON8625789D.000BD89C-8625789D.000C1FFD_at_austinisd.org>
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_at_freelists.org Cc: oracle-l-bounce_at_freelists.org 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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 26 2011 - 21:12:33 CDT