Start Golden Gate After clone from RAC to Single Instance

#
# GG extrat process was in STOPPED status and wasn't starting with error:
#

2014-01-28 10:04:31 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, extract1.prm: No valid default archive log destination directory found for thread 2.
2014-01-28 10:04:31 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, extract1.prm: Default thread stack size: 0.
2014-01-28 10:04:31 INFO OGG-00547 Oracle GoldenGate Capture for Oracle, extract1.prm: Increasing thread stack size from 0 to 1048576.

GGSCI (loaddb1) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT ABENDED dpdump1 00:00:00 17:43:15
EXTRACT STOPPED extract1 00:00:00 00:15:01
REPLICAT STOPPED replicat1 00:00:00 00:27:23

#
# Check the current status
#

GGSCI (loaddb1) 2> info extract1 showch
EXTRACT extract1 Initialized 2014-01-27 16:34 Status STOPPED
Checkpoint Lag 00:00:00 (updated 15:56:46 ago)
Log Read Checkpoint Oracle Redo Logs
2014-01-27 16:34:51 Thread 1, Seqno 0, RBA 0
SCN 0.0 (0)

Current Checkpoint Detail:
Read Checkpoint #1
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 0
RBA: 0
Timestamp: 2014-01-27 16:34:51.000000
SCN: Not available
Redo File: +FRA/db1/onlinelog/group_27.1992.820882421
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 0
RBA: 0
Timestamp: 2014-01-27 16:34:51.000000
SCN: Not available
Redo File: +FRA/db1/onlinelog/group_27.1992.820882421
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 0
RBA: 0
Timestamp: 2014-01-27 16:34:51.000000
SCN: Not available
Redo File: +FRA/db1/onlinelog/group_27.1992.820882421
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 400
RBA: 0
Timestamp: 2014-01-23 13:15:07.882279
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Header:
Version = 2
Record Source = U
Type = 11
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2014-01-27 16:34:51
Last Update Time = 2014-01-27 16:34:51
Stop Status = G
Last Result = 400

GGSCI (loaddb1) 3> view report extract1

***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.6 16211226 OGGCORE_11.2.1.0.6_PLATFORMS_130418.1829_FBO
Solaris, sparc, 64bit (optimized), Oracle 10g on Apr 22 2013 13:23:14
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

