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

Oracle GoldenGate Learning-- the Monitoring of GoldenGate

1. Use GGSCI command to monitor

(1) enter the GoldenGate installation directory, run GGSCI, and then use info all to view the overall health.

GGSCI (aix212) 1 > info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EORA_1 00:00:00 00:00:03EXTRACT RUNNING PORA_1 00:00:00 00:00:00GGSCI (aix211) 1 > info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGREPLICAT RUNNING RORA_1 00:00:00 00:00:09Group indicates the name of the process (the MGR process does not display the name)

Lag represents the delay of the process; Status represents the state of the process, which has four states.

STARTING indicates that it is in the process of starting.

RUNNING indicates that the process is running normally.

STOPPED indicates that the process has been shut down normally.

ABENDED indicated that the process was shut down abnormally and that further investigation was needed.

Normally, the state of all processes should be RUNNING, and the Lag should be within a reasonable range.

(2) use view params to view the parameter settings of a process. This command supports the wildcard character *.

Source side: GGSCI (aix212) 4 > view param mgrdynamicportlist 7800-8000autorestart extract *, waitminutes 2 5GGSCI (aix212) 7 > view param eini_1EXTRACT EINI_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) USERID ogg,PASSWORD oggRMTHOST 192.168.211 MGRPort 7809RMTTASK REPLICAT, GROUP RINI_1TABLE scott.EMP_OGG;GGSCI (aix212) 5 > view param eora_1EXTRACT EORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) USERID ogg,PASSWORD oggEXTTRAIL. / dirdat/aaTABLE scott.emp_ogg GGSCI (aix212) 6 > view param pora_1EXTRACT PORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) PASSTHRURMTHOST 192.168.8.211 MGRPORT 7809RMTTRAIL. / dirdat/paTABLE scott.emp_ogg; destination: GGSCI (aix211) 4 > view param mgrport 7809dynamicportlist 7800-8000autorestart extract *, waitminutes 2 coding 5GGSCI (aix211) 3 > view param rini_1REPLICAT RINI_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) ASSUMETARGETDEFSUSERID ogg,PASSWORD oggDISCARDFILE. / dirrpt/RINIaa.dsc,PURGEMAP scott.emp_ogg, TARGET scott.emp_ogg GGSCI (aix211) 2 > view param rora_1REPLICAT RORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) USERID ogg,PASSWORD oggHANDLECOLLISIONSASSUMETARGETDEFSDISCARDFILE. / dirrpt/RORA_aa.DSC,PURGEMAP scott.oem_ogg, TARGET scott.emp_ogg; (3) use the info command to view process information, including process status, checkpoint information, delay, etc.

GGSCI (aix212) 8 > info eora_1EXTRACT EORA_1 Last Started 2014-09-25 16:09 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:04 ago) Log Read Checkpoint Oracle Redo Logs 2014-09-25 17:00:16 Seqno 5 RBA 21645824 SCN 0.658565 (658565) GGSCI (aix212) 9 > info pora_1EXTRACT PORA_1 Last Started 2014-09-25 16:09 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:05 ago) Log Read Checkpoint File. / dirdat/pa000000 First Record RBA 0 GGSCI (aix211) 5 > info rora_1REPLICAT RORA_1 Last Started 2014-09-25 16:25 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:04 ago) Log Read Checkpoint File. / dirdat/pa000000 First Record RBA 0 (4) you can also use the info detail command to view more details Including the location of trail files, parameter files, report files, warning logs, etc.

