Shulou(Shulou.com)06/01 Report--

Oracle 19C OGG basic operation and maintenance-08Error code

Question:

Source side: delete dept_ Bak table

Target side: dept_ Bak table cannot be found during data synchronization, process ABENDING, synchronization is interrupted.

The error log is as follows:

Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist], no error handler present.

The detailed log of the destination side is as follows:

[oracle@cjcos02 ogg] $tail-f ggserr.log

2020-04-10T20:48:13.291+0800 INFO OGG-00484 Oracle GoldenGate Delivery for Oracle, rep_01.prm: Executing DDL operation.

2020-04-10T20:48:13.919+0800 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rep_01.prm: Fatal error executing DDL replication: error [Error code, ORA-00942: table or view does not exist], no error handler present.

2020-04-10T20:48:20.064+0800 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, rep_01.prm: Reading / ogg/dirdat/dp000000004, current RBA 10pm 276,0 records, m_file_seqno = 4, m_file_rba = 11586.

2020-04-10T20:48:20.065+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_01.prm: PROCESS ABENDING.

View process status

GGSCI (cjcos02) 16 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT ABENDED REP_01 00:03:15 00:22:09

The problem of restarting the process still exists

GGSCI (cjcos02) 17 > stop rep_01

REPLICAT REP_01 is already stopped.

GGSCI (cjcos02) 17 > start rep_01

GGSCI (cjcos02) 16 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT ABENDED REP_01 00:03:15 00:22:09

The cause of the problem:

At first, instead of matching all tables with * in the source-side extract process and destination-side replicat process parameter files, fixed tables are specified.

For example:

-extract

TABLE cjcpdb.cjc.emp

TABLE cjcpdb.cjc.dept

TABLE cjcpdb.cjc.bonus

TABLE cjcpdb.cjc.salgrade

TABLE cjcpdb.cjc.dummy

-replicat

MAP cjcpdb.cjc.emp, TARGET chenpdb.chen.emp

MAP cjcpdb.cjc.dept, TARGET chenpdb.chen.dept

MAP cjcpdb.cjc.bonus, TARGET chenpdb.chen.bonus

MAP cjcpdb.cjc.salgrade, TARGET chenpdb.chen.salgrade

MAP cjcpdb.cjc.dummy, TARGET chenpdb.chen.dummy

During this period, a test table dept_bak is created on the source side.

Source side:

Create table dept_bak as select * from dept

Due to the previous configuration, this operation is not synchronized to the target side.

Later, the source-side extract process and target-side replicat process parameter files are modified to match all the tables under the user through *.

For example:

-extract

TABLE cjcpdb.cjc.*

-replicat

MAP cjcpdb.cjc.*, TARGET chenpdb.chen.*

After restarting the extract and relicat processes, it is found that there is one more test table dept_bak on the source side than on the target side.

Delete this table manually on the source side. Because the table is not available on the destination side, the drop command causes an error indicating that the table cannot be found when synchronizing to the destination side, resulting in suspending the recovery process replicat on the destination side.

Solution: the target side modifies the parameters and skips the 942 error

GGSCI (cjcos02) 19 > edit param rep_01

GGSCI (cjcos02) 20 > view param rep_01

Replicat rep_01

Setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

Userid ogg@chenpdb,password oracle

Assumetargetdefs

Reperror default,discard

Discardfile. / dirrpt/replzl.dsc,append,megabytes 50

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

DDLERROR 942 IGNORE

MAP cjcpdb.cjc.*, TARGET chenpdb.chen.*

-MAP cjcpdb.cjc.emp, TARGET chenpdb.chen.emp

-MAP cjcpdb.cjc.dept, TARGET chenpdb.chen.dept

-MAP cjcpdb.cjc.bonus, TARGET chenpdb.chen.bonus

-MAP cjcpdb.cjc.salgrade, TARGET chenpdb.chen.salgrade

-MAP cjcpdb.cjc.dummy, TARGET chenpdb.chen.dummy

Return to normal after restarting the replicat process

GGSCI (cjcos02) 23 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REP_01 00:00:00 00:00:02

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.