标题: 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>