GGSCI (aix212) 10 > info eora_1 detailEXTRACT EORA_1 Last Started 2014-09-25 16:09 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:02 ago) Log Read Checkpoint Oracle Redo Logs 2014-09-25 17:01:58 Seqno 5 RBA 21770240 SCN 0.658666 (658666) Target Extract Trails: Remote Trail Name Seqno RBA Max MB. / dirdat/aa 2 2354 5 Extract Source Begin End / u01/app/oracle/oradata/ Orcl/redo01.log 2014-09-25 16:07 2014-09-25 17:01 / u01/app/oracle/oradata/orcl/redo01.log 2014-09-23 20:34 2014-09-25 16:08 / u01/app/oracle/oradata/orcl/redo03.log 2014-09-23 15:17 2014-09-23 20:35 Not Available * Initialized * 2014-09-23 15:17Current directory / oggReport file / ogg/dirrpt/EORA_1.rptParameter file / ogg/dirprm/eora_1.prmCheckpoint file / ogg/dirchk/EORA_1.cpeProcess file / ogg/dirpcs/EORA_1.pceStdout file / ogg/dirout/EORA_1.outError log / ogg/ggserr.logGGSCI (aix211) 6 > info rora_1 detailREPLICAT RORA_1 Last Started 2014-09-25 16:25 Status RUNNINGCheckpoint Lag 00:00:00 ( Updated 00:00:04 ago) Log Read Checkpoint File. / dirdat/pa000000 First Record RBA 0 Extract Source Begin End. / dirdat/pa000000 * Initialized * First Record. / dirdat/pa000000 * Initialized * First RecordCurrent directory / oggReport file / ogg/dirrpt/RORA_1.rptParameter File / ogg/dirprm/rora_1.prmCheckpoint file / ogg/dirchk/RORA_1.cprCheckpoint table ogg.checkpointProcess file / ogg/dirpcs/RORA_1.pcrStdout file / ogg/dirout/RORA_1.outError log / ogg/ggserr.log (5) use the info showch command to view detailed information about checkpoint Used to view transaction records processed by GoldenGate processes

GGSCI (aix212) 11 > info eora_1 showchEXTRACT EORA_1 Last Started 2014-09-25 16:09 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:03 ago) Log Read Checkpoint Oracle Redo Logs 2014-09-25 17:04:50 Seqno 5 RBA 21797888 SCN 0.658739 (658739) Current Checkpoint Detail:Read Checkpoint # 1 Oracle Redo Log Startup Checkpoint (starting position in the data source): Thread #: 1 Sequence #: 5 RBA: 19244560 Timestamp: 2014-09-25 16 purge 07purl 15.000000 SCN: 0.656759 (656759) Redo File: / u01/app/oracle/oradata/orcl/redo01.log Recovery Checkpoint (position of oldest unprocessed transaction int he data source): Thread #: 1 Sequence #: 5 RBA: 21795856 Timestamp: 2014-09-25 17Sequence 04SCN: 0.658736 (658736) Redo File: / u01/app/oracle/oradata/orcl/redo01.log Current Checkpoint (position of last record read in the data source): Thread #: 1 Sequence #: 5 RBA: 21797888 Timestamp: 50.000000 SCN: 0.658739 (658739) Redo File: / u01/app/oracle/oradata / orcl/redo01.log BR Previous Recovery Checkpoint: Thread #: 0 Sequence #: 0 RBA: 0 Timestamp: 2014-09-23 15 Sequence 22 RBA 40.485502 SCN: Not available Redo File: BR Begin Recovery Checkpoint: Thread #: 1 Sequence #: 4 RBA: 10054144 Timestamp: 2014-09-23 19Fringe 22 47.000000 SCN: 0.629912 (629912) Redo File: BR End Recovery Checkpoint: Thread #: 1 Sequence #: 4 RBA: 10054144 Timestamp: 2014-09-23 1922 GGS Log Trail Current Checkpoint 47.000000 SCN: 0.629912 (629912) Redo File:Write Checkpoint # 1 GGS Log Trail Current Checkpoint (current write position): Sequence #: 2 RBA: 2354 Timestamp: 54.617925 Extract Trail:. / dirdat/aaCSN state information: CRC: B9-8B-16-BD Latest CSN: 658581 Latest TXN: 3.47.317 Latest CSN of finished TXNs: 658581 Completed TXNs: 3.47.317Header : Version = 2 Record Source = A Type = 10 # Input Checkpoints = 1 # Output Checkpoints = 1File Information: Block Size = 2048 Max Blocks = 2048 Record Length = 2048 Current Offset = 0Configuration: Data Source = 3 Transaction Integrity = 1 Task Type = 0Status: Start Time = 2014-09-25 16:09:02 Last Update Time = 2014-09-25 17:04:54 Stop Status = A Last Result = 400 where the more important is the recovery checkpoint of the Extract process It represents the earliest unprocessed transaction in the source data Through recovery checkpoint, you can see which log file the redo log of the transaction is located in and the sequence number of the log file.

