Note the following when using the OGG "Loading data from file to Replicat" method: The replicat process is a front-end process and the oggreplicat
Note the following when using the "Loading data from file to Replicat" method of OGG: The replicat process is a front-end process.
Therefore, it is best to call the replicat process in vncserver or run it in the background in nohup mode. The following code uses the nohup method to run in the background.
[Oracle @ lei1 ~] $ Ll rep_backgroud.sh-rwxr-xr-x 1 oracle oinstall 98 Jun 2 0:02 rep_backgroud.sh [oracle @ lei1 ~] $ Cat rep_backgroud.sh cd/u02/ggs ---> note this line. The/u02/ggs is the installation directory replicat paramfile/u02/ggs/dirprm/repftor of OGG. prm reportfile/u02/ggs/dirrpt/REPFTOR. rpt [oracle @ lei1 ~] $ [Oracle @ lei1 ~] $ Nohup sh/home/oracle/rep_backgroud.sh &
================================ Disconnect securecrt, then reconnect to the securecrt =======================================
[root@lei1 ~]# ps -ef | grep reporacle 22585 1 0 03:03 ? 00:00:00 sh /home/oracle/rep_backgroud.shoracle 22586 22585 5 03:03 ? 00:00:02 replicat paramfile /u02/ggs/dirprm/repftor.prm reportfile /u02/ggs/dirrpt/REPFTOR.rptroot 22628 22603 0 03:04 pts/1 00:00:00 grep rep[root@lei1 ~]#
Note:
1. if the replicat process is executed by a previous process, the securecrt is disconnected midway through, and then in the target table (in/u02/ggs/dirprm/repftor. some records exist in prm. Truncate the target table before restarting the replicat process.
2. The core of the OGG "Loading data from file to Replicat" method is:
Extract Process ---> trail file (landing file, defining location in the parameter file of the extraction process) --> destination table (the rep process applies the trail file to the destination table)
3. At this time, the extract process should also be a front-end process, but I did not disconnect securecrt during the test, and I have not tried it.