Forum Stats

  • 3,769,636 Users
  • 2,252,995 Discussions
  • 7,875,129 Comments

Discussions

GoldenGate Replication returns "no active replication maps"

dishon
dishon Member Posts: 2 Blue Ribbon
edited Nov 28, 2019 6:53AM in GoldenGate

After performing a schema refresh in the source system, the extract is deleted and unregistered, then

REGISTER EXTRACT EXT_77 DATABASE

ADD EXTRACT EXT_77 INTEGRATED TRANLOG, BEGIN NOW

-- ADD TRAILFILE

ADD EXTTRAIL ./dirdat/tb, EXTRACT EXT_77, MEGABYTES 100

grab the scn, start extract, perform expdp(using scn) /impdp

Then where the problem seems to be....

INFO CREDENTIALSTORE

DBLOGIN USERIDALIAS alias

DELETE REPLICAT REP_77

ADD REPLICAT REP_77, EXTTRAIL ./dirdat/tb, CHECKPOINTTABLE OGG_NPD.GGSCHKPT_TSTB

START REP_77, AFTERCSN xxxxx

EXT and REP are running, yet nothing is updating.  running stats rep-77  reveals "No active replication maps".

Nothing changes in any of the parameters files, so I am stymied as to what I am missing.

Anyone experience this?

Thanks in advance!

