Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

replicat running but does not work working

User_RWYAYJul 10 2019 — edited Jul 11 2019

Hi,

I have this topology

Oracle 12c NonCDB ---> Oracle 18c PDB.

I created table both source and target.

and these my configuration:

GGSCI (node01) 2>  param ext2

EXTRACT EXT2

SETENV (ORACLE_SID='orcl')

SETENV (ORACLE_HOME='/u01/app/oracle/product/12.2.0.1/db_1')

TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle

USERIDALIAS db01

EXTTRAIL ./dirdat/bb

TABLE HR.SEFAZ2;

GGSCI (node01) 3> view param pmp2

EXTRACT PMP2

SETENV (ORACLE_SID='orcl')

SETENV (ORACLE_HOME='/u01/app/oracle/product/12.2.0.1/db_1')

USERIDALIAS db01

RMTHOST rac1, MGRPORT 7810

RMTTRAIL ./dirdat/bb

TABLE HR.SEFAZ2;

GGSCI (rac1.localdomain) 2> view param rep2

REPLICAT REP2

ASSUMETARGETDEFS

SETENV (ORACLE_HOME='/ISOs/oracle')

SETENV (ORACLE_SID='pdb')

USERID ogg@pdb, PASSWORD oracle

DISCARDFILE ./dirrpt/RINI00.dsc, PURGE

MAP HR.SEFAZ2, TARGET PDB.HRTRG2.SEFAZ2;

last logs

GGSCI (node01) 9> start ext2

Sending START request to MANAGER ...

EXTRACT EXT2 starting

GGSCI (node01) 10> info ext2 detail

EXTRACT    EXT2      Last Started 2019-07-10 10:50   Status RUNNING

Checkpoint Lag       00:00:02 (updated 00:00:32 ago)

Process ID           8450

Log Read Checkpoint  Oracle Redo Logs

                     2019-07-10 11:02:36  Thread 1, Seqno 170, RBA 5466624

                     SCN 0.13467975 (13467975)

Log Read Checkpoint  Oracle Redo Logs

                     2019-07-09 16:09:15  Thread 2, Seqno 0, RBA 0

                     SCN 0.0 (0)

  Target Extract Trails:

  Trail Name                                       Seqno        RBA     Max MB Trail Type

  ./dirdat/bb                                          4       1448        500 EXTTRAIL

  Extract Source                          Begin             End

  Not Available                           2019-07-10 10:49  2019-07-10 11:02

  Not Available                           2019-07-10 09:07  2019-07-10 10:49

  Not Available                           2019-07-10 09:07  2019-07-10 10:49

  Not Available                           2019-07-09 16:51  2019-07-10 09:07

  Not Available                           2019-07-09 16:51  2019-07-10 09:07

  Not Available                           2019-07-09 16:45  2019-07-09 16:51

  Not Available                           2019-07-09 16:45  2019-07-09 16:51

  Not Available                           2019-07-09 16:09  2019-07-09 16:45

  Not Available                           2019-07-09 16:09  2019-07-09 16:45

  Not Available                           * Initialized *   2019-07-09 16:09

  Not Available                           * Initialized *   2019-07-09 16:09

  Not Available                           * Initialized *   2019-07-09 16:09

  Not Available                           * Initialized *   2019-07-09 16:09

Current directory    /home/oracle/installgg

Report file          /home/oracle/installgg/dirrpt/EXT2.rpt

Parameter file       /home/oracle/installgg/dirprm/ext2.prm

Checkpoint file      /home/oracle/installgg/dirchk/EXT2.cpe

Process file         /home/oracle/installgg/dirpcs/EXT2.pce

Error log            /home/oracle/installgg/ggserr.log

2019-07-10T11:02:56.603-0300  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EXT2 starting.

2019-07-10T11:02:58.724-0300  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, ext2.prm:  EXTRACT EXT2 starting.

2019-07-10T11:02:58.724-0300  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, ext2.prm:  Operating system character set identified as UTF-8.

