Using ogg" Loading data from the file to replicat" should be aware of the problem: the Replicat process is the foreground process

There are issues to be aware of using Ogg's "Loading data from file to Replicat" approach: The Replicat process is the foreground process

So. It is best to call the Replicat process in Vncserver or execute it in the background nohup way. The following is performed in the background using the Nohup method.

[[email protected] ~]$ ll rep_backgroud.sh-rwxr-xr-x 1 Oracle oinstall 98 June  2 03:02 Rep_backgroud.sh[[email Protect Ed] ~]$ cat rep_backgroud.sh Cd/u02/ggs---> Note this line. cannot be omitted. /u02/ggs is the installation folder for Ogg Replicat PARAMFILE/U02/GGS/DIRPRM/REPFTOR.PRM Reportfile/u02/ggs/dirrpt/repftor.rpt[[email protected] ~]$ [[email protected] ~]$ nohup sh/home/oracle/rep_backgroud.sh  &

===================== disconnects SecureCRT, and then connects securecrt================================

[Email protected] ~]# 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    

Note the point:
1. If the REPLICAT process is running in the same way as the previous process, the SECURECRT is disconnected midway and is partially recorded in the destination table (defined in/U02/GGS/DIRPRM/REPFTOR.PRM).

Before launching the REPLICAT process again. Need to truncate the destination table.

2. The core of the OGG "Loading data from File to Replicat" method is:
The extract process--->trail file (which defines the location in the extraction process's parameter file)--The destination table (the rep process applies the trail file to the destination table)

3. The extract process at this time should also be the foreground process. I just tested it without disconnecting the SECURECRT.

Using ogg" Loading data from the file to replicat" should be aware of the problem: the Replicat process is the foreground process