RE: Can't get GG Extract restarted

Also…

Ggsci> info <extract>, detail

You might can just

Alter <extract> extseqno <from detail> ,extrba <from detail>

And try to start the extract again

Binh Le
Oracle DBA

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Sandra Becker Sent: Thursday, August 4, 2022 4:15 PM
To: oracle-l <oracle-l_at_freelists.org> Subject: Can't get GG Extract restarted

***This email is from an external source. Only open links and attachments from a Trusted Sender.***

Oracle EE 12.1.0.2
GG 12.2
RHEL 6.10 We were having issues with the EXTRACT process consuming large amounts of memory and swap to the point we had 0 swap left and 6GB of memory. This was not normal behavior. We decided to bounce the EXTRACT process. It stopped without any errors, but now it won't restart. I've searched everywhere I can think of on the error we're getting, but haven't found a solution yet. We don't have Oracle support, we use Rimini Street. I have opened a ticket with them, but no answers yet. Has anyone seen this error before:

2022-08-04 19:39:59 ERROR OGG-00446 No positions processed.

2022-08-04 19:39:59 ERROR OGG-01668 PROCESS ABENDING. I would appreciate any assistance you can provide.
--

Sandy B.
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 05 2022 - 02:58:14 CEST