Forum Stats

  • 3,874,832 Users
  • 2,266,778 Discussions
  • 7,911,973 Comments

Discussions

Moving GoldenGate Binaries to a different location

user13471596
user13471596 Member Posts: 12
edited Feb 24, 2011 5:58PM in GoldenGate
I am moving my GG binaries from /u05/GG to /gg/GG now the problem is exttrial is still looking for old directory path even though I have modified the extract parameter file with the right location. Do you know how can I re point it to new location.

Below are the steps I performed.

Stop everything on old location

Cd /u05/oradata/GG
./ggsci
GGSCI (ggastdb01.infra.mms) 6> stop *
GGSCI (ggastdb01.infra.mms) 12> stop manager
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.

Modified the parameter file

Vi /u05/oradata/GG/dirprm/e_sm07d.prm

Change EXTTRAIL /u05/oradata/GG/dirdat/sa to EXTTRAIL /gg/GG/dirdat/sa

Copy the binaries to new location

Cp –r / u05/oradata/GG /gg/

Cd /gg/GG
./ggsci
GGSCI (ggastdb01.infra.mms) 2> start manager
Manager started.

GGSCI (ggastdb01.infra.mms) 3> start e_sm07d

Sending START request to MANAGER ...
EXTRACT E_SM07D starting

ERROR:

011-02-23 10:31:17 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start e_sm07d.
2011-02-23 10:31:17 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 15.224.209.113 (START EXTRACT E_SM07D ).
2011-02-23 10:31:18 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT E_SM07D starting.
2011-02-23 10:31:19 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, e_sm07d.prm: EXTRACT E_SM07D starting.
2011-02-23 10:31:20 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, e_sm07d.prm: Positioning to Sequence 11451, RBA 117264.
2011-02-23 10:31:23 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, e_sm07d.prm: Positioned to Sequence 11451, RBA 117264, Feb 23, 2011 9:26:15 AM.
2011-02-23 10:31:23 ERROR OGG-01044 Oracle GoldenGate Capture for Oracle, e_sm07d.prm: The trail '/gg/GG/dirdat/sa' is not assigned to extract 'E_SM07D'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL /gg/GG/dirdat/sa, EXTRACT E_SM07D.
2011-02-23 10:31:23 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, e_sm07d.prm: PROCESS ABENDING.