2019-07-10T11:02:58.724-0300  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, ext2.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2019-07-10T11:02:58.814-0300  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, ext2.prm:  Successfully set environment variable ORACLE_SID=orcl.

2019-07-10T11:02:58.816-0300  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, ext2.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1.

2019-07-10T11:03:02.692-0300  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, ext2.prm:  Virtual Memory Facilities for: BR

                                  anon alloc: mmap(MAP_ANON)  anon free: munmap

                                  file alloc: mmap(MAP_SHARED)  file free: munmap

                                  target directories:

                                  /home/oracle/installgg/BR/EXT2.

2019-07-10T11:03:02.718-0300  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, ext2.prm:  filecaching started: thread ID: 139909795165952.

2019-07-10T11:03:02.736-0300  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, ext2.prm:  Virtual Memory Facilities for: COM

                                  anon alloc: mmap(MAP_ANON)  anon free: munmap

                                  file alloc: mmap(MAP_SHARED)  file free: munmap

                                  target directories:

                                  /home/oracle/installgg/dirtmp.

2019-07-10T11:03:02.891-0300  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, ext2.prm:  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p833_Redo_Thread_1.

2019-07-10T11:03:02.891-0300  INFO    OGG-01640  Oracle GoldenGate Capture for Oracle, ext2.prm:  BOUNDED RECOVERY: recovery start XID: 0.0.0.0.

2019-07-10T11:03:02.891-0300  INFO    OGG-01641  Oracle GoldenGate Capture for Oracle, ext2.prm:  BOUNDED RECOVERY: recovery start position: SeqNo: 159, RBA: 108650000, SCN: 0.13449058 (13449058), Timestamp: 2019-07-10 08:52:17.000000, Thread: 1.

2019-07-10T11:03:02.891-0300  INFO    OGG-01642  Oracle GoldenGate Capture for Oracle, ext2.prm:  BOUNDED RECOVERY: recovery end position: SeqNo: 159, RBA: 108650496, SCN: 0.13449058 (13449058), Timestamp: 2019-07-10 08:52:17.000000, Thread: 1.

2019-07-10T11:03:02.891-0300  INFO    OGG-01643  Oracle GoldenGate Capture for Oracle, ext2.prm:  BOUNDED RECOVERY: CANCELED: for object pool 1: p833_Redo_Thread_1.

2019-07-10T11:03:02.975-0300  INFO    OGG-01579  Oracle GoldenGate Capture for Oracle, ext2.prm:  BOUNDED RECOVERY: VALID BCP: CP.EXT2.000000004.

2019-07-10T11:03:02.977-0300  INFO    OGG-01629  Oracle GoldenGate Capture for Oracle, ext2.prm:  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.

2019-07-10T11:03:03.276-0300  INFO    OGG-06604  Oracle GoldenGate Capture for Oracle, ext2.prm:  Database ORCL CPU info: CPU Count 1, CPU Core Count 0, CPU Socket Count 0.

2019-07-10T11:03:10.172-0300  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info ext2 detail.

2019-07-10T11:03:17.341-0300  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, ext2.prm:  Source redo compatibility version is: 12.2.0.

2019-07-10T11:03:17.349-0300  INFO    OGG-00546  Oracle GoldenGate Capture for Oracle, ext2.prm:  Default thread stack size: 10485760.

2019-07-10T11:03:17.446-0300  INFO    OGG-01513  Oracle GoldenGate Capture for Oracle, ext2.prm:  Positioning to (Thread 1) Sequence 170, RBA 5466128, SCN 0.13467975 (13467975).

2019-07-10T11:03:21.828-0300  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

2019-07-10T11:03:24.751-0300  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, ext2.prm:  Positioned to (Thread 1) Sequence 170, RBA 5466128, SCN 0.13467975 (13467975), 2019 M07 10 11:02:36.

2019-07-10T11:03:24.760-0300  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, ext2.prm:  Positioning to begin time 2019 M07 9 16:09:15.

