Comments

  1. Hi Mr. Natik,
    Thanks for all your helpful replies :), I have a problem with the data pump extract ,the problem is that the trail files arrived at the destination empty! only with 2KB size ,I deleted the extract and add another one but no change , I did info extPmp detail to be sure if it reads from the source trail files and I get that it reads from the correct source trail files also there are statistics of operations when I did stats extPmp!
    Really I didnt know what is the problem ?
    Thanks 🙂

    • Hi Aziz,

      Can you please give me the output for the following?

      1. INFO extract extract_name
      2. STATS extract extract_name

      3. INFO pump_name
      4. STATS extract pump_name

      5. ls -lrt {extract trail files} <-- On Source database extract trail location 6. ls -lrt {extract trail files} <-- On target database pumped file trail location 7. INFO replicat_name 8. STATS replicat_name

  2. Hi sir, i am new to goldengate and i am configuring DDL replication , my dp process is running but it could not read from trail file .please find the out put as below…..please help me

    ****

    GGSCI (vm2) 43> send extract emaster status

    Sending STATUS request to EXTRACT EMASTER …

    EXTRACT EMASTER (PID 21576)
    Current status: Recovery complete: At EOF

    Current read position:
    Redo thread #: 1
    Sequence #: 248
    RBA: 16030208
    Timestamp: 2016-09-01 09:12:30.000000
    SCN: 0.1641958
    Current write positions:
    Sequence #: 5
    RBA: 1066
    Timestamp: 2016-09-01 05:53:53.392574
    Extract Trail: ./dirdat/st

    Sequence #: 1
    RBA: 1066
    Timestamp: 2016-09-01 08:44:56.666471
    Extract Trail: ./dirdat/ps

    Sequence #: 1
    RBA: 1066
    Timestamp: 2016-09-01 09:12:28.505506
    Extract Trail: ./dirdat/xx

    ****************************
    GGSCI (vm2) 44> send extract dpmastr status

    Sending STATUS request to EXTRACT DPMASTR …

    EXTRACT DPMASTR (PID 21575)
    Current status: Recovery complete: At EOF

    Current read position:
    Sequence #: 0
    RBA: 0
    Timestamp: 2016-08-26 19:38:58.000000
    Extract Trail: /u01/GG/home/dirdat/xs

    Current write positions:
    Sequence #: 0
    RBA: 0
    Timestamp: 2016-08-26 19:40:05.810390
    Extract Trail: /u01/GG/home/dirdat/ps

    Sequence #: 0
    RBA: 0
    Timestamp: 2016-09-01 09:13:58.474717
    Extract Trail: ./dirdat/ps

    *********
    GGSCI (vm2) 45> info emaster

    EXTRACT EMASTER Last Started 2016-09-01 09:02 Status RUNNING
    Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
    Log Read Checkpoint Oracle Redo Logs
    2016-09-01 09:17:23 Seqno 248, RBA 16054272
    SCN 0.1642094 (1642094)

    GGSCI (vm2) 46> info dpmastr

    EXTRACT DPMASTR Last Started 2016-09-01 09:02 Status RUNNING
    Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
    Log Read Checkpoint File /u01/GG/home/dirdat/xs000000
    2016-08-26 19:38:58.000000 RBA 0

    GGSCI (vm2) 47> SEND EXTRACT SHOWTRANS
    ERROR: No Command for SEND.

    GGSCI (vm2) 48> info extract emaster

    EXTRACT EMASTER Last Started 2016-09-01 09:02 Status RUNNING
    Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
    Log Read Checkpoint Oracle Redo Logs
    2016-09-01 09:27:42 Seqno 248, RBA 16075776
    SCN 0.1642325 (1642325)

    GGSCI (vm2) 49> stats extract emaster

    Sending STATS request to EXTRACT EMASTER …

    No active extraction maps
    DDL replication statistics (for all trails):

    *** Total statistics since extract started ***
    Operations 0.00
    Mapped operations 0.00
    Unmapped operations 0.00
    Other operations 0.00
    Excluded operations 0.00
    .

    GGSCI (vm2) 50> info extract dpmastr

    EXTRACT DPMASTR Last Started 2016-09-01 09:02 Status RUNNING
    Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
    Log Read Checkpoint File /u01/GG/home/dirdat/xs000000
    2016-08-26 19:38:58.000000 RBA 0

    GGSCI (vm2) 51> stats extract dpmastr

    Sending STATS request to EXTRACT DPMASTR …

    No active extraction maps.

    GGSCI (vm2) 52>

Leave a Reply

Your email address will not be published.

Receive Expert Articles via Email


Database    GoldenGate