All log files with larger serial numbers need to be retained.

(6) lag can view detailed delay information.

GGSCI (aix212) 12 > lag eora_1Sending GETLAG request to EXTRACT EORA_1... Last record lag: 2 seconds.At EOF, no more records to process. (7) stats can view the number of records processed by the process:

The report details the types of processing and the number of records, such as:

Stats, table.

GGSCI (aix212) 13 > stats eora_1 TotalSending STATS request to EXTRACT EORA_1. Start of Statistics at 2014-09-25 17:08:54.Output to. / dirdat/aa:Extracting from SCOTT.EMP_OGG to SCOTT.EMP_OGG:*** Total statistics since 2014-09-25 16:11:23 * * Total inserts 3.00 Total updates Total deletes 6.00 Total discards 0.00 Total operations 9.00End of Statistics. Lists the number of all records processed since the process started, as shown in figure 11-8.

GGSCI (aix212) 15 > stats eora_1,daily Table scott.emp_oggSending STATS request to EXTRACT EORA_1. Start of Statistics at 2014-09-25 17:11:16.Output to. / dirdat/aa:Extracting from SCOTT.EMP_OGG to SCOTT.EMP_OGG:*** Daily statistics since 2014-09-25 16:11:23 * * Total inserts 3.00 Total updates 0.00 Total deletes 6.00 Total discards 0.00 Total operations 9.00End of Statistics. Lists the number of all records processed for the scott.emp_ og table since the day

(8) view report can view the running report

