Re: GoldenGate "in recovery" question regarding time left?
Date: Wed, 6 Feb 2019 19:20:29 +0000
Message-ID: <DM6PR01MB391444B08DC0999C6FD223FACE6F0_at_DM6PR01MB3914.prod.exchangelabs.com>
Chris, I do not use GG but can you see the Transaction in the target database? If yes, then you can make an estimate by counting the change in V$TRANSACTION.USED_UBLK over a known period of time.
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Chris Taylor <christopherdtaylor1994_at_gmail.com> Sent: Wednesday, February 6, 2019 12:59 PM To: ORACLE-L
Subject: GoldenGate "in recovery" question regarding time left?
For GoldenGate we had an abend during a long running transaction. Is there a way to determine how long the recovery is going to take?
We're on GG 12.3.0.1 using integrated extract/replicat.
I'm familiar with the basic commands (status, info etc) but I'm not sure how to determine "how long" the recovery is expected to take.
Any thoughts?
Chris
DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA. DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 06 2019 - 20:20:29 CET