Oracle online redo log files contain both
committed as well as uncommitted transactions, but Oracle GoldenGate only writes committed
transactions to the trail files.
Oracle
GoldenGate has two kinds of recovery
Normal
Recovery:
where the extract process needs all the
archive log files starting from the current recovery read checkpoint of the
extract
Bounded
Recovery:
Bounded Recovery (BR) Interval for an extract which by default is 4
hours and every 4 hours the extract process will makes a Bounded Recovery
checkpoint.
Setup
DDL in Source Database Server:
[oracle@ggnode ~]$ source 11g.env
[oracle@ggnode ~]$ cd $GG
[oracle@ggnode 11g]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on
Sat May 2 14:51:05 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining
and Real Application Testing options
SQL> sho user
USER is "SYS"
Execute script-1:
SQL> @marker_setup.sql
Enter
Oracle GoldenGate schema name:ogguser
Execute script-2:
SQL> @ddl_setup.sql
Enter
Oracle GoldenGate schema name:ogguser
Execute script-3:
SQL> @ddl_setup.sql
Enter
Oracle GoldenGate schema name:ogguser
Execute script-4:
SQL> @role_setup.sql
Enter
GoldenGate schema name:ogguser
GRANT GGS_GGSUSER_ROLE TO
<loggedUser>
where <loggedUser> is the user
assigned to the GoldenGate processes.
SQL> GRANT GGS_GGSUSER_ROLE TO ogguser;
Grant succeeded.
Execute script-5:
SQL> @ddl_enable.sql
Trigger altered.
Execute script-6:
SQL> @ddl_pin.sql ogguser
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Execute script-7:
SQL> @marker_status.sql
Please enter the name of a schema for the
GoldenGate database objects:
Setting schema name to OGGUSER
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Execute script-8:
SQL> @ddl_status.sql
Please enter the name of a schema for the
GoldenGate database objects:
Ogguser
Login Into
target database server (12c)
[oracle@ggnode ~]$ source 12c.env
[oracle@ggnode ~]$ sqlplus / as sysdba
SQL> CREATE TABLE GGS_SETUP (PROPERTY VARCHAR2(100),
VALUE VARCHAR2(4000));
Table created.
SQL> INSERT INTO GGS_SETUP VALUES
('DDL_TRACE_LEVEL', '0');
1 row created.
SQL> INSERT INTO GGS_SETUP VALUES
('DDL_SQL_TRACING', '0');
1 row created.
SQL> INSERT INTO GGS_SETUP VALUES ('_USEALLKEYS',
'0');
1 row created.
SQL> INSERT INTO GGS_SETUP VALUES ('_LIMIT32K',
'0');
1 row created.
SQL> INSERT INTO GGS_SETUP VALUES
('DDL_STAYMETADATA', 'OFF');
1 row created.
SQL> commit;
Commit complete.
Login Into
Source Database Server (GGSCI Prompt)
[oracle@ggnode 11g]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.0
OGGCORE_11.2.1.0.0_PLATFORMS_120131.1910_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Feb 1 2012 00:55:59
Copyright (C) 1995, 2012, Oracle and/or its affiliates.
All rights reserved.
GGSCI (ggnode.oracle.com) 1> dblogin userid ogguser, password oracle
Successfully logged into database.
GGSCI (ggnode.oracle.com) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORCL 00:00:00
00:00:03
EXTRACT RUNNING PORCL 00:00:00 00:00:07
Note: add this the below in EORCL extract process and
create the directory “dirbr” under $GG directory
BR BRDIR
./dirbr BRINTERVAL 5M
GGSCI (ggnode.oracle.com) 11> view param eorcl
extract eorcl
exttrail ./dirdat/lt
userid ogguser, password oracle
BR BRDIR ./dirbr BRINTERVAL 5M
table scott.*;
[oracle@ggnode 11g]$ cat /u01/app/ogg/11g/ggserr.log
Got the following error:
2015-05-02
14:41:25 ERROR OGG-01386
Oracle GoldenGate Capture for Oracle, eorcl.prm: Value for BRINTERVAL must be between
20MINUTES and 96HOURS.
Changed
from 5M to 20M in Bounded Recovery Time
GGSCI (ggnode.oracle.com) 11> view param eorcl
extract eorcl
exttrail ./dirdat/lt
userid ogguser, password oracle
BR BRDIR ./dirbr BRINTERVAL 20M
table scott.*;
SQL> connect scott/oracle@orcl
Connected.
SQL> create table myobjects
(
OBJECT_ID NUMBER,
OBJECT_NAME VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23))
/
Table created.
SQL> insert into myobjects select
object_id,object_name,object_type from dba_objects;
75264 rows created.
Checked
archive log files generated or not in source database server
[oracle@ggnode 2015_05_02]$ pwd
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2015_05_02
[oracle@ggnode 2015_05_02]$ ls -lrth
total 66M
-rw-r----- 1 oracle oinstall 20M May 2 14:10 o1_mf_1_9_bn93d8wx_.arc
-rw-r----- 1 oracle oinstall 46M May 2 14:40 o1_mf_1_10_bn954kob_.arc
Note: Again created some of the objects in “scott”
schema to generate archive log files
SQL> create table myobjects1
(
OBJECT_ID NUMBER,
OBJECT_NAME VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23));
Table created.
SQL> insert into myobjects1 select
object_id,object_name,object_type from dba_objects;
75265 rows created.
SQL> create table myobjects2
(
OBJECT_ID NUMBER,
OBJECT_NAME VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23));
Table created.
SQL> insert into myobjects2 select object_id,object_name,object_type
from dba_objects;
75266 rows created.
SQL> create table myobjects3
(
OBJECT_ID NUMBER,
OBJECT_NAME VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23));
Table created.
SQL> insert into myobjects3 select
object_id,object_name,object_type from dba_objects;
75267 rows created.
SQL> create table myobjects4
(
OBJECT_ID NUMBER,
OBJECT_NAME VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23));
Table created.
SQL> insert into myobjects4 select
object_id,object_name,object_type from dba_objects;
75268 rows created.
SQL> create table myobjects5
(
OBJECT_ID NUMBER,
OBJECT_NAME VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23));
Table created.
SQL> insert into myobjects5 select
object_id,object_name,object_type from dba_objects;
75269 rows created.
Note: “Commit” has not given in Source Database Server.
Because of these tables archive log no : 11 generated
SQL> !
[oracle@ggnode 11g]$ cd /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2015_05_02
[oracle@ggnode 2015_05_02]$ ls -lrth
total 107M
-rw-r----- 1 oracle oinstall 20M May 2 14:10 o1_mf_1_9_bn93d8wx_.arc
-rw-r----- 1 oracle oinstall 46M May 2 14:40 o1_mf_1_10_bn954kob_.arc
-rw-r----- 1 oracle oinstall 42M May 2 15:21 o1_mf_1_11_bn97jjyk_.arc
Login Into
RMAN from source database server and taken backup of archive log (11) and
deleted from the disk
[oracle@ggnode 2015_05_02]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on
Sat May 2 15:21:39 2015
Copyright (c) 1982, 2011, Oracle and/or its
affiliates. All rights reserved.
connected to target database: ORCL (DBID=1406171494)
RMAN> backup archivelog sequence 11 delete input;
Starting backup at 02-MAY-15
using target database control file instead of recovery
catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=49 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in
backup set
input archived log thread=1 sequence=11 RECID=6
STAMP=878656875
channel ORA_DISK_1: starting piece 1 at 02-MAY-15
channel ORA_DISK_1: finished piece 1 at 02-MAY-15
piece
handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2015_05_02/o1_mf_annnn_TAG20150502T153639_bn98fj4q_.bkp
tag=TAG20150502T153639 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:
00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file
name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2015_05_02/o1_mf_1_11_bn97jjyk_.arc
RECID=6 STAMP=878656875
Finished backup at 02-MAY-15
RMAN> exit
Login into Scott Schema in source database server and
give “commit”
SQL> commit;
Commit complete.
SQL> select count(*) from myobjects;
COUNT(*)
----------
75264
1 row selected.
SQL> select count(*) from myobjects1;
COUNT(*)
----------
75265
1 row selected.
SQL> select count(*) from myobjects2;
COUNT(*)
----------
75266
1 row selected.
SQL> select count(*) from myobjects3;
COUNT(*)
----------
75267
1 row selected.
SQL> select count(*) from myobjects4;
COUNT(*)
----------
75268
1 row selected.
SQL> select count(*) from myobjects5;
COUNT(*)
----------
75269
1 row selected.
Check the Bounded Recovery Directory in Oracle Golden
Gate Home:
[oracle@ggnode EORCL]$ pwd
/u01/app/ogg/11g/dirbr/BR/EORCL
[oracle@ggnode EORCL]$ ls -lrth
total 20K
drwxrwxr-x 2 oracle oinstall 4.0K May 2 14:41 stale
-rw-rw---- 1 oracle oinstall 64K May
2 15:53 CP.EORCL.000000003
Note the
trail files generated in source database server
[oracle@ggnode 11g]$ cd dirdat/
[oracle@ggnode dirdat]$ ls -lrth
total 67M
-rw-rw-rw- 1 oracle oinstall 1.2K May 2 14:13 lt000000
-rw-rw-rw- 1 oracle oinstall 1.1K May 2 14:44 lt000001
-rw-rw-rw- 1 oracle oinstall 1.1K May 2 14:53 lt000002
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:17 lt000003
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:17 lt000004
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:20 lt000006
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:20 lt000005
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:20 lt000008
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:20 lt000007
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:20 lt000009
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:20 lt000011
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:20 lt000010
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:21 lt000013
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:21 lt000012
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:37 lt000014
-rw-rw-rw- 1 oracle oinstall 4.8M May 2 15:37 lt000015
-rw-rw-rw- 1 oracle oinstall 4.7M May 2 15:37 lt000016
Login into target database server (12c) and check the
tables and count
SQL> select count(*) from MYOBJECTS;
COUNT(*)
----------
75264
SQL> select count(*) from MYOBJECTS1;
COUNT(*)
----------
75265
SQL> select count(*) from MYOBJECTS2;
COUNT(*)
----------
75266
SQL> select count(*) from MYOBJECTS3;
COUNT(*)
----------
75267
SQL> select count(*) from MYOBJECTS4;
COUNT(*)
----------
75268
SQL> select count(*) from MYOBJECTS5;
COUNT(*)
----------
75269
[oracle@ggnode ~]$ source 12c.env
[oracle@ggnode ~]$ cd $GG
[oracle@ggnode 12c]$ cd dirdat/
[oracle@ggnode dirdat]$ ls -lrth
total 67M
-rw-r----- 1 oracle oinstall 1.3K May 2 14:14 rt000000
-rw-r----- 1 oracle oinstall 1.3K May 2 14:41 rt000001
-rw-r----- 1 oracle oinstall 1.3K May 2 14:53 rt000002
-rw-r----- 1 oracle oinstall 4.8M May 2 15:17 rt000003
-rw-r----- 1 oracle oinstall 4.8M May 2 15:17 rt000004
-rw-r----- 1 oracle oinstall 4.8M May 2 15:20 rt000006
-rw-r----- 1 oracle oinstall 4.8M May 2 15:20 rt000005
-rw-r----- 1 oracle oinstall 4.8M May 2 15:20 rt000008
-rw-r----- 1 oracle oinstall 4.8M May 2 15:20 rt000007
-rw-r----- 1 oracle oinstall 4.8M May 2 15:20 rt000010
-rw-r----- 1 oracle oinstall 4.8M May 2 15:20 rt000009
-rw-r----- 1 oracle oinstall 4.8M May 2 15:20 rt000011
-rw-r----- 1 oracle oinstall 4.8M May 2 15:21 rt000013
-rw-r----- 1 oracle oinstall 4.8M May 2 15:21 rt000012
-rw-r----- 1 oracle oinstall 4.8M May 2 15:37 rt000015
-rw-r----- 1 oracle oinstall 4.8M May 2 15:37 rt000014
-rw-r----- 1 oracle oinstall 4.7M May 2 15:37 rt000016
[oracle@ggnode dirdat]$ pwd
So, Tables and Data successfully transferred from
source database server (11g) to target database server (12c) after deleting
archive log files from the source database server. Data has moved because of
Bounded Recovery (BR) functionality.
GGSCI (ggnode.oracle.com) 28> !
info eorcl showch
EXTRACT
EORCL Last Started 2015-05-02
14:53 Status RUNNING
Checkpoint Lag
00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint
Oracle Redo Logs
2015-05-02 15:37:40 Seqno 12, RBA
7660544
SCN 0.1174681 (1174681)
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Redo Log
Startup
Checkpoint (starting position in the data source):
Thread #: 1
Sequence #:
11
RBA: 8525328
Timestamp:
2015-05-02 14:53:02.000000
SCN:
0.1170390 (1170390)
Redo File:
/u01/app/oracle/oradata/orcl/redo02.log
Recovery
Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #:
12
RBA: 7660048
Timestamp:
2015-05-02 15:37:40.000000
SCN:
0.1174681 (1174681)
Redo File:
/u01/app/oracle/oradata/orcl/redo03.log
Current
Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #:
12
RBA: 7660544
Timestamp:
2015-05-02 15:37:40.000000
SCN:
0.1174681 (1174681)
Redo File:
/u01/app/oracle/oradata/orcl/redo03.log
BR Previous
Recovery Checkpoint:
Thread #: 0
Sequence #: 0
RBA: 0
Timestamp:
2015-05-02 14:53:30.606674
SCN: Not
available
Redo File:
BR Begin
Recovery Checkpoint:
Thread #: 0
Sequence #:
11
RBA: 39571472
Timestamp:
2015-05-02 15:21:11.000000
SCN: 0.1173346 (1173346)
Redo File:
BR End Recovery
Checkpoint:
Thread #: 1
Sequence #:
12
RBA: 7307776
Timestamp:
2015-05-02 15:33:10.000000
SCN:
0.1174151 (1174151)
Redo File:
Write Checkpoint #1
GGS Log Trail
Current
Checkpoint (current write position):
Sequence #:
16
RBA: 4878345
Timestamp:
2015-05-02 15:37:45.665800
Extract
Trail: ./dirdat/lt
Header:
Version = 2
Record Source =
A
Type = 10
# 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 =
2015-05-02 14:53:30
Last Update
Time = 2015-05-02 15:37:45
Stop Status = A
Last Result =
400
GGSCI (ggnode.oracle.com) 29>
View the
report of Extract (EORCL) from source database server
GGSCI (ggnode.oracle.com) 30> view report eorcl
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version
11.2.1.0.0 OGGCORE_11.2.1.0.0_PLATFORMS_120131.1910_FBO
Linux, x64,
64bit (optimized), Oracle 11g on Feb 1
2012 01:04:34
Copyright (C) 1995, 2012, Oracle and/or its affiliates.
All rights reserved.
Starting at 2015-05-02 14:53:30
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Wed Feb 22 17:37:40 EST 2012, Release
2.6.32-300.10.1.el5uek
Node: ggnode.oracle.com
Machine: x86_64
soft limit hard limit
Address Space Size
: unlimited unlimited
Heap Size
: unlimited unlimited
File Size
: unlimited unlimited
CPU Time
: unlimited unlimited
Process id: 5100
Description:
***********************************************************************
**
Running with the following parameters **
***********************************************************************
2015-05-02 14:53:30
INFO OGG-03035 Operating system character set identified as
UTF-8. Locale: en_US, LC_ALL:.
extract eorcl
exttrail ./dirdat/lt
userid ogguser, password ******
DDL INCLUDE ALL;
DDLOPTIONS ADDTRANDATA, REPORT
BR BRDIR ./dirbr BRINTERVAL 20M
table scott.*;
2015-05-02 14:53:30
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:
/u01/app/ogg/11g/dirbr/BR/EORCL.
Bounded Recovery Parameter:
BRINTERVAL = 20M
BRDIR =
./dirbr
2015-05-02 14:53:30
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:
/u01/app/ogg/11g/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
Database Version:
Oracle Database 11g Enterprise Edition Release
11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE
11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Database Language and Character Set:
NLS_LANG
= ".AL32UTF8"
NLS_LANGUAGE
= "AMERICAN"
NLS_TERRITORY
= "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
2015-05-02 14:53:30
WARNING OGG-01423 No valid default
archive log destination directory found for thread 1.
2015-05-02 14:53:30
INFO OGG-01513 Positioning to Sequence 11, RBA 8525328, SCN
0.1170390.
2015-05-02 14:53:30
INFO OGG-01516 Positioned to Sequence 11, RBA 8525328, SCN
0.1170390, May 2, 2015 2:53:02 PM.
2015-05-02 14:53:30
INFO OGG-01055 Recovery initialization completed for target
file ./dirdat/lt000002, at RBA 1098.
2015-05-02 14:53:30
INFO OGG-01478 Output file ./dirdat/lt is using format
RELEASE 11.2.
2015-05-02 14:53:30
INFO OGG-01026 Rolling over remote file ./dirdat/lt000002.
2015-05-02 14:53:30
INFO OGG-01053 Recovery completed for target file
./dirdat/lt000003, at RBA 1098.
2015-05-02 14:53:30
INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
**
Run Time Messages **
***********************************************************************
2015-05-02 14:53:30
INFO OGG-01517 Position of first record processed Sequence
11, RBA 8525328, SCN 0.1170390, May 2, 2015 2:53:02 PM.
TABLE resolved (entry ogguser.GGS_MARKER):
TABLE
"OGGUSER"."GGS_MARKER";
Using the following key columns for source table
OGGUSER.GGS_MARKER: SEQNO, FRAGMENTNO, OPTIME.
2015-05-02 15:04:44
INFO OGG-01487 DDL found, operation [create table sample (no
number) (size 32)], start SCN [1170966],
commit SCN [1171028] instance [orcl (1)], DDL seqno [12], mar
ker seqno [12].
2015-05-02 15:04:44
INFO OGG-00487 DDL operation included [INCLUDE ALL], optype
[CREATE], objtype [TABLE], objowner [SCOTT], objname [SAMPLE].
2015-05-02 15:04:44
INFO OGG-00497 Writing DDL operation to extract trail file.
2015-05-02 15:04:46
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.SAMPLE], operation [ALTER TABLE "SCOTT"."SAMPLE" ADD
SUPPLEMENTAL LOG GROUP "GGT_76941" ("NO") ALWAYS
/* GOLDENGATE_DDL_REPLICATION */ (size 115)].
2015-05-02 15:04:46
INFO OGG-00477 Successfully added TRAN DATA for table [SCOTT.SAMPLE],
operation [ALTER TABLE "SCOTT"."SAMPLE" ADD SUPPLEMENTAL
LOG DATA (ALL) COLUMNS /* GOLDENGATE
_DDL_REPLICATION */ (size 102)].
2015-05-02 15:04:46
INFO OGG-00479 Successfully deleted TRAN DATA for [CREATE]
DDL operation, table [SCOTT.SAMPLE], operation [ALTER TABLE
"SCOTT"."SAMPLE" DROP SUPPLEMENTAL LOG GROUP
"GGT_76941"
/* GOLDENGATE_DDL_REPLICATION */ (size 102)].
2015-05-02 15:06:49
INFO OGG-01487 DDL found, operation [create table myobjects
(
OBJECT_ID NUMBER,
OBJECT_NAME
VARCHAR2(128),
OBJECT_TYPE
VARCHAR2(23)) (size 215)], start
SCN [1171618], commit SCN [1171633] instance [orcl (1)], DDL seqno [18], marker
seqno [18].
2015-05-02 15:06:49
INFO OGG-00487 DDL operation included [INCLUDE ALL], optype
[CREATE], objtype [TABLE], objowner [SCOTT], objname [MYOBJECTS].
2015-05-02 15:06:49
INFO OGG-00497 Writing DDL operation to extract trail file.
2015-05-02 15:06:49
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS], operation [ALTER TABLE "SCOTT"."MYOBJECTS"
ADD SUPPLEMENTAL LOG GROUP "GGT_76942" ("OBJECT_
ID","OBJECT_NAME","OBJECT_TYPE")
ALWAYS /* GOLDENGATE_DDL_REPLICATION */
(size 153)].
2015-05-02 15:06:49
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS], operation [ALTER TABLE "SCOTT"."MYOBJECTS"
ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS
/* GOLD
ENGATE_DDL_REPLICATION */ (size 105)].
2015-05-02 15:06:49
INFO OGG-00479 Successfully deleted TRAN DATA for [CREATE]
DDL operation, table [SCOTT.MYOBJECTS], operation [ALTER TABLE "SCOTT"."MYOBJECTS"
DROP SUPPLEMENTAL LOG
GROUP "GGT_76942" /* GOLDENGATE_DDL_REPLICATION */ (size 105)].
2015-05-02 15:07:45
INFO OGG-01021 Command received from GGSCI: SHOWTRANS.
2015-05-02 15:13:39
INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool
1: p5100_extr: start=SeqNo: 11, RBA: 13176336, SCN: 0.1171730 (1171730),
Timestamp: 2015-05-02 15:06:58
.000000, end=SeqNo: 11, RBA: 17458176, SCN: 0.1172106
(1172106), Timestamp: 2015-05-02 15:13:09.000000, Thread: 1.
Wildcard TABLE resolved (entry scott.*):
table
"SCOTT"."MYOBJECTS";
2015-05-02 15:17:22
WARNING OGG-00869 No unique key
is defined for table 'MYOBJECTS'. All viable columns will be used to represent
the key, but may not guarantee uniqueness.
KEYCOLS may
be used to define the key.
Using the following key columns for source table
SCOTT.MYOBJECTS: OBJECT_ID, OBJECT_NAME, OBJECT_TYPE.
2015-05-02 15:17:22
INFO OGG-01026 Rolling over remote file ./dirdat/lt000003.
2015-05-02 15:17:23
INFO OGG-01026 Rolling over remote file ./dirdat/lt000004.
2015-05-02 15:19:49
INFO OGG-01487 DDL found, operation [create table myobjects1
(
OBJECT_ID
NUMBER,
OBJECT_NAME
VARCHAR2(128),
OBJECT_TYPE
VARCHAR2(23))
(size 217)],
start SCN [1172326], commit SCN [1172341] instance [orcl (1)], DDL seqno [24],
marker seqno [24].
2015-05-02 15:19:49
INFO OGG-00487 DDL operation included [INCLUDE ALL], optype
[CREATE], objtype [TABLE], objowner [SCOTT], objname [MYOBJECTS1].
2015-05-02 15:19:49
INFO OGG-00497 Writing DDL operation to extract trail file.
2015-05-02 15:19:49
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS1], operation [ALTER TABLE "SCOTT"."MYOBJECTS1"
ADD SUPPLEMENTAL LOG GROUP "GGT_76943" ("OBJEC
T_ID","OBJECT_NAME","OBJECT_TYPE")
ALWAYS /* GOLDENGATE_DDL_REPLICATION */
(size 154)].
2015-05-02 15:19:49
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS1], operation [ALTER TABLE "SCOTT"."MYOBJECTS1"
ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS
/* GO
LDENGATE_DDL_REPLICATION */ (size 106)].
2015-05-02 15:19:49
INFO OGG-00479 Successfully deleted TRAN DATA for [CREATE]
DDL operation, table [SCOTT.MYOBJECTS1], operation [ALTER TABLE
"SCOTT"."MYOBJECTS1" DROP SUPPLEMENTAL LO
G GROUP "GGT_76943" /* GOLDENGATE_DDL_REPLICATION */ (size 106)].
Wildcard TABLE resolved (entry scott.*):
table
"SCOTT"."MYOBJECTS1";
2015-05-02 15:20:05
WARNING OGG-00869 No unique key
is defined for table 'MYOBJECTS1'. All viable columns will be used to represent
the key, but may not guarantee uniqueness.
KEYCOLS may
be used to
define the key.
Using the following key columns for source table
SCOTT.MYOBJECTS1: OBJECT_ID, OBJECT_NAME, OBJECT_TYPE.
2015-05-02 15:20:05
INFO OGG-01026 Rolling over remote file ./dirdat/lt000005.
2015-05-02 15:20:05
INFO OGG-01026 Rolling over remote file ./dirdat/lt000006.
2015-05-02 15:20:05
INFO OGG-01487 DDL found, operation [create table myobjects2
(
OBJECT_ID
NUMBER,
OBJECT_NAME VARCHAR2(128),
OBJECT_TYPE
VARCHAR2(23))
(size 217)],
start SCN [1172513], commit SCN [1172525] instance [orcl (1)], DDL seqno [30],
marker seqno [30].
2015-05-02 15:20:05
INFO OGG-00487 DDL operation included [INCLUDE ALL], optype
[CREATE], objtype [TABLE], objowner [SCOTT], objname [MYOBJECTS2].
2015-05-02 15:20:05
INFO OGG-00497 Writing DDL operation to extract trail file.
2015-05-02 15:20:06
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS2], operation [ALTER TABLE
"SCOTT"."MYOBJECTS2" ADD SUPPLEMENTAL LOG GROUP
"GGT_76944" ("OBJEC
T_ID","OBJECT_NAME","OBJECT_TYPE")
ALWAYS /* GOLDENGATE_DDL_REPLICATION */
(size 154)].
2015-05-02 15:20:06
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS2], operation [ALTER TABLE
"SCOTT"."MYOBJECTS2" ADD SUPPLEMENTAL LOG DATA (ALL)
COLUMNS /* GO
LDENGATE_DDL_REPLICATION */ (size 106)].
2015-05-02 15:20:06
INFO OGG-00479 Successfully deleted TRAN DATA for [CREATE]
DDL operation, table [SCOTT.MYOBJECTS2], operation [ALTER TABLE
"SCOTT"."MYOBJECTS2" DROP SUPPLEMENTAL LO
G GROUP "GGT_76944" /* GOLDENGATE_DDL_REPLICATION */ (size 106)].
Wildcard TABLE resolved (entry scott.*):
table
"SCOTT"."MYOBJECTS2";
2015-05-02 15:20:26
WARNING OGG-00869 No unique key
is defined for table 'MYOBJECTS2'. All viable columns will be used to represent
the key, but may not guarantee uniqueness.
KEYCOLS may
be used to
define the key.
Using the following key columns for source table
SCOTT.MYOBJECTS2: OBJECT_ID, OBJECT_NAME, OBJECT_TYPE.
2015-05-02 15:20:26
INFO OGG-01026 Rolling over remote file ./dirdat/lt000007.
2015-05-02 15:20:26
INFO OGG-01026 Rolling over remote file ./dirdat/lt000008.
2015-05-02 15:20:27
INFO OGG-01487 DDL found, operation [create table myobjects3
(
OBJECT_ID
NUMBER,
OBJECT_NAME
VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23)) (size 216)], start SCN [1172875], commit SCN
[1172889] instance [orcl (1)], DDL seqno [36], marker seqno [36].
2015-05-02 15:20:27
INFO OGG-00487 DDL operation included [INCLUDE ALL], optype
[CREATE], objtype [TABLE], objowner [SCOTT], objname [MYOBJECTS3].
2015-05-02 15:20:27
INFO OGG-00497 Writing DDL operation to extract trail file.
2015-05-02 15:20:27
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS3], operation [ALTER TABLE "SCOTT"."MYOBJECTS3"
ADD SUPPLEMENTAL LOG GROUP "GGT_76945" ("OBJEC
T_ID","OBJECT_NAME","OBJECT_TYPE")
ALWAYS /* GOLDENGATE_DDL_REPLICATION */
(size 154)].
2015-05-02 15:20:27
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS3], operation [ALTER TABLE
"SCOTT"."MYOBJECTS3" ADD SUPPLEMENTAL LOG DATA (ALL)
COLUMNS /* GO
LDENGATE_DDL_REPLICATION */ (size 106)].
2015-05-02 15:20:27
INFO OGG-00479 Successfully deleted TRAN DATA for [CREATE]
DDL operation, table [SCOTT.MYOBJECTS3], operation [ALTER TABLE
"SCOTT"."MYOBJECTS3" DROP SUPPLEMENTAL LO
G GROUP "GGT_76945" /* GOLDENGATE_DDL_REPLICATION */ (size 106)].
Wildcard TABLE resolved (entry scott.*):
table
"SCOTT"."MYOBJECTS3";
2015-05-02 15:20:46
WARNING OGG-00869 No unique key
is defined for table 'MYOBJECTS3'. All viable columns will be used to represent
the key, but may not guarantee uniqueness.
KEYCOLS may
be used to
define the key.
Using the following key columns for source table
SCOTT.MYOBJECTS3: OBJECT_ID, OBJECT_NAME, OBJECT_TYPE.
2015-05-02 15:20:46
INFO OGG-01026 Rolling over remote file ./dirdat/lt000009.
2015-05-02 15:20:47
INFO OGG-01026 Rolling over remote file ./dirdat/lt000010.
2015-05-02 15:20:47
INFO OGG-01026 Rolling over remote file ./dirdat/lt000011.
2015-05-02 15:20:48
INFO OGG-01487 DDL found, operation [create table myobjects4
(
OBJECT_ID
NUMBER,
OBJECT_NAME
VARCHAR2(128),
OBJECT_TYPE VARCHAR2(23))
(size 216)], start SCN [1173046], commit SCN [1173060] instance [orcl
(1)], DDL seqno [42], marker seqno [42].
2015-05-02 15:20:48
INFO OGG-00487 DDL operation included [INCLUDE ALL], optype
[CREATE], objtype [TABLE], objowner [SCOTT], objname [MYOBJECTS4].
2015-05-02 15:20:48
INFO OGG-00497 Writing DDL operation to extract trail file.
2015-05-02 15:20:48
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS4], operation [ALTER TABLE "SCOTT"."MYOBJECTS4"
ADD SUPPLEMENTAL LOG GROUP "GGT_76946" ("OBJEC
T_ID","OBJECT_NAME","OBJECT_TYPE")
ALWAYS /* GOLDENGATE_DDL_REPLICATION */
(size 154)].
2015-05-02 15:20:48
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS4], operation [ALTER TABLE
"SCOTT"."MYOBJECTS4" ADD SUPPLEMENTAL LOG DATA (ALL)
COLUMNS /* GO
LDENGATE_DDL_REPLICATION */ (size 106)].
2015-05-02 15:20:49
INFO OGG-00479 Successfully deleted TRAN DATA for [CREATE]
DDL operation, table [SCOTT.MYOBJECTS4], operation [ALTER TABLE
"SCOTT"."MYOBJECTS4" DROP SUPPLEMENTAL LO
G GROUP "GGT_76946" /* GOLDENGATE_DDL_REPLICATION */ (size 106)].
Wildcard TABLE resolved (entry scott.*):
table
"SCOTT"."MYOBJECTS4";
2015-05-02 15:21:06
WARNING OGG-00869 No unique key
is defined for table 'MYOBJECTS4'. All viable columns will be used to represent
the key, but may not guarantee uniqueness.
KEYCOLS may
be used to
define the key.
Using the following key columns for source table
SCOTT.MYOBJECTS4: OBJECT_ID, OBJECT_NAME, OBJECT_TYPE.
2015-05-02 15:21:06
INFO OGG-01026 Rolling over remote file ./dirdat/lt000012.
2015-05-02 15:21:06
INFO OGG-01026 Rolling over remote file ./dirdat/lt000013.
2015-05-02 15:21:07
INFO OGG-01487 DDL found, operation [create table myobjects5
(
OBJECT_ID
NUMBER,
OBJECT_NAME
VARCHAR2(128),
OBJECT_TYPE
VARCHAR2(23)) (size 216)], start
SCN [1173226], commit SCN [1173242] instance [orcl (1)], DDL seqno [48], marker
seqno [48].
2015-05-02 15:21:07
INFO OGG-00487 DDL operation included [INCLUDE ALL], optype
[CREATE], objtype [TABLE], objowner [SCOTT], objname [MYOBJECTS5].
2015-05-02 15:21:07
INFO OGG-00497 Writing DDL operation to extract trail file.
2015-05-02 15:21:07
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS5], operation [ALTER TABLE "SCOTT"."MYOBJECTS5"
ADD SUPPLEMENTAL LOG GROUP "GGT_76947" ("OBJEC
T_ID","OBJECT_NAME","OBJECT_TYPE")
ALWAYS /* GOLDENGATE_DDL_REPLICATION */
(size 154)].
2015-05-02 15:21:07
INFO OGG-00477 Successfully added TRAN DATA for table
[SCOTT.MYOBJECTS5], operation [ALTER TABLE "SCOTT"."MYOBJECTS5"
ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS
/* GO
LDENGATE_DDL_REPLICATION */ (size 106)].
2015-05-02 15:21:07
INFO OGG-00479 Successfully deleted TRAN DATA for [CREATE]
DDL operation, table [SCOTT.MYOBJECTS5], operation [ALTER TABLE
"SCOTT"."MYOBJECTS5" DROP SUPPLEMENTAL LO
G GROUP "GGT_76947" /* GOLDENGATE_DDL_REPLICATION */ (size 106)].
2015-05-02 15:33:46
INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool
1: p5100_extr: start=SeqNo: 11, RBA: 39571472, SCN: 0.1173346 (1173346),
Timestamp: 2015-05-02 15:21:11
.000000, end=SeqNo: 12, RBA: 7307776, SCN: 0.1174151
(1174151), Timestamp: 2015-05-02 15:33:10.000000, Thread: 1.
Wildcard TABLE resolved (entry scott.*):
table
"SCOTT"."MYOBJECTS5";
2015-05-02 15:37:18
WARNING OGG-00869 No unique key
is defined for table 'MYOBJECTS5'. All viable columns will be used to represent
the key, but may not guarantee uniqueness.
KEYCOLS may
be used to
define the key.
Using the following key columns for source table
SCOTT.MYOBJECTS5: OBJECT_ID, OBJECT_NAME, OBJECT_TYPE.
2015-05-02 15:37:18
INFO OGG-01026 Rolling over remote file ./dirdat/lt000014.
2015-05-02 15:37:19
INFO OGG-01026 Rolling over remote file ./dirdat/lt000015.
GGSCI (ggnode.oracle.com) 31>