Answers

  • K.Gan
    K.Gan Member Posts: 2,707 Bronze Crown
    edited Nov 23, 2019 8:09PM

    First, check if the extract captures anything.

    ggsci> stats ext_77

    If there isn't anything, the application team might have changed the tables' names/schema.

    If there are stats data, check that the replicat param MAPs to the right source and target.

    Lastly, make sure that privilege access hasn't changed.

    You said that nothing on the OGG configuration changed because if extract writes to a different trail from what the replicat is reading nothing is going to happen.

    Cheers

    Kee Gan

  • dishon
    dishon Member Posts: 2 Blue Ribbon
    edited Nov 25, 2019 12:52PM

    Thank you for responding.

    Here is the bottom of

    ggsci > stats ext_77  (clearly working as expected)

    Extracting from SYSADM.PS_PTAI_LIST to SYSADM.PS_PTAI_LIST:

    *** Total statistics since 2019-11-22 08:14:11 ***

            Total inserts                                      1.00

            Total updates                                      0.00

            Total deletes                                      1.00

            Total discards                                     0.00

            Total operations                                   2.00

    *** Daily statistics since 2019-11-25 00:00:00 ***

            Total inserts                                      1.00

            Total updates                                      0.00

            Total deletes                                      1.00

            Total discards                                     0.00

            Total operations                                   2.00

    *** Hourly statistics since 2019-11-25 12:00:00 ***

            Total inserts                                      1.00

            Total updates                                      0.00

            Total deletes                                      1.00

            Total discards                                     0.00

            Total operations                                   2.00

    *** Latest statistics since 2019-11-22 08:14:11 ***

            Total inserts                                      1.00

            Total updates                                      0.00

            Total deletes                                      1.00

            Total discards                                     0.00

            Total operations                                   2.00

    I did find where the dba role was not added to the target alias user.  I added that then stop/started the replicat and still nothing. 

    Here is the information (detail) on both ext/replicat.

    GGSCI (oggnpd201.ad.uc.edu) 3> info ext_77 detail

    EXTRACT    EXT_77    Last Started 2019-11-22 08:11   Status RUNNING

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

    Process ID           9084

    Log Read Checkpoint  Oracle Integrated Redo Logs

                         2019-11-25 12:49:01

                         SCN 4.2942829012 (20122698196)

      Target Extract Trails:

      Trail Name                                       Seqno        RBA     Max MB Trail Type

      ./dirdat/tb                                         24      83655        100 EXTTRAIL

    Integrated Extract outbound server first scn: Unavailable.Need DBLOGIN.

    Integrated Extract outbound server filtering start scn: Unavailable.Need DBLOGIN.

      Extract Source                          Begin             End

      Not Available                           2019-11-22 08:07  2019-11-25 12:49

      Not Available                           * Initialized *   2019-11-22 08:07

      Not Available                           * Initialized *   2019-11-22 08:07

    Current directory    /u01/app/oracle/product/12.2.0.1/ogg1

    Report file          /u01/app/oracle/product/12.2.0.1/ogg1/dirrpt/EXT_77.rpt

    Parameter file       /u01/app/oracle/product/12.2.0.1/ogg1/dirprm/ext_77.prm

    Checkpoint file      /u01/app/oracle/product/12.2.0.1/ogg1/dirchk/EXT_77.cpe

    Process file         /u01/app/oracle/product/12.2.0.1/ogg1/dirpcs/EXT_77.pce

    Error log            /u01/app/oracle/product/12.2.0.1/ogg1/ggserr.log

    REPLICAT:

    GGSCI (oggnpd201.ad.uc.edu) 4> info rep_77 detail

    REPLICAT   REP_77    Last Started 2019-11-22 09:48   Status RUNNING

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

    Process ID           17666

    Log Read Checkpoint  File ./dirdat/tb000000000

                         First Record  RBA 0

    Current Log BSN value: (requires database login)

    Last Committed Transaction CSN value: (requires database login)

      Extract Source                          Begin             End

      ./dirdat/tb000000000                    * Initialized *   First Record

      ./dirdat/tb000000000                    * Initialized *   First Record

    Current directory    /u01/app/oracle/product/12.2.0.1/ogg1

    Report file          /u01/app/oracle/product/12.2.0.1/ogg1/dirrpt/REP_77.rpt

    Parameter file       /u01/app/oracle/product/12.2.0.1/ogg1/dirprm/rep_77.prm

    Checkpoint file      /u01/app/oracle/product/12.2.0.1/ogg1/dirchk/REP_77.cpr

    Checkpoint table     OGG_NPD.GGSCHKPT_TSTB

    Process file         /u01/app/oracle/product/12.2.0.1/ogg1/dirpcs/REP_77.pcr

    Error log            /u01/app/oracle/product/12.2.0.1/ogg1/ggserr.log

    Any red flags here?

    Thank you again, for responding.

  • K.Gan
    K.Gan Member Posts: 2,707 Bronze Crown
    edited Nov 25, 2019 4:11PM

    Your replicat is pointing to the wrong sequence.

    REPLICAT   REP_77    Last Started 2019-11-22 09:48   Status RUNNING

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

    Process ID           17666

    Log Read Checkpoint  File ./dirdat/tb000000000

                         First Record  RBA 0

    Whereas the extract is writing at sequence 24

      Target Extract Trails:

      Trail Name                                       Seqno        RBA     Max MB Trail Type

      ./dirdat/tb                                         24      83655        100 EXTTRAIL

    stop <rep>

    Alter <rep>, extseqno 24, extrba 0  (or whatever rba you want to start).

    start <rep>

    Cheers

    Kee

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy
    edited Nov 28, 2019 6:53AM

    Hi Dishon,

    The replicat is trying to read the trail file  ./dirdat/tb000000000

    REPLICAT   REP_77    Last Started 2019-11-22 09:48   Status RUNNING

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

    Process ID           17666

    Log Read Checkpoint  File ./dirdat/tb000000000  ---------------------> replicat is reading this file

                         First Record  RBA 0

    Whether the trail file tb000000000 exists in the system? Do an ls -lrt and check that first. The Extract process might have processed records and moved further, but the replicat process might have been stuck.

    Regards,

    Veera

  • Hi

    Even I am facing the same issue. I have verified in target folder the trail file is visible but the data is not replicating in the database

    stating message like

    NO active replication maps

    Could you please help me out

  • User_M196G
    User_M196G Member Posts: 1 Green Ribbon

    Might be best to open a ticket with Oracle support. They are usually quick to repsond to issues like this.