Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ GoldenGate update is missing     - Getting Started with Java NIO (Programming)

- Help you make Git Bisect (Linux)

- Open log in Hibernate (Programming)

- How to use the Vault secure password storage and API key (Linux)

- To use Linux to create a secure managed gateway (Linux)

- Installing software on Ubuntu: apt-get and dpkg difference (Linux)

- CentOS6.5 install SVN & visual management tools iF.SVNAdmin (Server)

- Android design patterns - state mode (Programming)

- phpinfo (): like phpinfo as a Python script (Programming)

- Ubuntu batch scp to copy files without password (Linux)

- Ceph distributed storage system is installed on a CentOS 7.1 (Server)

- Testing Oracle 11g RMAN replicate database (Database)

- Linux C programming and Shell Programming in the development of practical tools similarities summary (Programming)

- Use ldap implement Windows Remote Desktop Ubuntu Linux (Linux)

- Linux landing problem (Linux)

- Linux firewall settings instance (Linux)

- C language to view various types of data size (Programming)

- MongoDB version 3.2 WiredTiger storage engine performance tests (Database)

- ARP spoofing prevent Linux environment LAN (Linux)

- Security Knowledge: How to hide a backdoor PHP file tips (Linux)

 
         
  GoldenGate update is missing
     
  Add Date : 2017-08-31      
         
         
         
  Recently, a very interesting but disturbing problem was found on the GoldenGate (11.2.1.0.1 for 10g) target library. This is the case, there are users reflected in the target library on a table with two fields (DZFAILFLAG, REMARK) and the source of the value of inconsistency.

Check the source library and the target library GoldenGate process, both sides of the run very well, did not report any errors. Look at the source and target libraries on the table that the number of records, the number of records on both sides is the same, but there are some records of the value is inconsistent! And when the number of records in the source library increases, the number of records in the target library also increases accordingly:

Source Library:
11:17:37 SQL> SELECT COUNT (*) FROM LISDATA.LDCONTINVOICEMAP;
COUNT (*)
----------
980489
11:18:07 SQL> SELECT COUNT (*) FROM LISDATA.LDCONTINVOICEMAP;
COUNT (*)
----------
980490
11:18:43 SQL> SELECT COUNT (*) FROM LISDATA.LDCONTINVOICEMAP;
COUNT (*)
----------
980493
11:19:44 SQL> SELECT COUNT (*) FROM LISDATA.LDCONTINVOICEMAP;
COUNT (*)
----------
980498
Target library:
11:17:43 SQL> SELECT COUNT (*) FROM LISDATA.LDCONTINVOICEMAP;
COUNT (*
----------
980490
11:18:53 SQL> SELECT COUNT (*) FROM LISDATA.LDCONTINVOICEMAP;
COUNT (*)
----------
980493
11:19:38 SQL> SELECT COUNT (*) FROM LISDATA.LDCONTINVOICEMAP;
COUNT (*)
----------
980498

In other words, the copy process is in the work, and the work is normal! Trying to source a record on the reservoir DZFAILFLAG, REMARK update, the results are very disappointing in the target database of the value of these two fields are not updated life and death! Taking into account the record of this table is not too much, so on this table re-initialized. After some agonizing, the table finally re-initialization is complete, full of hope to re-try on the source library on the field update, the result is crazy, or not updated! No way, only to analyze the trail file to see what happened in the end, open the corresponding logdump trail file, navigate to the appropriate location:

2013/08/20 12: 50: 55.000.000 FieldComp Len 48 RBA 17500895
Name: LISDATA.LDCONTINVOICEMAP
After Image: Partition 4 G s
0000 0010 0000 000c 3330 3030 3030 3030 3130 3335 | ........ 300000001035
0001 0005 0000 0001 3100 0200 0f00 0000 0b38 3330 | ........ 1 ........ 830
3130 3030 3030 3032 | 10000002
Column 0 (x0000), Len 16 (x0010)
Column 1 (x0001), Len 5 (x0005)
Column 2 (x0002), Len 15 (x000f)

Trail from the record can be seen, EXTRACT only crawled to the main key column (0,1,2 out of the table is the primary key), but to update the two did not crawl to! Try to restart the EXTRACT process a bit, the results update on all normal!

Understand that the field DZFAILFLAG, REMARK is just two days before the new addition, and update loss happens to happen in these two new fields. That is, when the new field on the table, if you do not restart EXTRACT process, you can not crawl to the new field information! This is the case, if the use of GoldenGate DDL copy function, even if the DDL replication work properly, should also encounter such a problem? That GoldenGate DDL copy function will become a decoration? SR has been opened to the Oracle, do not know whether it is GoldenGate BUG. Prior to this, you do before the DDL, or the first EXTRACT first stopped.
     
         
         
         
  More:      
 
- Disable unnecessary services under Linux (Linux)
- To configure parameter configuration and software installation and uninstallation under Linux (Linux)
- Three kinds of binary tree traversal recursive and iterative solution (Programming)
- Ubuntu 14.04 LTS installed Hadoop 1.2.1 (distributed cluster mode) (Server)
- How to set cache valid time in Apache (Server)
- Linux uses shared memory communication process synchronization Withdrawal (Programming)
- Ubuntu 32 compile Android 4.0.4 Problems (Linux)
- Oracle Listener can not start (TNS-12555, TNS-12560, TNS-00525) (Database)
- How to create a bootable USB disk to use MultiSystem on Ubuntu (Linux)
- Android studio multi-channel ultra-compact version of the package (Programming)
- Linux kernel log --dmesg (Linux)
- GitLab remote backup of Linux Shell Scripting (Linux)
- How to choose the first programming language based on the life you want (Programming)
- Use SecureCRT to transfer files between Linux and Windows (Linux)
- Linux user login and IP restrictions (Linux)
- CentOS / Linux SELinux Close (Linux)
- MongoDB replication instance (Database)
- Use calcurse schedule appointments and to-do in the Linux terminal (Linux)
- In-depth understanding of PHP ini configuration (Server)
- The best known for archiving / compression tool under linux (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.