Starting at 2014-01-27 16:49:27
***********************************************************************
Operating System Version:
SunOS
Version Generic_142909-17, Release 5.10
Node: loaddb1
Machine: sun4u
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 18836
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2014-01-27 16:49:27 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_GB, LC_ALL: en_GB.UTF-8.
2014-01-27 16:49:27 INFO OGG-02696 NON-ANSI SQL parameter syntax is used for parameter parsing.
extract extract1
userid gguser_1, password *************
2014-01-27 16:49:27 INFO OGG-03500 WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of AL32UTF8.
discardfile /app/oracle/product/10.2.0/goldengate/dirrpt/extract1.dsc, purge
exttrail /app/oracle/product/10.2.0/goldengate/dirdat/ab
TRANLOGOPTIONS DBLOGREADER
tranlogoptions excludeuser gguser_1
tranlogoptions excludeuser gguser_2
tranlogoptions _NOREADAHEAD CURRENT
ReportCount Every 30 minutes, Rate
ReportCount Every 10000 records
Report at 01:00
ReportRollOver at 01:15
obey tabs_emp.ob
TABLE EMP.AUD_TAB1getbeforecols(on update keyincluding (gg_tstamp), on delete keyincluding (gg_tstamp));
TABLE EMP.AUD_TAB2getbeforecols(on update keyincluding (gg_tstamp), on delete keyincluding (gg_tstamp));
...
2014-01-27 16:49:28 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.
2014-01-27 16:49:28 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:
/app/oracle/product/10.2.0/goldengate/BR/extract1.
Bounded Recovery Parameter:
Options = BRRESET
BRINTERVAL = 4HOURS
BRDIR = /app/oracle/product/10.2.0/goldengate
2014-01-27 16:49:28 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:
/app/oracle/product/10.2.0/goldengate/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 31.72G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 39.72G
CACHESIZEMAX (strict force to disk): 35.72G
2014-01-27 16:49:30 WARNING OGG-01842 CACHESIZE PER DYNAMIC DETERMINATION (31.72G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 39.72G
Check swap space. Recommended swap/extract: 128G (64bit system).
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Solaris: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
Database Language and Character Set:
NLS_LANG = ".AL32UTF8"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
Maximum supported ASM read buffer size is 4096 KB
2014-01-27 16:49:31 WARNING OGG-01423 No valid default archive log destination directory found for thread 2.
Maximum supported ASM read buffer size is 4096 KB
2014-01-27 16:49:31 INFO OGG-00546 Default thread stack size: 0.
2014-01-27 16:49:31 INFO OGG-00547 Increasing thread stack size from 0 to 1048576.

#
#Try and start it for both threads
#

GGSCI (loaddb1) 5> info extract1
EXTRACT extract1 Initialized 2014-01-27 16:34 Status STOPPED
Checkpoint Lag 00:00:00 (updated 16:00:02 ago)
Log Read Checkpoint Oracle Redo Logs
2014-01-27 16:34:51 Thread 1, Seqno 0, RBA 0
SCN 0.0 (0)

GGSCI (loaddb1) 2> alter extract extract1, thread 1, begin now;
EXTRACT altered.

GGSCI (loaddb1) 3> alter extract extract1, thread 2, begin now;
EXTRACT altered.

GGSCI (loaddb1) 4> alter extract extract1, thread 1, extrba 0;
EXTRACT altered.

GGSCI (loaddb1) 5> alter extract extract1, thread 2, extrba 0;
EXTRACT altered.

#
# See if it is still using two threads?
#

SQL> desc v$loghist;
Name Null? Type
----------------------------------------- -------- ----------------------------
THREAD# NUMBER
SEQUENCE# NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SWITCH_CHANGE# NUMBER
SQL> select THREAD#, SEQUENCE#, to_char(FIRST_TIME,'dd-mon-yy hh24:mi:ss') from v$loghist order by SEQUENCE# ;
THREAD# SEQUENCE# TO_CHAR(FIRST_TIME,'DD-MON-
---------- ---------- ---------------------------
2 1 24-jan-14 15:59:31
1 1 24-jan-14 15:59:31
2 2 24-jan-14 16:04:03
1 2 24-jan-14 16:01:50
1 3 24-jan-14 16:03:20
2 3 27-jan-14 14:07:50
1 4 24-jan-14 16:06:08
2 4 27-jan-14 14:16:30
1 5 27-jan-14 14:04:51
2 5 27-jan-14 14:23:59
1 6 27-jan-14 14:06:10
2 6 27-jan-14 14:26:18
1 7 27-jan-14 14:07:22
1 8 27-jan-14 14:09:54
1 9 27-jan-14 14:11:03
1 10 27-jan-14 14:16:15
1 11 27-jan-14 14:17:05
1 12 27-jan-14 14:21:28
1 13 27-jan-14 14:21:54
1 14 27-jan-14 14:22:20
1 15 27-jan-14 14:23:59
1 16 27-jan-14 14:24:24
1 17 27-jan-14 14:26:03
1 18 27-jan-14 14:33:48
1 19 27-jan-14 14:36:08
1 20 27-jan-14 15:40:25
1 21 27-jan-14 15:40:30
1 22 27-jan-14 15:40:31
1 23 27-jan-14 15:40:37
1 24 27-jan-14 16:32:45
1 25 27-jan-14 16:32:49
1 26 27-jan-14 16:32:50
1 27 27-jan-14 16:32:54

#
# Tell GG to start from sequence 9
#

GGSCI (loaddb1) 8> alter extract extract1, thread 1, extseqno 9, extrba 0;
EXTRACT altered.

GGSCI (loaddb1) 9> alter extract extract1, thread 1, ioextseqno 9, ioextrba 0
2014-01-28 08:49:11 INFO OGG-00988 WARNING: Unsupported operation. This might cause transactional inconsistency. Modifying input checkpoint #1, Oracle thread #1 of EXTRACT: ioseq = 9 iorba = 0.
Are you sure you want to continue? yes
EXTRACT altered.

GGSCI (loaddb1) 1> info extract1 showch
EXTRACT extract1 Initialized 2014-01-28 08:49 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:10:11 ago)
Log Read Checkpoint Oracle Redo Logs
2014-01-28 08:39:34 Thread 1, Seqno 9, RBA 0
SCN 0.0 (0)

