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...