Forum Stats

  • 3,769,805 Users
  • 2,253,023 Discussions
  • 7,875,211 Comments

Discussions

Register extract doesn't return the SCN

cptkirksh
cptkirksh Member Posts: 83 Red Ribbon
edited May 3, 2021 8:55PM in GoldenGate

Running GG MA 19.1.0.0.4 and I was in the adminclient creating an extract. In the past, after I add the extract then register the extract it usually returns the SCN. I don't get that anymore. Any idea why? The extract gets added according to the alert log and a query of select CAPTURE_NAME,CAPTURE_USER,FIRST_SCN from dba_capture and i can get the SCN there so I am just curious what I did wrong. thanks.


here is something i used to get. I took this from the documentation


OGG (https://phoenix.oggdevops.us:9100 Phoenix as oggadmin) 3> add extract EXTPRIM integrated tranlog begin now
2018-03-16T13:37:07Z  INFO    OGG-08100  EXTRACT (Integrated) added.

OGG (https://phoenix.oggdevops.us:9100 Phoenix as oggadmin) 4> register extract EXTPRIM database
2018-03-16T13:37:30Z  INFO    OGG-02003  Extract EXTPRIM successfully registered with database at SCN 1608891.