5.26.2019

How to change Remote Trail Location at Source– Golden Gate 12c


There is a requirement to modify the remote trail location because of typo in the mount point. To change the remote trail location of the Golden Gate, first verify the extract trail information using the command below. 

GGSCI (hie-p-ggate) 48> INFO EXTTRAIL

       Extract Trail: /golgengate/ggs_home/dirdat/test/ru
        Seqno Length: 6
   Flip Seqno Length: yes
             Extract: DPMP1
               Seqno: 0
                 RBA: 0
           File Size: 500M

       Extract Trail: D:\app\oracle\product\ogg_1\lt
        Seqno Length: 6
   Flip Seqno Length: yes
             Extract: EXT1
               Seqno: 0
                 RBA: 0
           File Size: 100M
GGSCI (hie-p-ggate) 49>

First delete the current configuration of remote trail. 

GGSCI (hie-p-ggate) 50> delete rmttrail /golgengate/ggs_home/dirdat/test/ru, extract dpmp1
Deleting extract trail /golgengate/ggs_home/dirdat/test/ru for extract DPMP1

After removing, then add the remote trail again with the new location. 


GGSCI (hie-p-ggate) 51> add rmttrail /goldengate/ggs_home/dirdat/test/ru, extract dpmp1
RMTTRAIL added.


After deleting and adding now we can see the extract trail for the target with new location. 

GGSCI (hie-p-ggate) 52> INFO EXTTRAIL

       Extract Trail: /goldengate/ggs_home/dirdat/test/ru
        Seqno Length: 6
   Flip Seqno Length: yes
             Extract: DPMP1
               Seqno: 0
                 RBA: 0
           File Size: 500M

       Extract Trail: D:\app\oracle\product\ogg_1\lt
        Seqno Length: 6
   Flip Seqno Length: yes
             Extract: EXT1
               Seqno: 0
                 RBA: 0
           File Size: 100M



GGSCI (hie-p-ggate) 53>


No comments: