标题: oracle12c configured Integrated Capture mode
链接: http://www.traveldba.com/archives/583
配置归档
<pre lang="sql">
SQL> alter system set log_archive_dest_1='location=/other/archivelog';
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2291472 bytes
Variable Size 230689008 bytes
Database Buffers 390070272 bytes
Redo Buffers 3276800 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database
2 open;
SQL> alter database force logging;
Database altered.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
</pre>
创建用户赋权
配置12c cdb的抽取用户必须在(cdb$root) 下
<pre lang="text">
Extract must connect to the root container (cdb$root) as a common user in order to
interact with the logmining server. To specify the root container, use the
appropriate SQL*Net connect string for the database user that you specify with the
USERID or USERIDALIAS parameter. For example: C##GGADMIN@FINANCE. See
Section 4, "Establishing Oracle GoldenGate Credentials" for how to create a user
for the Oracle GoldenGate processes and grant the correct privileges.
</pre>
<pre lang="sql">
SQL> create user c##goldengate identified by aa;
User created.
SQL> grant dba to c##goldengate
2 ;
Grant succeeded.
SQL> exec dbms_goldengate_auth.grant_admin_privilege('c##goldengate',container=>'all');
PL/SQL procedure successfully completed.
</pre>
创建测试用户
<pre lang="sql">
SQL> alter session set container=travel;
Session altered.
SQL> alter pluggable database travel open;
Pluggable database altered.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> create user goldengate identified by aa;
User created.
SQL> grant dba to goldengate;
Grant succeeded.
SQL> create user test identified by aa;
User created.
SQL> grant dba to test;
Grant succeeded.
SQL> conn test/aa@travel
Connected.
SQL> create table test(id number,name varchar2(20));
Table created.
</pre>
GoldenGate 配置
<pre lang="text">
[oracle@localhost ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
GGSCI (localhost.localdomain) 6> view params mgr
PORT 7809
GGSCI (localhost.localdomain) 8> dblogin userid goldengate@travel password aa
Successfully logged into database TRAVEL.
GGSCI (localhost.localdomain) 9> add trandata test.test
2013-10-24 15:36:58 WARNING OGG-06439 No unique key is defined for table TEST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table TRAVEL.TEST.TEST.
TRANDATA for scheduling columns has been added on table 'TRAVEL.TEST.TEST'
GGSCI (localhost.localdomain) 38> ADD EXTRACT ext1, INTEGRATED TRANLOG,BEGIN now -- Integrated Capture mode
EXTRACT added.
GGSCI (localhost.localdomain) 39> ADD EXTTRAIL ./dirdat/lt, EXTRACT ext1
EXTTRAIL added.
GGSCI (localhost.localdomain) 40> edit params ext1
GGSCI (localhost.localdomain) 41> register EXTRACT ext1 databas
ERROR: Invalid syntax for REGISTER command.
GGSCI (localhost.localdomain) 42> REGISTER EXTRACT ext1 DATABASE
ERROR: One or more containers must be specified when registering Extract for a container database.
GGSCI (localhost.localdomain) 43> REGISTER EXTRACT ext1 DATABASE CONTAINER (travel)
Extract EXT1 successfully registered with database at SCN 1099496843998.
GGSCI (localhost.localdomain) 51> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (localhost.localdomain) 52> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:04:51 00:00:07
GGSCI (localhost.localdomain) 53> view parameter ext1
ERROR: Invalid command.
GGSCI (localhost.localdomain) 54> view params ext1
EXTRACT ext1
USERID c##goldengate password aa
TRANLOGOPTIONS MININGUSER c##goldengate MININGPASSWORD aa
--TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 164, DOWNSTREAM_REAL_TIME_MINE y)
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
EXTTRAIL ./dirdat/lt
SOURCECATALOG travel
TABLE test.test;
</pre>
测试
<pre lang="text">
[oracle@localhost ~]$ sqlplus test/aa@travel
SQL*Plus: Release 12.1.0.1.0 Production on Thu Oct 24 16:02:51 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Thu Oct 24 2013 15:27:13 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
USERNAME INST_NAME HOST_NAME SID SERIAL# VERSION STARTED SPID OPID CPID SADDR PADDR
-------------------- ------------ ------------------------- ----- -------- ---------- -------- --------------- ----- --------------- ---------------- ----------------
TEST orcl localhost.localdomain 77 121 12.1.0.1.0 20131024 5093 7 5089 0000000084EE9F88 000000008523EB88
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
-------------------------------------------------------------------------------------------------------------------------------- ------- ----------
TEST TABLE
SQL> @desc test
Name Null? Type
------------------------------- -------- ----------------------------
1 ID NUMBER
2 NAME VARCHAR2(20)
SQL> insert into test values (1,'trave');
1 row created.
SQL> commit;
SQL> insert into test values (2,'trave');
1 row created.
SQL> insert into test values (3,'trave');
1 row created.
SQL> insert into test values (4,'trave');
1 row created.
SQL> commit;
Commit complete.
ogg 信息
Extracting from TRAVEL.TEST.TEST to TRAVEL.TEST.TEST:
*** Total statistics since 2013-10-24 16:03:42 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Daily statistics since 2013-10-24 16:03:42 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Hourly statistics since 2013-10-24 16:03:42 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Latest statistics since 2013-10-24 16:03:42 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
End of Statistics.
GGSCI (localhost.localdomain) 57> stats ext1
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2013-10-24 16:05:08.
Output to ./dirdat/lt:
Extracting from TRAVEL.TEST.TEST to TRAVEL.TEST.TEST:
*** Total statistics since 2013-10-24 16:03:42 ***
Total inserts 4.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Daily statistics since 2013-10-24 16:03:42 ***
Total inserts 4.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Hourly statistics since 2013-10-24 16:03:42 ***
Total inserts 4.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Latest statistics since 2013-10-24 16:03:42 ***
Total inserts 4.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
End of Statistics.
</pre>
ogg ggserr.log
<pre lang="text">
2013-10-24 15:59:52 INFO OGG-06495 Oracle GoldenGate Capture for Oracle, ext1.prm: OGG created a session pool with SESSIONPOOLMAX 10, SESSIONPOOLMIN 2 and SESSIONPOOLINCR 2.
2013-10-24 15:59:52 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 12.1.0.0.
2013-10-24 15:59:55 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, ext1.prm: Database does not have streams_pool_size initialization parameter configured.
2013-10-24 16:00:21 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2013-10-24 16:00:21 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated Dictionary will be used.
2013-10-24 16:00:21 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2013-10-24 16:00:21 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file ./dirdat/lt000000, at RBA 0 (file not opened).
2013-10-24 16:00:21 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file ./dirdat/lt is using format RELEASE 12.1.
2013-10-24 16:00:22 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2013-10-24 16:00:53 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
</pre>
数据库alert
<pre lang="text">
Logminer Bld: Lockdown Complete. DB_TXN_SCN is 255 4280182584 LockdownSCN is 1099496843064
Thu Oct 24 15:54:50 2013
Archived Log entry 1 added for thread 1 sequence 19 ID 0x5095899f dest 1:
Thu Oct 24 15:55:03 2013
Thu Oct 24 15:55:03 2013
Logminer Bld: Done
Thu Oct 24 15:55:03 2013
Logminer Bld: Build started
Thu Oct 24 15:55:03 2013
Logminer Bld: Lockdown Complete. DB_TXN_SCN is 255 4280183518 LockdownSCN is 1099496843998
Thu Oct 24 15:55:14 2013
Thu Oct 24 15:55:14 2013
Logminer Bld: Done
Thu Oct 24 15:55:14 2013
ALTER SYSTEM ARCHIVE LOG
Thu Oct 24 15:55:15 2013
Thread 1 advanced to log sequence 21 (LGWR switch)
Current log# 3 seq# 21 mem# 0: /oradata/orcl/redo03.log
Thu Oct 24 15:55:20 2013
Archived Log entry 2 added for thread 1 sequence 20 ID 0x5095899f dest 1:
Thu Oct 24 15:55:30 2013
GoldenGate Capture: OGG$CAP_EXT1 CAPTURE Created
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Start SCN: 1099496843998 (0xff1e6ade.000000ff)
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: First SCN: 1099496843064 (0xff1e6738.000000ff)
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Required Checkpoint SCN: 0 (0x0000.00000000)
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Captured SCN: 0 (0x0000.00000000)
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Applied SCN: 0 (0x0000.00000000)
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Capture Type: LOCAL
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Logminer Id: 1
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Source Database: TRAVEL
Thu Oct 24 15:55:30 2013
CAPTURE OGG$CAP_EXT1: Source Root Name: ORCL
Thu Oct 24 15:55:35 2013
GoldenGate Apply: OGG$EXT1 APPLY Created
Thu Oct 24 15:55:35 2013
APPLY OGG$EXT1: Apply User: C##GOLDENGATE
Thu Oct 24 15:55:35 2013
APPLY OGG$EXT1: Apply Tag: 00
alter database add supplemental log data(PRIMARY KEY,UNIQUE INDEX,FOREIGN KEY) columns
Completed: alter database add supplemental log data(PRIMARY KEY,UNIQUE INDEX,FOREIGN KEY) columns
Thu Oct 24 15:55:38 2013
Setting XOUT_CLIENT_EXISTS to Y for Capture: OGG$CAP_EXT1
Thu Oct 24 15:55:40 2013
ALTER SYSTEM ARCHIVE LOG
Thu Oct 24 15:55:40 2013
Thread 1 cannot allocate new log, sequence 22
Checkpoint not complete
Current log# 3 seq# 21 mem# 0: /oradata/orcl/redo03.log
Thu Oct 24 15:55:42 2013
Thread 1 advanced to log sequence 22 (LGWR switch)
Current log# 1 seq# 22 mem# 0: /oradata/orcl/redo01.log
Thu Oct 24 15:55:42 2013
Archived Log entry 3 added for thread 1 sequence 21 ID 0x5095899f dest 1:
Thu Oct 24 15:55:42 2013
GoldenGate CAPTURE CP01 for OGG$CAP_EXT1 started with pid=45, OS id=4632
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Start SCN: 1099496843998 (0xff1e6ade.000000ff)
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: First SCN: 1099496843064 (0xff1e6738.000000ff)
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Required Checkpoint SCN: 0 (0x0000.00000000)
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Captured SCN: 0 (0x0000.00000000)
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Applied SCN: 0 (0x0000.00000000)
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Capture Type: LOCAL
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Logminer Id: 1
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Source Database: TRAVEL
Thu Oct 24 15:55:42 2013
CAPTURE OGG$CAP_EXT1: Source Root Name: ORCL
Thu Oct 24 15:55:44 2013
First applied SCN of the GoldenGate path from capture (OGG$CAP_EXT1) to propagation () to apply (OGG$EXT1) is set to SCN: 1099496843064 (0xff1e6738.000000ff)
Thu Oct 24 15:55:47 2013
GoldenGate CAPTURE CP01 for OGG$CAP_EXT1 with pid=45, OS id=4632 is in combined capture and apply mode.
Thu Oct 24 15:55:47 2013
Capture OGG$CAP_EXT1 is handling 1 applies.
Thu Oct 24 15:55:47 2013
-- capture is running in apply-state checkpoint mode.
Thu Oct 24 15:55:51 2013
Starting persistent Logminer Session with sid = 1 for GoldenGate Capture OGG$CAP_EXT1
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 0, Transaction Chunk Size = 1
LOGMINER: Memory Size = 30M, Checkpoint interval = 1000M
LOGMINER: SpillScn 0, ResetLogScn 1720082
Thu Oct 24 15:55:51 2013
LOGMINER: summary for session# = 1
LOGMINER: StartScn: 1099496844939 (0x00ff.ff1e6e8b)
LOGMINER: EndScn: 0
LOGMINER: HighConsumedScn: 1099496843998 (0x00ff.ff1e6ade)
LOGMINER: session_flag: 0xb0
LOGMINER: DDL CKPT is on.
LOGMINER: Read buffers: 64
LOGMINER: Memory LWM limit: 10M, LWM 20M, 69%
LOGMINER: Memory Release Limit: 15000
LOGMINER: LowCkptScn: 0 (0x0000.00000000)
LOGMINER: HighCkptScn: 0 (0x0000.00000000)
LOGMINER: SkipScn: 1099496843064 (0x00ff.ff1e6738)
Thu Oct 24 15:55:52 2013
LOGMINER: Begin mining logfile during dictionary load for session 1 thread 1 sequence 20, /other/archivelog/1_20_824217892.dbf
Thu Oct 24 15:55:55 2013
LOGMINER: Preparing to load 2 dictionaries for session 1
Thu Oct 24 15:56:03 2013
Thread 1 cannot allocate new log, sequence 23
Checkpoint not complete
Current log# 1 seq# 22 mem# 0: /oradata/orcl/redo01.log
Thu Oct 24 15:56:06 2013
Thread 1 advanced to log sequence 23 (LGWR switch)
Current log# 2 seq# 23 mem# 0: /oradata/orcl/redo02.log
Thu Oct 24 15:56:11 2013
Archived Log entry 4 added for thread 1 sequence 22 ID 0x5095899f dest 1:
Thu Oct 24 15:56:20 2013
Thread 1 advanced to log sequence 24 (LGWR switch)
Current log# 3 seq# 24 mem# 0: /oradata/orcl/redo03.log
Thu Oct 24 15:56:26 2013
Archived Log entry 5 added for thread 1 sequence 23 ID 0x5095899f dest 1:
Thu Oct 24 15:56:33 2013
LOGMINER: Preparing to load next dictionary for session 1
Thu Oct 24 15:56:34 2013
Thread 1 advanced to log sequence 25 (LGWR switch)
Current log# 1 seq# 25 mem# 0: /oradata/orcl/redo01.log
Thu Oct 24 15:56:42 2013
Archived Log entry 6 added for thread 1 sequence 24 ID 0x5095899f dest 1:
Thu Oct 24 15:56:48 2013
Thread 1 advanced to log sequence 26 (LGWR switch)
Current log# 2 seq# 26 mem# 0: /oradata/orcl/redo02.log
Thu Oct 24 15:56:57 2013
Archived Log entry 7 added for thread 1 sequence 25 ID 0x5095899f dest 1:
Thu Oct 24 15:57:02 2013
Thread 1 advanced to log sequence 27 (LGWR switch)
Current log# 3 seq# 27 mem# 0: /oradata/orcl/redo03.log
Thu Oct 24 15:57:14 2013
LOGMINER: Finalizing dictionary load for session 1
Thu Oct 24 15:57:14 2013
Archived Log entry 8 added for thread 1 sequence 26 ID 0x5095899f dest 1:
Thu Oct 24 15:57:27 2013
Thread 1 advanced to log sequence 28 (LGWR switch)
Current log# 1 seq# 28 mem# 0: /oradata/orcl/redo01.log
Thu Oct 24 15:57:33 2013
Archived Log entry 9 added for thread 1 sequence 27 ID 0x5095899f dest 1:
Thu Oct 24 15:57:45 2013
LOGMINER: Gathering statistics on logminer dictionary.
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P366 (41570) VALUES LESS THAN (TO_DATE(' 2013-10-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
Thu Oct 24 15:58:34 2013
LOGMINER: Completed dictionary load for session 1
Thu Oct 24 15:58:35 2013
LOGMINER: End mining logfiles during dictionary load for session 1
Thu Oct 24 15:59:05 2013
CAPTURE OGG$CAP_EXT1: Session Restart SCN: 1099496843064
Thu Oct 24 15:59:07 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 20, /other/archivelog/1_20_824217892.dbf
Thu Oct 24 15:59:11 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 20, /other/archivelog/1_20_824217892.dbf
knlbmEnq: all subscribers are inactive - stop enqueuing. Capture Name: OGG$CAP_EXT1
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Start SCN: 1099496843998 (0xff1e6ade.000000ff)
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: First SCN: 1099496843064 (0xff1e6738.000000ff)
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Required Checkpoint SCN: 0 (0x0000.00000000)
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Captured SCN: 1099496843064 (0xff1e6738.000000ff)
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Applied SCN: 0 (0x0000.00000000)
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Capture Type: LOCAL
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Logminer Id: 1
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Source Database: TRAVEL
Thu Oct 24 15:59:13 2013
CAPTURE OGG$CAP_EXT1: Source Root Name: ORCL
Thu Oct 24 15:59:14 2013
CAPTURE OGG$CAP_EXT1: Bytes of Redo Mined: 35043788
Thu Oct 24 15:59:14 2013
CAPTURE OGG$CAP_EXT1: SGA Used: 11048152
Thu Oct 24 15:59:14 2013
CAPTURE OGG$CAP_EXT1: SGA Allocated: 31997944
Thu Oct 24 15:59:14 2013
GoldenGate CAPTURE CP01 for OGG$CAP_EXT1 with pid=45, OS id=4632 stopped
Thu Oct 24 15:59:15 2013
GoldenGate Capture:OGG$CAP_EXT1 cleared _SKIP_LCR_FOR_ASSERT
Thu Oct 24 15:59:15 2013
GoldenGate Capture: OGG$CAP_EXT1
setting IGNORE_UNSUPPORTED_TABLE for table (*)
Thu Oct 24 15:59:15 2013
GoldenGate Capture:OGG$CAP_EXT1 setting _FILTER_PARTIAL_ROLLBACK:
Thu Oct 24 15:59:15 2013
Thu Oct 24 15:59:15 2013
Setting XOUT_CLIENT_EXISTS to Y for Capture: OGG$CAP_EXT1
Thu Oct 24 15:59:54 2013
GoldenGate Capture:OGG$CAP_EXT1 cleared _SKIP_LCR_FOR_ASSERT
Thu Oct 24 15:59:54 2013
GoldenGate Capture: OGG$CAP_EXT1
setting IGNORE_UNSUPPORTED_TABLE for table (*)
Thu Oct 24 15:59:54 2013
GoldenGate Capture:OGG$CAP_EXT1 setting _FILTER_PARTIAL_ROLLBACK:
Thu Oct 24 15:59:54 2013
Thu Oct 24 15:59:54 2013
Setting XOUT_CLIENT_EXISTS to Y for Capture: OGG$CAP_EXT1
Thu Oct 24 15:59:56 2013
Starting persistent Logminer Session with sid = 1 for GoldenGate Capture OGG$CAP_EXT1 (OS id=4932).
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 4, Transaction Chunk Size = 1
LOGMINER: Memory Size = 449M, Checkpoint interval = 1000M
LOGMINER: SpillScn 0, ResetLogScn 1720082
Thu Oct 24 15:59:56 2013
LOGMINER: summary for session# = 1
LOGMINER: StartScn: 1099496843064 (0x00ff.ff1e6738)
LOGMINER: EndScn: 0
LOGMINER: HighConsumedScn: 1099496843998 (0x00ff.ff1e6ade)
LOGMINER: session_flag: 0x4f0
LOGMINER: DDL CKPT is on.
LOGMINER: Read buffers: 64
LOGMINER: Memory LWM limit: 10M, LWM 435M, 96%
LOGMINER: Memory Release Limit: 15000
LOGMINER: LowCkptScn: 0 (0x0000.00000000)
LOGMINER: HighCkptScn: 0 (0x0000.00000000)
LOGMINER: SkipScn: 1099496843064 (0x00ff.ff1e6738)
Thu Oct 24 15:59:56 2013
LOGMINER: session#=1 (OGG$CAP_EXT1), reader MS00 pid=58 OS id=4936 sid=59 started
Thu Oct 24 15:59:56 2013
LOGMINER: session#=1 (OGG$CAP_EXT1), builder MS01 pid=59 OS id=4940 sid=62 started
Thu Oct 24 15:59:56 2013
LOGMINER: session#=1 (OGG$CAP_EXT1), preparer MS02 pid=60 OS id=4944 sid=65 started
Thu Oct 24 15:59:56 2013
LOGMINER: session#=1 (OGG$CAP_EXT1), preparer MS03 pid=61 OS id=4948 sid=69 started
Thu Oct 24 16:00:21 2013
OGG Capture client successfully attached to GoldenGate Capture OGG$CAP_EXT1 to receive uncommitted changes with pid=57 OS id=4932.
Thu Oct 24 16:00:21 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 20, /other/archivelog/1_20_824217892.dbf
Thu Oct 24 16:00:22 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 20, /other/archivelog/1_20_824217892.dbf
Thu Oct 24 16:00:22 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 21, /other/archivelog/1_21_824217892.dbf
Thu Oct 24 16:00:25 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 21, /other/archivelog/1_21_824217892.dbf
Thu Oct 24 16:00:25 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 22, /other/archivelog/1_22_824217892.dbf
Thu Oct 24 16:00:40 2013
Thread 1 advanced to log sequence 29 (LGWR switch)
Current log# 2 seq# 29 mem# 0: /oradata/orcl/redo02.log
Thu Oct 24 16:00:47 2013
Archived Log entry 10 added for thread 1 sequence 28 ID 0x5095899f dest 1:
Thu Oct 24 16:00:53 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 22, /other/archivelog/1_22_824217892.dbf
Thu Oct 24 16:00:53 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 23, /other/archivelog/1_23_824217892.dbf
Thu Oct 24 16:00:59 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 23, /other/archivelog/1_23_824217892.dbf
Thu Oct 24 16:00:59 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 24, /other/archivelog/1_24_824217892.dbf
Thu Oct 24 16:01:07 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 24, /other/archivelog/1_24_824217892.dbf
Thu Oct 24 16:01:07 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 25, /other/archivelog/1_25_824217892.dbf
Thu Oct 24 16:01:13 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 25, /other/archivelog/1_25_824217892.dbf
Thu Oct 24 16:01:13 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 26, /other/archivelog/1_26_824217892.dbf
Thu Oct 24 16:01:22 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 26, /other/archivelog/1_26_824217892.dbf
Thu Oct 24 16:01:22 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 27, /oradata/orcl/redo03.log
Thu Oct 24 16:01:22 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 27, /oradata/orcl/redo03.log
Thu Oct 24 16:01:22 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 28, /oradata/orcl/redo01.log
Thu Oct 24 16:01:28 2013
LOGMINER: End mining logfile for session 1 thread 1 sequence 28, /oradata/orcl/redo01.log
Thu Oct 24 16:01:28 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 29, /oradata/orcl/redo02.log
</pre>