GGSCI (aix212) 16 > view report eora_1**** Oracle GoldenGate Capture for Oracle Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230 AIX 5L, ppc 64bit (optimized), Oracle 10.2 on Apr 23 2012 07:57:02Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. Starting at 2014-09-25 16:09:01****Operating System Version:AIXVersion 5 Release 3Node: aix212Machine: 0009746A4C00 soft limit hard limitAddress Space Size: unlimited unlimitedHeap Size: unlimited unlimitedFile Size: unlimited unlimitedCPU Time: unlimited unlimitedProcess id: 229538 description * * * Running with the following parameters * * * 2014-09-25 16:09:01 INFO OGG-03035 Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.EXTRACT EORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) USERID ogg,PASSWORD * EXTTRAIL. / dirdat/aaTABLE scott.emp_ogg 2014-09-25 16:09:01 INFO OGG-01815 Virtual Memory Facilities for: BR anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/BR/EORA_1.Bounded Recovery Parameter:BRINTERVAL = 4HOURSBRDIR = / ogg2014-09-25 16:09:02 INFO OGG-01815 Virtual Memory Facilities for: COM anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP _ SHARED) file free: munmap target directories: / ogg/dirtmp.CACHEMGR virtual memory values (may have been adjusted) CACHESIZE: 64GCACHEPAGEOUTSIZE (normal): 8MPROCESS VM AVAIL FROM OS (min): 128GCACHESIZEMAX (strict force to disk): 96G2014-09-25 16:09:02 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 1: p536622_extr.2014-09-25 16:09 : 02 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 0.0.0.2014-09-25 16:09:02 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 4 RBA: 10053648, SCN: 0.629912 (629912), Timestamp: 2014-09-23 19V 22 Thread 47.000000, Thread: 1.2014-09-25 16:09:02 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 4, RBA: 10054144, SCN: 0.629912 (629912), Timestamp: 2014-09-23 1922 Thread 47.000000 Thread: 1.2014-09-25 16:09:02 INFO OGG-01643 BOUNDED RECOVERY: CANCELED: for object pool 1: p536622_extr.2014-09-25 16:09:02 INFO OGG-01579 BOUNDED RECOVERY: VALID BCP: CP.EORA_1.000000001.2014-09-25 16:09:02 INFO OGG-01629 BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: .Database Version:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0 ProductionTNS for IBM/AIX RISC System/6000: Version 10.2.0.1.0-ProductioNLSRTL Version 10.2.0.1.0-ProductionDatabase Language and Character Set:NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK" NLS_LANGUAGE = "AMERICAN" NLS_TERRITORY = "AMERICA" NLS_CHARACTERSET = "ZHS16GBK" 2014-09-25 16:09:02 INFO OGG-01513 Positioning to Sequence 5 RBA 19244560, SCN 0.656759.2014-09-25 16:09:02 INFO OGG-01516 Positioned to Sequence 5, RBA 19244560, SCN 0.656759, Sep 25,2014 3:07:15 PM.2014-09-25 16:09:02 INFO OGG-01055 Recovery initialization completed for target file. / dirdat/aa000001 At RBA 1007.2014-09-25 16:09:02 INFO OGG-01478 Output file. / dirdat/aa is using format RELEASE 11.2.2014-09-25 16:09:02 INFO OGG-01026 Rolling over remote file. / dirdat/aa000001.2014-09-25 16:09:02 INFO OGG-01053 Recovery completed for target file. / dirdat/aa000002 At RBA 1007.2014-09-25 16:09:02 INFO OGG-01057 Recovery completed for all targets.**** Run Time Messages * 2014-09-25 16:09:02 INFO OGG-01517 Position of first record processed Sequence 5 RBA 19244560, SCN 0.656759, Sep 25, 2014 3:07:15 PM.TABLE resolved (entry scott.emp_ogg): TABLE "SCOTT". "EMP_OGG" Using the following key columns for source table SCOTT.EMP_OGG: EMPNO.2014-09-25 17:07:03 INFO OGG-01021 Command received from GGSCI: GETLAG.2014-09-25 17:08:54 INFO OGG-01021 Command received from GGSCI: STATS total.2014-09-25 17:10:43 INFO OGG-01021 Command received from GGSCI: STATS daily,scott.emp_ogg.2014-09-25 17:11:16 INFO OGG-01021 Command received from GGSCI: STATS daily Table scott.emp_ogg. (9) you can also enter the / dirrpt/ directory View the corresponding report file.

The latest reports are always named after .rpt. A report with a suffix is a historical report, and the larger the number, the longer the corresponding time.