Current Checkpoint Detail:
Read Checkpoint #1
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 9
RBA: 0
Timestamp: 2014-01-28 08:39:34.000000
SCN: Not available
Redo File: +FRA/db1/onlinelog/group_27.1992.820882421
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 9
RBA: 0
Timestamp:
SCN: Not available
Redo File:
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 9
RBA: 0
Timestamp: 2014-01-28 08:39:34.000000
SCN: Not available
Redo File: +FRA/db1/onlinelog/group_27.1992.820882421
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 400
RBA: 0
Timestamp: 2014-01-23 13:15:07.882279
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Header:
Version = 2
Record Source = U
Type = 11
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2014-01-28 08:49:11
Last Update Time = 2014-01-28 08:49:11
Stop Status = G
Last Result = 400

#
# Still STOPPED
#

GGSCI (loaddb1) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT ABENDED dpdump1 00:00:00 17:43:15
EXTRACT STOPPED extract1 00:00:00 00:15:01
REPLICAT STOPPED replicat1 00:00:00 00:27:23


#Check the threads in v$log

SQL> select THREAD#, STATUS , ENABLED , SEQUENCE#, to_char(LAST_REDO_TIME,'dd-mon-yy hh24:mi:ss') from v$thread;
THREAD# STATUS ENABLED SEQUENCE# TO_CHAR(LAST_REDO_TIME,'DD-
---------- ------ -------- ---------- ---------------------------
1 OPEN PUBLIC 28 28-jan-14 10:00:15
2 CLOSED PRIVATE 7
SQL> select * from v$log

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 2 7 104857600 2 YES ACTIVE 1.2000E+13 28-JAN-14
2 2 6 104857600 2 YES INACTIVE 1.2000E+13 27-JAN-14
24 1 29 524288000 2 NO CURRENT 1.2000E+13 28-JAN-14
25 1 26 524288000 2 YES INACTIVE 1.2000E+13 27-JAN-14
26 1 28 524288000 2 YES ACTIVE 1.2000E+13 27-JAN-14
27 1 27 524288000 2 YES INACTIVE 1.2000E+13 27-JAN-14
6 rows selected.

#
# Drop the groups from thread 2
#

SQL> alter database disable thread 2;
SQL> alter database drop logfile group 1;
SQL> alter database drop logfile group 2;
SQL> select * from v$log
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
24 1 29 524288000 2 NO CURRENT 1.2000E+13 28-JAN-14
25 1 26 524288000 2 YES INACTIVE 1.2000E+13 27-JAN-14
26 1 28 524288000 2 YES INACTIVE 1.2000E+13 27-JAN-14
27 1 27 524288000 2 YES INACTIVE 1.2000E+13 27-JAN-14
SQL> select THREAD#, STATUS , ENABLED , SEQUENCE#, to_char(LAST_REDO_TIME,'dd-mon-yy hh24:mi:ss') from v$thread;
THREAD# STATUS ENABLED SEQUENCE# TO_CHAR(LAST_REDO_TIME,'DD-
---------- ------ -------- ---------- ---------------------------
1 OPEN PUBLIC 31 28-jan-14 10:11:23

#
# Done at sametime, not sure if it effected GG - Defer state 2
#

SQL> show parameter arch
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=+FRA
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string DEFER

#
# check cluster is FALSE
#

SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string

#
# start GG from latest sequence#28
#

GGSCI (loaddb1) 3> alter extract extract1, thread 1, extseqno 28, extrba 0;
EXTRACT altered.

