Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

re-position integrated extract

user9527632Feb 21 2018 — edited Feb 22 2018

my understanding is that you can re-position integrated extract  with an SCN that is greater than the "outbound server's first SCN",  however in my test, I couldn't do so as demonstrated below,  Any comments?

GGSCI  27> info yz detail

EXTRACT    YZ        Last Started 2018-02-21 14:21   Status STOPPED

Checkpoint Lag       00:00:04 (updated 00:01:12 ago)

Log Read Checkpoint  Oracle Integrated Redo Logs

                     2018-02-21 14:42:43

                     SCN 371.299753222 (1593732620038)

Target Extract Trails:

Trail Name                                       Seqno        RBA     Max MB Trail Type

  ./dirdat/dirrep/YZ                                   3       4904        100 EXTTRAIL

Integrated Extract outbound server first scn: 371.291164357 (1593724031173)

Integrated Extract outbound server filtering start scn: 371.291164357 (1593724031173)

GGSCI  28> alter extract yz scn 1593728150149

ERROR: Extract YZ can not be positioned to SCN 1593728150149.

Here i use a SCN after the "first SCN" and got the error message.

If I use a SCN after the "SCN that when the extract stopped SCN 371.299753222 (1593732620038)"  I am suceessful

GGSCI > alter extract yz scn 1593737487500

EXTRACT altered.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2018
Added on Feb 21 2018
2 comments
490 views