[oracle@aix212@ ogg] $cd dirrpt [oracle@aix212@ dirrpt] $ls-lttotal 248 oracle oinstall RWML RWL RW-1 oracle oinstall 4962 Sep 25 17:11 EORA_1.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 25 16:32 EINI_1.rpt-rw-rw-rw- 1 oracle oinstall 2252 Sep 25 16:32 MGR.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 25 16: 27 EINI_10.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 25 16:09 EINI_11.rpt-rw-rw-rw- 1 oracle oinstall 2377 Sep 25 16:09 PORA_1.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 25 16:08 EINI_12.rpt-rw-rw-rw- 1 oracle oinstall 1897 Sep 25 16:08 MGR0.rpt-rw-rw-rw- 1 oracle oinstall 20631 Sep 25 16:08 EORA_10.rpt-rw-rw-rw- 1 oracle oinstall 11416 Sep 25 16:07 PORA_10.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 25 15:35 EINI_13.rpt-rw-rw-rw- 1 oracle oinstall 3899 Sep 23 19:22 EORA_11.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 23 16:27 EINI_14.rpt-rw-rw-rw- 1 oracle oinstall 3078 Sep 23 16:27 MGR1.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 23 16:24 EINI_15.rpt-rw-rw-rw- 1 oracle oinstall 3124 Sep 23 16:23 EINI_16.rpt-rw-rw-rw- 1 oracle oinstall 3031 Sep 23 16:20 EINI_17.rpt-rw-rw-rw- 1 oracle oinstall 3031 Sep 23 16:18 EINI_18.rpt-rw-rw-rw- 1 oracle oinstall 3031 Sep 23 16:13 EINI_19.rpt-rw-rw-rw- 1 oracle oinstall 1897 Sep 23 15:49 MGR2.rpt-rw-rw-rw- 1 oracle oinstall 2377 Sep 23 15:25 PORA_11.rpt-rw-rw-rw- 1 oracle oinstall 1372 Sep 23 15:15 MGR3 .rpt-rw-rw-rw- 1 oracle oinstall 1547 Sep 23 15:09 MGR4.rpt

[oracle@aix212@ dirrpt] $cat EORA_1.rpt

* Oracle GoldenGate Capture for Oracle Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230 AIX 5L, ppc, 64bit (optimized) Oracle 10.2 on Apr 23 2012 07:57:02Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. Starting at 2014-09-25 16:09:01****Operating System Version:AIXVersion 5 Release 3Node: aix212Machine: 0009746A4C00 soft limit hard limitAddress Space Size: unlimited unlimitedHeap Size: unlimited unlimitedFile Size: unlimited unlimitedCPU Time: unlimited unlimitedProcess id: 229538 description * * * Running with the following parameters * * * 2014-09-25 16:09:01 INFO OGG-03035 Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.EXTRACT EORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) USERID ogg,PASSWORD * * EXTTRAIL. / dirdat/aaTABLE scott.emp_ogg;2014-09-25 16:09:01 INFO OGG-01815 Virtual Memory Facilities for: BR anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/BR/EORA_1. If there is an error while the process is running, the error code and detailed error diagnostic information are included in the report file. By finding the error code, you can help locate the cause of the error and solve the problem.

2. Ggserr.log log monitoring

(1) you can view the log file in the following ways.

You can view the ggserr.log file directly through operating system commands.

Use GoldenGate Director.

Run the command view ggsevt in GGSCI.

(2) the contents that can be seen in the log file are as follows.

The history of GGSCI commands.

Start and stop the GoldenGate process.

Processing that has been performed.

The mistake that happened.

Messages and warning messages.

(3) some contents of the log file

GGSCI (aix212) 1 > view ggsevt2014-09-23 15:02:08 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit param mg.2014-09-23 15:02:16 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit param mgr.2014-09-23 15:04:37 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit param mgr.2014-09-23 15:04:57 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.2014-09-23 15:04:58 INFO OGG-00983 Oracle GoldenGate Manager for Oracle Mgr.prm: Manager started (port 7809). 2014-09-23 15:06:09 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add extract eini_1 sourceistable.

Case study 1:

Destination replicat process startup exception

GGSCI (aix211) 16 > info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING REPLICAT ABENDED RORA_1 00:00:00 43:38:02

View the log:

Log 1:

2014-09-25 16:03:42 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/dirtmp.2014-09-25 16:03:42 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Checkpoint table ogg.checkpoint does not exist. Please create the table or recreate the RORA_1 group using the correct table.2014-09-25 16:03:42 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rora_1.prm: PROCESS ABENDING.

Unable to find checkpint table!