2019-07-10T11:03:29.068-0300  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, ext2.prm:  EXTRACT EXT2 started.

2019-07-10T11:03:29.068-0300  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, ext2.prm:  Position of first record processed for Thread 1, Sequence 170, RBA 5466128, SCN 0.13467975 (13467975), 2019 M07 10 11:02:36.

2019-07-10T11:03:29.084-0300  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, ext2.prm:  Recovery initialization completed for target file ./dirdat/bb000000004, at RBA 1448.

2019-07-10T11:03:29.085-0300  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, ext2.prm:  Output file ./dirdat/bb is using format RELEASE 12.3/18.1.

2019-07-10T11:03:29.105-0300  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, ext2.prm:  Rolling over remote file ./dirdat/bb000000004.

2019-07-10T11:03:29.145-0300  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, ext2.prm:  Recovery completed for target file ./dirdat/bb000000005, at RBA 1448.

2019-07-10T11:03:29.145-0300  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, ext2.prm:  Recovery completed for all targets.

2019-07-10T11:03:29.864-0300  INFO    OGG-02232  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Switching to next trail file /home/oracle/installgg/dirdat/bb000000005 at 2019-07-10 11:03:29.864324 due to EOF. with current RBA 1,448.

2019-07-10T11:04:09.466-0300  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop pmp2.

2019-07-10T11:04:10.481-0300  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Command received from GGSCI: STOP.

2019-07-10T11:04:10.538-0300  INFO    OGG-00991  Oracle GoldenGate Capture for Oracle, pmp2.prm:  EXTRACT PMP2 stopped normally.

2019-07-10T11:04:12.832-0300  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start pmp2.

2019-07-10T11:04:12.921-0300  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [192.168.0.11]:54628 (START EXTRACT PMP2 ).

2019-07-10T11:04:13.003-0300  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT PMP2 starting.

2019-07-10T11:04:17.994-0300  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, pmp2.prm:  EXTRACT PMP2 starting.

2019-07-10T11:04:18.084-0300  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Operating system character set identified as UTF-8.

2019-07-10T11:04:18.114-0300  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, pmp2.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2019-07-10T11:04:18.134-0300  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Successfully set environment variable ORACLE_SID=orcl.

2019-07-10T11:04:18.137-0300  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1.

2019-07-10T11:04:18.235-0300  INFO    OGG-01360  Oracle GoldenGate Capture for Oracle, pmp2.prm:  EXTRACT is running in Data Pump mode.

2019-07-10T11:04:18.956-0300  INFO    OGG-01889  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Flush size (max message size) is set to 27,985.

2019-07-10T11:04:25.187-0300  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, pmp2.prm:  filecaching started: thread ID: 139631169967872.

2019-07-10T11:04:25.206-0300  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Virtual Memory Facilities for: COM

                                  anon alloc: mmap(MAP_ANON)  anon free: munmap

                                  file alloc: mmap(MAP_SHARED)  file free: munmap

                                  target directories:

                                  /home/oracle/installgg/dirtmp.

2019-07-10T11:04:26.764-0300  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, pmp2.prm:  EXTRACT PMP2 started.

2019-07-10T11:04:32.769-0300  INFO    OGG-01888  Oracle GoldenGate Capture for Oracle, pmp2.prm:  TCP network is configured as

                                                OS DEFAULT          SPECIFIED           ACTUAL VALUE

                                       IP_DSCP    0                   N/A                 0

                                        IP_TOS    0                   N/A                 0

                                   TCP_NODELAY    0                   N/A                 0

                                  TCP_QUICKACK    1                   N/A                 1

                                      TCP_CORK    0                   N/A                 0

                                     SO_SNDBUF    8192                N/A                 8192

                                     SO_RCVBUF    43690               N/A                 43690.

2019-07-10T11:04:32.789-0300  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Recovery initialization completed for target file ./dirdat/bb000000007, at RBA 1567.