GGSCI (loaddb1) 4> alter extract extract1, thread 1, ioextseqno 28, ioextrba 0;
2014-01-28 10:16:57 INFO OGG-00988 WARNING: Unsupported operation. This might cause transactional inconsistency. Modifying input checkpoint #1, Oracle thread #1 of EXTRACT: ioseq = 28 iorba = 0.
Are you sure you want to continue? yes
EXTRACT altered.
GGSCI (loaddb1) 5> info extract1 showch
EXTRACT extract1 Initialized 2014-01-28 10:16 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:17 ago)
Log Read Checkpoint Oracle Redo Logs
2014-01-28 10:12:50 Thread 1, Seqno 28, RBA 0
SCN 0.0 (0)

Current Checkpoint Detail:
Read Checkpoint #1
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 28
RBA: 0
Timestamp: 2014-01-28 10:12:50.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 28
RBA: 0
Timestamp:
SCN: Not available
Redo File:
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 28
RBA: 0
Timestamp: 2014-01-28 10:12:50.000000
SCN: Not available
Redo File:
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 400
RBA: 0
Timestamp: 2014-01-23 13:15:07.882279
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
GGSCI (loaddb1) 7> start extract1
Sending START request to MANAGER ...
EXTRACT extract1 starting

GGSCI (loaddb1) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT ABENDED dpdump1 00:00:00 17:43:02
EXTRACT RUNNING extract1 00:00:00 00:00:55
REPLICAT STOPPED replicat1 00:00:00 00:27:10

GGSCI (loaddb1) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT ABENDED dpdump1 00:00:00 17:43:15
EXTRACT RUNNING extract1 00:00:00 00:00:01
REPLICAT STOPPED replicat1 00:00:00 00:27:23