GGSCI (aix211) 2 > delete checkpointtableGGSCI (aix211) 3 > edit param. / GLOBALSCHECKPOINTTABLE ogg.checkpointGGSCI (aix211) 3 > exit must exit ggsci,checkpoint table to take effect [oracle@rh7 ogg] $. / ggsciGGSCI (aix211) 1 > dblogin userid ogg,password oggSuccessfully logged into database. GGSCI (aix211) 2 > add checkpointtableNo checkpointtable specified, using GLOBALS specification (ogg.checkpoint)... Successfully created checkpointtable ogg.checkpoint.

Restart the replicat process:

GGSCI (aix211) 16 > info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING REPLICAT ABENDED RORA_1 00:00:00 43:38:02

Failed to start, check the log!

Log 2:

[oracle@aix211 ogg] $tail ggserr.log 2014-09-25 16:11:47 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.2014-09-25 16:11:48 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 starting.2014-09-25 16:11:48 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.2014-09-25 16:11:48 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/dirtmp.2014-09-25 16:11:48 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle Rora_1.prm: No data selecting position from checkpoint table ogg.checkpoint for group 'RORA_1', key 1056363220 (0x3ef6d2d4), SQL. 2014-09-25 16:11:48 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rora_1.prm: PROCESS ABENDING.

Checkpointtable error!

Treatment method:

Delete replicat process: GGSCI (aix211) 7 > delete replicat rora_1Deleted REPLICAT RORA_1. Add a new replicat process: GGSCI (aix211) 8 > add replicat rora_1,exttrail. / dirdat/pa,checkpointtable ogg.checkpointREPLICAT added.GGSCI (aix211) 9 > edit param rora_1 "/ ogg/dirprm/rora_1.prm" 7 lines, 198 characters REPLICAT RORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) USERID ogg,PASSWORD oggHANDLECOLLISIONSASSUMETARGETDEFSDISCARDFILE. / dirrpt/RORA_aa.DSC,PURGEMAP scott.oem_ogg, TARGET scott.emp_ogg ~ restart the replicat process GGSCI (aix211) 10 > start replicat rora_1Sending START request to MANAGER... REPLICAT RORA_1 startingGGSCI (aix211) 11 > info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING REPLICAT RUNNING RORA_1 started at 00:00:00 00:00:03 successfully!

View the ogg log:

GGSCI (aix211) 12 > view ggsevt

2014-09-25 16:25:13 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.2014-09-25 16:25:13 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 starting.2014-09-25 16:25:13 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.2014-09-25 16:25:13 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/dirtmp.2014-09-25 16:25:13 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 started.

Case study 2:

Source initialization process (eini_1) and destination initialization process (rini_1)

Initialization process rini_1 on the destination side:

GGSCI (aix211) 13 > info rini_1REPLICAT RINI_1 Initialized 2014-09-23 15:40 Status STOPPEDCheckpoint Lag 00:00:00 (updated 48:46:37 ago) Log Read Checkpoint Not AvailableTask SPECIALRUN

Source initialization process eini_1:

GGSCI (aix212) 21 > info eini_1EXTRACT EINI_1 Last Started 2014-09-25 16:09 Status STOPPEDCheckpoint Lag Not AvailableLog Read Checkpoint Table SCOTT.EMP_OGG 2014-09-25 16:09:35 Record 14Task SOURCEISTABLE

Start the source initialization process:

GGSCI (aix212) 22 > start eini_1Sending START request to MANAGER... EXTRACT EINI_1 startingGGSCI (aix212) 23 > info eini_1EXTRACT EINI_1 Last Started 2014-09-25 16:09 Status RUNNINGCheckpoint Lag Not AvailableLog Read Checkpoint Table SCOTT.EMP_OGG 2014-09-25 16:09:35 Record 14Task SOURCEISTAB

After the process starts, the target initialization process starts automatically!

GGSCI (aix211) 14 > info rini_1REPLICAT RINI_1 Initialized 2014-09-23 15:40 Status RUNNINGCheckpoint Lag 00:00:00 (updated 48:47:03 ago) Log Read Checkpoint Not AvailableTask SPECIALRUN

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.