Answers

  • stevencallan
    stevencallan Member Posts: 3,459
    The error message output shows this:

    ADD EXTTRAIL/RMTTRAIL /gg/GG/dirdat/sa, EXTRACT E_SM07D

    Right now, the manager thinks the extract E_SM07D is linked to the old path. You need to tell manager about the new path (it's more than just the parameter file that needs to be updated). You can drop the extract and re-add it.
  • Thanks,Yes I was thinking of the same I am able to start the extract but In case of replicat what I need to do.
    Do you think this will work. " Add RMTTRAIL /gg/GG/dirdat/sa, REPLICAT r_sm07d " does it will start the reading /gg/GG/dirdat/sa000019 it self ?


    Below is the error when I start the replicat with out any change.

    GGSCI (ggastdb01.infra.mms) 47> info r_sm07d

    REPLICAT R_SM07D Last Started 2011-02-23 14:13 Status ABENDED
    Checkpoint Lag 00:00:00 (updated 04:46:37 ago)
    Log Read Checkpoint File /u05/oradata/GG/dirdat/sa000019
    2011-02-23 09:16:14.000000 RBA 16292

    GGSCI (ggastdb01.infra.mms) 46> start r_sm07d

    Sending START request to MANAGER ...
    REPLICAT R_SM07D starting

    Error:

    011-02-23 14:13:32 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT R_SM07D starting.
    2011-02-23 14:13:32 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D starting.
    2011-02-23 14:13:32 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: SQL statement executed successfully.
    2011-02-23 14:13:32 WARNING OGG-00445 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: Detected migrated group R_SM07D, updating DB checkpoint dir from /u05/oradata/GG to /gg/GG.
    2011-02-23 14:13:32 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D started.
    2011-02-23 14:13:32 ERROR OGG-01091 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: Unable to open file "/u05/oradata/GG/dirdat/sa000019" (error 2, No such file or directory).
    2011-02-23 14:13:32 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: PROCESS ABENDING.
  • I tried below to start the replicat as it was also looking for the old location. Please correct me if I am doing any step wrong. The problem I see with this is replicat was looking for sequence no sa000019 but extract already move to sa000020.

    GGSCI (ggastdb01.infra.mms) 53> alter replicat r_sm07d, exttrail /gg/GG/dirdat/sa
    REPLICAT altered.


    GGSCI (ggastdb01.infra.mms) 54> start r_sm07d

    GGSCI (ggastdb01.infra.mms) 55> info r_sm07d

    REPLICAT R_SM07D Last Started 2011-02-23 14:26 Status RUNNING
    Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
    Log Read Checkpoint File /gg/GG/dirdat/sa000000
    First Record RBA 0


    GGSCI (ggastdb01.infra.mms) 56> ALTER REPLICAT r_it852d, EXTSEQNO 000019, EXTRBA 16292
    REPLICAT altered.


    GGSCI (ggastdb01.infra.mms) 57> info r_sm07d

    REPLICAT R_SM07D Last Started 2011-02-23 14:26 Status RUNNING
    Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
    Log Read Checkpoint File /gg/GG/dirdat/sa000000
    First Record RBA 0

    GGSCI (ggastdb01.infra.mms) 59> ALTER REPLICAT r_sm07d, EXTSEQNO 000019, EXTRBA 16292
    REPLICAT altered.


    GGSCI (ggastdb01.infra.mms) 60> start r_sm07d

    GGSCI (ggastdb01.infra.mms) 61> info r_sm07d

    REPLICAT R_SM07D Last Started 2011-02-23 14:29 Status ABENDED
    Checkpoint Lag 00:00:00 (updated 00:00:20 ago)
    Log Read Checkpoint File /gg/GG/dirdat/sa000019
    First Record RBA 16292

    GGSCI (ggastdb01.infra.mms) 1> info exttrail *

    Extract Trail: /u05/oradata/GG/dirdat/sa
    Extract: E_SM07D
    Seqno: 19
    RBA: 214073
    File Size: 500M
    Extract Trail: /gg/GG/dirdat/sa
    Extract: E_SM07D
    Seqno: 20
    RBA: 6140736
    File Size: 10M

    sa000019 was not there any more and it change it to sa000020

    GGSCI (ggastdb01.infra.mms) 62> ALTER REPLICAT r_sm07d, EXTSEQNO 000020, EXTRBA 16292
    REPLICAT altered.

    GGSCI (ggastdb01.infra.mms) 64> info r_sm07d
    REPLICAT R_SM07D Last Started 2011-02-23 14:34 Status ABENDED
    Checkpoint Lag 00:00:00 (updated 00:00:15 ago)
    Log Read Checkpoint File /gg/GG/dirdat/sa000020
    First Record RBA 16292





    2011-02-23 14:26:31 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D started.
    2011-02-23 14:27:58 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ALTER REPLICAT r_it852d EXTSEQNO 000019, EXTRBA 16292.
    2011-02-23 14:28:19 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop r_sm07d.
    2011-02-23 14:28:21 INFO OGG-01021 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: Command received from GGSCI: STOP.
    2011-02-23 14:28:21 INFO OGG-00994 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D stopped normally.
    2011-02-23 14:29:04 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ALTER REPLICAT r_sm07d EXTSEQNO 000019, EXTRBA 16292.
    2011-02-23 14:29:11 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start r_sm07d.
    2011-02-23 14:29:11 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 15.224.209.113 (START REPLICAT R_SM07D ).
    2011-02-23 14:29:11 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT R_SM07D starting.
    2011-02-23 14:29:11 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D starting.
    2011-02-23 14:29:12 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: SQL statement executed successfully.
    2011-02-23 14:29:12 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D started.
    2011-02-23 14:29:12 ERROR OGG-01091 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: Unable to open file "/gg/GG/dirdat/sa000019" (error 2, No such file or directory).
    2011-02-23 14:29:12 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: PROCESS ABENDING.
    2011-02-23 14:34:03 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ALTER REPLICAT r_sm07d EXTSEQNO 000020, EXTRBA 16292.

    2011-02-23 14:34:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start r_sm07d.
    2011-02-23 14:34:16 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 15.224.209.113 (START REPLICAT R_SM07D ).
    2011-02-23 14:34:16 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT R_SM07D starting.
    2011-02-23 14:34:16 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D starting.
    2011-02-23 14:34:16 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: SQL statement executed successfully.
    2011-02-23 14:34:16 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: REPLICAT R_SM07D started.
    2011-02-23 14:34:37 ERROR OGG-01028 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: Incompatible record (logical EOF) in /gg/GG/dirdat/sa000020, rba 16292.
    2011-02-23 14:34:37 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r_sm07d.prm: PROCESS ABENDING.
  • stevencallan
    stevencallan Member Posts: 3,459
    You are moving trail locations and haven't kept manager up to date along the way (more like after the fact). This error:

    /gg/GG/dirdat/sa000019" (error 2, No such file or directory)

    is a good clue about that.

    Hindsight is better - you could have stopped extract, info'd the replicat until lag showed zero (so you know all records/statements are done processing), altered the location, then started things back up.

    Get re-sync'd, take a pause, move locations, and resume.
  • Thank you for the quick response and tip, after restore every thing from backup I need to perform below steps please correct me if I am missing any thing.

    alter replicat r_sm07d, exttrail /gg/GG/dirdat/sa

    ALTER REPLICAT r_it852d, EXTSEQNO 000019, EXTRBA 16292

    start r_sm07d
  • let me know if this has worked for you...

    Regards,
    Vivek
  • Yes that works. Thanks for your Help Appreciated.

    I did below steps.

    Replicat:

    alter replicat r_sm07d, exttrail /gg/GG/dirdat/sa

    ALTER REPLICAT r_sm07d, EXTSEQNO 000019, EXTRBA 16292

    start r_sm07d


    Step 2:

    extract:

    ADD EXTTRAIL /gg/GG/dirdat/sa, EXTRACT E_SM07D
    start e_sm07d
This discussion has been closed.