2014-01-28 10:17:52 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT extract1 starting.
2014-01-28 10:17:52 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, extract1.prm: EXTRACT extract1 starting.
2014-01-28 10:17:52 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, extract1.prm: Operating system character set identified as UTF-8. Locale: en_GB, LC_ALL: en_GB.UTF-8.
2014-01-28 10:17:52 INFO OGG-02696 Oracle GoldenGate Capture for Oracle, extract1.prm: NON-ANSI SQL parameter syntax is used for parameter parsing.
2014-01-28 10:17:52 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, extract1.prm: WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of AL32UTF8.
2014-01-28 10:17:53 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, extract1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2014-01-28 10:17:53 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, extract1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/app/oracle/product/10.2.0/goldengate/BR/extract1.
2014-01-28 10:17:53 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, extract1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/app/oracle/product/10.2.0/goldengate/dirtmp.
2014-01-28 10:17:54 WARNING OGG-01842 Oracle GoldenGate Capture for Oracle, extract1.prm: CACHESIZE PER DYNAMIC DETERMINATION (31.69G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 39.69G
Check swap space. Recommended swap/extract: 128G (64bit system).
2014-01-28 10:17:55 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, extract1.prm: Default thread stack size: 0.
2014-01-28 10:17:55 INFO OGG-00547 Oracle GoldenGate Capture for Oracle, extract1.prm: Increasing thread stack size from 0 to 1048576.
2014-01-28 10:17:55 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, extract1.prm: Positioning to (Thread 1) Sequence 28, RBA 0, SCN 0.0.
2014-01-28 10:17:55 INFO OGG-01560 Oracle GoldenGate Capture for Oracle, extract1.prm: Positioned to (Thread 1) Sequence 28, RBA 0, SCN 0.0.
2014-01-28 10:17:55 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, extract1.prm: EXTRACT extract1 started.
2014-01-28 10:17:55 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, extract1.prm: No recovery is required for target file /app/oracle/product/10.2.0/goldengate/dirdat/ab000400, at RBA 0 (file not opened).
2014-01-28 10:17:55 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, extract1.prm: Output file /app/oracle/product/10.2.0/goldengate/dirdat/ab is using format RELEASE 11.2.
2014-01-28 10:17:55 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, extract1.prm: Position of first record processed for Thread 1, Sequence 28, RBA 1040, SCN 2793.4165226232, 27 Jan 2014 16:33:00.
 
GGSCI (loaddb1) 1> info extract1 showch
EXTRACT extract1 Last Started 2014-01-28 10:17 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint Oracle Redo Logs
2014-01-28 10:20:11 Thread 1, Seqno 31, RBA 124928
SCN 2793.4165288953 (12000008946681)

Current Checkpoint Detail:
Read Checkpoint #1
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 28
RBA: 0
Timestamp:
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 31
RBA: 124432
Timestamp: 2014-01-28 10:20:11.000000
SCN: 2793.4165288953 (12000008946681)
Redo File: +FRA/db1/onlinelog/group_27.4055.837705615
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 31
RBA: 124928
Timestamp: 2014-01-28 10:20:11.000000
SCN: 2793.4165288953 (12000008946681)
Redo File: +FRA/db1/onlinelog/group_27.4055.837705615
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 400
RBA: 1041
Timestamp: 2014-01-28 10:20:18.137470
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab

#
# Check the DP process aswell
#

loaddb1-oracle> cd $GG_HOME
loaddb1-oracle> ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.6 16211226 OGGCORE_11.2.1.0.6_PLATFORMS_130418.1829_FBO
Solaris, sparc, 64bit (optimized), Oracle 10g on Apr 22 2013 12:48:48
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
GGSCI (loaddb1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING dpdump1 00:00:00 00:00:06
EXTRACT RUNNING extract1 00:00:00 00:00:07
REPLICAT RUNNING replicat1 00:00:00 00:00:02

GGSCI (loaddb1) 2> info dpdump1 showch
EXTRACT dpdump1 Last Started 2014-01-28 16:15 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint File /app/oracle/product/10.2.0/goldengate/dirdat/ab000398
First Record RBA 46564677

Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 398
RBA: 46564677
Timestamp: Not Available
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Current Checkpoint (position of last record read in the data source):
Sequence #: 398
RBA: 46564677
Timestamp: Not Available
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 398
RBA: 1144
Timestamp: 2014-01-29 13:17:55.488472
Extract Trail: /u05/goldengate/dirdat/ab
Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 0
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2014-01-28 16:15:54
Last Update Time = 2014-01-29 13:17:55
Stop Status = A
Last Result = 400
 

#
# Still showing as stuck on the old trail file, so tell GG to rollover
#

GGSCI (loaddb1) 3> send extract dpdump1, rollover
Sending ROLLOVER request to EXTRACT dpdump1 ...
Request processed.

GGSCI (loaddb1) 4> view report dpdump1

Opened new report file at 2014-01-29 01:15:00.

***********************************************************************
** Run Time Messages **
***********************************************************************

2014-01-29 13:19:12 INFO OGG-01021 Command received from GGSCI: ROLLOVER.
2014-01-29 13:19:12 INFO OGG-01026 Rolling over remote file /u05/goldengate/dirdat/ab000399.

GGSCI (loaddb1) 5> info dpdump1 showch
EXTRACT dpdump1 Last Started 2014-01-28 16:15 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /app/oracle/product/10.2.0/goldengate/dirdat/ab000398
First Record RBA 46564677

Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 398
RBA: 46564677
Timestamp: Not Available
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Current Checkpoint (position of last record read in the data source):
Sequence #: 398
RBA: 46564677
Timestamp: Not Available
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 399
RBA: 1084
Timestamp: 2014-01-29 13:20:27.018805
Extract Trail: /u05/goldengate/dirdat/ab
Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 0
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2014-01-28 16:15:54
Last Update Time = 2014-01-29 13:20:27
Stop Status = A
Last Result = 400
GGSCI (loaddb1) 3> info extract dpdump1, detail
EXTRACT dpdump1 Last Started 2014-01-28 16:15 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /app/oracle/product/10.2.0/goldengate/dirdat/ab000398
First Record RBA 46564677
Target Extract Trails:
Remote Trail Name Seqno RBA Max MB
/u05/goldengate/dirdat/ab 399 1084 100
Extract Source Begin End
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 * Initialized * First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 * Initialized * First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-27 16:34 First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-27 16:34 2014-01-27 16:34
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-27 16:34 2014-01-27 16:34
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-27 16:34 2014-01-27 16:34
/app/oracle/product/10.2.0/goldengate/dirdat/ab000000 * Initialized * 2014-01-27 16:34
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-27 15:26 2014-01-27 15:26
/app/oracle/product/10.2.0/goldengate/dirdat/ab000000 * Initialized * 2014-01-27 15:26
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-23 13:07 2014-01-23 13:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-23 13:07 2014-01-23 13:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-23 13:07 2014-01-23 13:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2014-01-23 13:07 2014-01-23 13:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000398 2013-12-20 13:37 2014-01-23 13:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000397 2013-12-10 13:52 2013-12-20 13:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000393 2013-12-10 13:22 2013-12-10 13:52
/app/oracle/product/10.2.0/goldengate/dirdat/ab000392 2013-11-30 04:00 2013-12-10 13:22
/app/oracle/product/10.2.0/goldengate/dirdat/ab000352 2013-11-15 14:30 2013-11-30 04:00
/app/oracle/product/10.2.0/goldengate/dirdat/ab000344 2013-11-15 13:55 2013-11-15 14:30
/app/oracle/product/10.2.0/goldengate/dirdat/ab000343 2013-11-15 11:37 2013-11-15 13:55
/app/oracle/product/10.2.0/goldengate/dirdat/ab000342 2013-11-05 19:37 2013-11-15 11:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000339 2013-11-05 10:37 2013-11-05 19:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000338 2013-11-01 11:22 2013-11-05 10:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000336 2013-10-25 11:35 2013-11-01 11:22
/app/oracle/product/10.2.0/goldengate/dirdat/ab000333 2013-10-23 15:35 2013-10-25 11:35
/app/oracle/product/10.2.0/goldengate/dirdat/ab000332 2013-10-21 10:35 2013-10-23 15:35
/app/oracle/product/10.2.0/goldengate/dirdat/ab000331 2013-10-17 08:01 2013-10-21 10:35
/app/oracle/product/10.2.0/goldengate/dirdat/ab000000 * Initialized * 2013-10-17 08:01
/app/oracle/product/10.2.0/goldengate/dirdat/ab000329 2013-10-14 17:22 2013-10-16 08:18
/app/oracle/product/10.2.0/goldengate/dirdat/ab000324 2013-10-14 17:22 2013-10-14 17:22
/app/oracle/product/10.2.0/goldengate/dirdat/ab000324 2013-10-10 15:37 2013-10-14 17:22
/app/oracle/product/10.2.0/goldengate/dirdat/ab000309 2013-10-08 11:22 2013-10-10 15:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000308 2013-10-01 18:07 2013-10-08 11:22
/app/oracle/product/10.2.0/goldengate/dirdat/ab000307 2013-09-19 15:07 2013-10-01 18:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000246 2013-08-22 03:22 2013-09-19 15:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000237 * Initialized * 2013-08-22 03:22
/app/oracle/product/10.2.0/goldengate/dirdat/ab000234 * Initialized * First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000233 2013-08-08 17:52 2013-08-13 15:52
/app/oracle/product/10.2.0/goldengate/dirdat/ab000231 2013-08-07 20:37 2013-08-08 17:52
/app/oracle/product/10.2.0/goldengate/dirdat/ab000230 * Initialized * 2013-08-07 20:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000230 * Initialized * First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000230 * Initialized * First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000229 * Initialized * 2013-08-04 01:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000229 2013-08-03 17:37 2013-08-04 01:07
/app/oracle/product/10.2.0/goldengate/dirdat/ab000228 2013-08-03 16:52 2013-08-03 17:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000227 2013-08-03 14:52 2013-08-03 16:52
/app/oracle/product/10.2.0/goldengate/dirdat/ab000226 2013-08-03 08:22 2013-08-03 14:52
/app/oracle/product/10.2.0/goldengate/dirdat/ab000225 2013-08-01 16:02 2013-08-03 08:22
/app/oracle/product/10.2.0/goldengate/dirdat/ab000222 2013-07-31 13:59 2013-08-01 16:02
/app/oracle/product/10.2.0/goldengate/dirdat/ab000219 2013-07-25 15:46 2013-07-31 13:59
/app/oracle/product/10.2.0/goldengate/dirdat/ab000156 2013-07-24 04:00 2013-07-25 15:46
/app/oracle/product/10.2.0/goldengate/dirdat/ab000145 2013-07-22 09:41 2013-07-24 04:00
/app/oracle/product/10.2.0/goldengate/dirdat/ab000139 2013-07-22 04:00 2013-07-22 09:41
/app/oracle/product/10.2.0/goldengate/dirdat/ab000137 2013-07-15 13:24 2013-07-22 04:00
/app/oracle/product/10.2.0/goldengate/dirdat/ab000135 2013-07-15 04:00 2013-07-15 13:24
/app/oracle/product/10.2.0/goldengate/dirdat/ab000134 * Initialized * 2013-07-15 04:00
/app/oracle/product/10.2.0/goldengate/dirdat/ab000134 * Initialized * First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000134 * Initialized * First Record
/app/oracle/product/10.2.0/goldengate/dirdat/ab000133 2013-07-09 19:37 2013-07-11 10:13
/app/oracle/product/10.2.0/goldengate/dirdat/ab000077 * Initialized * 2013-07-09 19:37
/app/oracle/product/10.2.0/goldengate/dirdat/ab000000 * Initialized * First Record

Current directory /app/oracle/product/10.2.0/goldengate
Report file /app/oracle/product/10.2.0/goldengate/dirrpt/dpdump1.rpt
Parameter file /app/oracle/product/10.2.0/goldengate/dirprm/dpdump1.prm
Checkpoint file /app/oracle/product/10.2.0/goldengate/dirchk/dpdump1.cpe
Process file /app/oracle/product/10.2.0/goldengate/dirpcs/dpdump1.pce
Stdout file /app/oracle/product/10.2.0/goldengate/dirout/dpdump1.out
Error log /app/oracle/product/10.2.0/goldengate/ggserr.log

#
# Stop the extract and issue the begin now and start again
#

GGSCI (loaddb1) 7> stop extract dpdump1
Sending STOP request to EXTRACT dpdump1 ...
Request processed.
GGSCI (loaddb1) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED dpdump1 00:00:00 00:00:01
EXTRACT RUNNING extract1 00:00:00 00:00:04
REPLICAT RUNNING replicat1 00:00:00 00:00:06

GGSCI (loaddb1) 9> alter extract dpdump1 begin now;
EXTRACT altered.

GGSCI (loaddb1) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED dpdump1 00:00:00 00:00:03
EXTRACT RUNNING extract1 00:00:00 00:00:04
REPLICAT RUNNING replicat1 00:00:00 00:00:06

GGSCI (loaddb1) 11> start extract dpdump1
Sending START request to MANAGER ...
EXTRACT dpdump1 starting

GGSCI (loaddb1) 12> info dpdump1 showch
EXTRACT dpdump1 Last Started 2014-01-29 13:24 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:14 ago)
Log Read Checkpoint File /app/oracle/product/10.2.0/goldengate/dirdat/ab000405
2014-01-29 13:24:43.000000 RBA 1945

Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 405
RBA: 1945
Timestamp: 2014-01-29 13:24:43.000000
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Current Checkpoint (position of last record read in the data source):
Sequence #: 405
RBA: 1945
Timestamp: 2014-01-29 13:24:43.000000
Extract Trail: /app/oracle/product/10.2.0/goldengate/dirdat/ab
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 399
RBA: 1084
Timestamp: 2014-01-29 13:24:35.992647
Extract Trail: /u05/goldengate/dirdat/ab
Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 0
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2014-01-29 13:24:55
Last Update Time = 2014-01-29 13:24:43
Stop Status = A
Last Result = 400
#
# All replicating ok
#
GGSCI (loaddb1) 13> info extract dpdump1
EXTRACT dpdump1 Last Started 2014-01-29 13:24 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File /app/oracle/product/10.2.0/goldengate/dirdat/ab000405
2014-01-29 13:24:43.000000 RBA 1945

GGSCI (loaddb1) 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING dpdump1 00:00:00 00:00:03
EXTRACT RUNNING extract1 00:00:00 00:00:00
REPLICAT RUNNING replicat1 00:00:00 00:00:04