2019-07-10T11:04:32.946-0300  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Rolling over remote file ./dirdat/bb000000008.

2019-07-10T11:04:33.023-0300  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Recovery completed for target file ./dirdat/bb000000008, at RBA 1508.

2019-07-10T11:04:33.023-0300  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Recovery completed for all targets.

2019-07-10T11:04:33.043-0300  INFO    OGG-02243  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Opened trail file /home/oracle/installgg/dirdat/bb000000005 at 2019-07-10 11:04:33.043595.

2019-07-10T11:04:33.053-0300  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, pmp2.prm:  Output file ./dirdat/bb is using format RELEASE 12.3/18.1.

GGSCI (node01) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXT2        00:00:02      00:00:43

EXTRACT     RUNNING     PMP2        00:00:00      00:00:03

2019-07-10T11:10:28.933-0300  INFO    OGG-00994  Oracle GoldenGate Delivery for Oracle, rep2.prm:  REPLICAT REP2 stopped normally.

2019-07-10T11:10:31.915-0300  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start rep2.

2019-07-10T11:10:31.929-0300  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [::1]:17437 (START REPLICAT REP2 ).

2019-07-10T11:10:31.998-0300  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REP2 starting.

2019-07-10T11:10:33.131-0300  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, rep2.prm:  REPLICAT REP2 starting.

2019-07-10T11:10:33.131-0300  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Operating system character set identified as UTF-8.

2019-07-10T11:10:33.131-0300  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle, rep2.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2019-07-10T11:10:33.131-0300  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Successfully set environment variable ORACLE_HOME=/ISOs/oracle.

2019-07-10T11:10:33.131-0300  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Successfully set environment variable ORACLE_SID=pdb.

2019-07-10T11:10:36.591-0300  INFO    OGG-02679  Oracle GoldenGate Delivery for Oracle, rep2.prm:  The Replicat process logged on to database PDB and can only apply to that database.

2019-07-10T11:10:36.910-0300  INFO    OGG-06451  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Triggers will be suppressed by default.

2019-07-10T11:10:36.963-0300  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Virtual Memory Facilities for: COM

                                  anon alloc: mmap(MAP_ANON)  anon free: munmap

                                  file alloc: mmap(MAP_SHARED)  file free: munmap

                                  target directories:

                                  /home/oracle/gginstall/dirtmp.

2019-07-10T11:10:37.079-0300  INFO    OGG-06604  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Database PDB CPU info: CPU Count 4, CPU Core Count 4, CPU Socket Count 1.

2019-07-10T11:10:37.288-0300  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rep2.prm:  REPLICAT REP2 started.

GGSCI (rac1.localdomain) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    RUNNING     REP2        00:00:00      00:00:05

GGSCI (rac1.localdomain) 7> info rep2 detail

REPLICAT   REP2      Last Started 2019-07-10 11:10   Status RUNNING

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

Process ID           20752

Log Read Checkpoint  File /home/oracle/gginstall/dirdat/bb000000000

                     First Record  RBA 0

Current Log BSN value: (requires database login)

Last Committed Transaction CSN value: (requires database login)

  Extract Source                          Begin             End

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  /home/oracle/gginstall/dirdat/bb000000000  * Initialized *   First Record

  ./dirdat/bb000000000                    * Initialized *   First Record

Current directory    /home/oracle/gginstall

Report file          /home/oracle/gginstall/dirrpt/REP2.rpt

Parameter file       /home/oracle/gginstall/dirprm/rep2.prm

Checkpoint file      /home/oracle/gginstall/dirchk/REP2.cpr

Checkpoint table     OGG.CHECKPOINTTABLE

Process file         /home/oracle/gginstall/dirpcs/REP2.pcr

Error log            /home/oracle/gginstall/ggserr.log

What the problem?


Replicat working but does not apply...

This post has been answered by ORASCN on Jul 11 2019
Jump to Answer

Comments

Post Details

Added on Jul 10 2019
1 comment
4,727 views