oracle@san:pdb02:/u01/app/ggs02

> ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.7 16934304 OGGCORE_11.2.1.0.7_PLATFORMS_130709.1600.1_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Jul 18 2013 07:04:28

Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

GGSCI (san.localdomain) 1> obey config_site_b.oby

GGSCI (san.localdomain) 2> dblogin userid ggs@pdb02, password ggs

Successfully logged into database.

GGSCI (san.localdomain) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED

GGSCI (san.localdomain) 4> add checkpointtable

No checkpoint table specified, using GLOBALS specification (GGR.CHECKPOINT)...

Successfully created checkpoint table GGR.CHECKPOINT.

GGSCI (san.localdomain) 5> info checkpointtable

No checkpoint table specified, using GLOBALS specification (GGR.CHECKPOINT)...

Checkpoint table GGR.CHECKPOINT created 2013-08-12 08:40:24.

GGSCI (san.localdomain) 6> -- Primary Extract to local trail bb

GGSCI (san.localdomain) 7> ADD EXTRACT ebidibb, TRANLOG, BEGIN NOW

EXTRACT added.

GGSCI (san.localdomain) 8> ADD EXTTRAIL /u01/app/ggs02/dirdat/bb, EXTRACT ebidibb, MEGABYTES 500

EXTTRAIL added.

GGSCI (san.localdomain) 9> -- DataPump Extract reads from local trail bb; pump to remote trail ba

GGSCI (san.localdomain) 10> ADD EXTRACT pbidiba, EXTTRAILSOURCE /u01/app/ggs02/dirdat/bb

EXTRACT added.

GGSCI (san.localdomain) 11> ADD RMTTRAIL /u01/app/ggs01/dirdat/ba, EXTRACT pbidiba, MEGABYTES 500

RMTTRAIL added.

GGSCI (san.localdomain) 12> -- Replicat from pump pbidiab

GGSCI (san.localdomain) 13> ADD REPLICAT rbidiab, EXTTRAIL /u01/app/ggs02/dirdat/ab

REPLICAT added.

GGSCI (san.localdomain) 14> ADD TRANDATA hr.*

Logging of supplemental redo data enabled for table HR.COUNTRIES.

Logging of supplemental redo data enabled for table HR.DEPARTMENTS.

Logging of supplemental redo data enabled for table HR.EMPLOYEES.

Logging of supplemental redo data enabled for table HR.JOBS.

Logging of supplemental redo data enabled for table HR.JOB_HISTORY.

Logging of supplemental redo data enabled for table HR.LOCATIONS.

Logging of supplemental redo data enabled for table HR.REGIONS.

GGSCI (san.localdomain) 15> ADD TRANDATA sh.*

2013-08-11 17:40:35  WARNING OGG-00869  No unique key is defined for table 'CAL_MONTH_SALES_MV'. 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 SH.CAL_MONTH_SALES_MV.

2013-08-11 17:40:36  WARNING OGG-00869  No unique key is defined for table 'CHANNELS'. 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 SH.CHANNELS.

2013-08-11 17:40:37  WARNING OGG-00869  No unique key is defined for table 'COSTS'. 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 SH.COSTS.

2013-08-11 17:40:37  WARNING OGG-00869  No unique key is defined for table 'COUNTRIES'. 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 SH.COUNTRIES.

2013-08-11 17:40:37  WARNING OGG-00869  No unique key is defined for table 'CUSTOMERS'. 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 SH.CUSTOMERS.

2013-08-11 17:40:37  WARNING OGG-00869  No unique key is defined for table 'DIMENSION_EXCEPTIONS'. 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 SH.DIMENSION_EXCEPTIONS.

2013-08-11 17:40:37  WARNING OGG-00869  No unique key is defined for table 'DR$SUP_TEXT_IDX$I'. 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 SH.DR$SUP_TEXT_IDX$I.

Logging of supplemental redo data enabled for table SH.DR$SUP_TEXT_IDX$K.

Logging of supplemental redo data enabled for table SH.DR$SUP_TEXT_IDX$N.

2013-08-11 17:40:38  WARNING OGG-00869  No unique key is defined for table 'DR$SUP_TEXT_IDX$R'. 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 SH.DR$SUP_TEXT_IDX$R.

2013-08-11 17:40:38  WARNING OGG-00869  No unique key is defined for table 'FWEEK_PSCAT_SALES_MV'. 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 SH.FWEEK_PSCAT_SALES_MV.

2013-08-11 17:40:38  WARNING OGG-00869  No unique key is defined for table 'PRODUCTS'. 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 SH.PRODUCTS.

2013-08-11 17:40:38  WARNING OGG-00869  No unique key is defined for table 'PROMOTIONS'. 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 SH.PROMOTIONS.

2013-08-11 17:40:38  WARNING OGG-00869  No unique key is defined for table 'SALES'. 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 SH.SALES.

2013-08-11 17:40:38  WARNING OGG-00869  No unique key is defined for table 'SALES_TRANSACTIONS_EXT'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.

2013-08-11 17:40:38  WARNING OGG-00706  Failed to add supplemental log group on table SH.SALES_TRANSACTIONS_EXT due to ORA-30657: operation not supported on external organized table SQL ALTER TABLE "SH"."SALES_TRANSACTIONS_EXT" ADD SUPPLEMENTAL LOG GROUP "GGS_76797" ("PROD_ID","CUST_ID","TIME_ID","CHANNEL_ID","PROMO_ID","QUANTITY_SOLD","AMOUNT_SOLD","UNIT_COST","UNIT_PRICE") ALWAYS  /* GOLDENGATE_DDL_REPLICATION */.

2013-08-11 17:40:38  WARNING OGG-00869  No unique key is defined for table 'SUPPLEMENTARY_DEMOGRAPHICS'. 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 SH.SUPPLEMENTARY_DEMOGRAPHICS.

2013-08-11 17:40:39  WARNING OGG-00869  No unique key is defined for table 'TIMES'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.

2013-08-11 17:40:39  WARNING OGG-01387  Table SH.TIMES has no valid key columns, added unconditional supplemental log group for all table columns.

Logging of supplemental redo data enabled for table SH.TIMES.

GGSCI (san.localdomain) 16> ADD SCHEMATRANDATA hr

2013-08-11 17:40:40  INFO    OGG-01788  SCHEMATRANDATA has been added on schema hr.

GGSCI (san.localdomain) 17> ADD SCHEMATRANDATA sh

2013-08-11 17:40:41  INFO    OGG-01788  SCHEMATRANDATA has been added on schema sh.

GGSCI (san.localdomain) 18> info *

EXTRACT    EBIDIBB   Initialized   2013-08-11 17:40   Status STOPPED

Checkpoint Lag       00:00:00 (updated 00:00:16 ago)

Log Read Checkpoint  Oracle Redo Logs

                     2013-08-11 17:40:26  Seqno 0, RBA 0

                     SCN 0.0 (0)

EXTRACT    PBIDIBA   Initialized   2013-08-11 17:40   Status STOPPED

Checkpoint Lag       00:00:00 (updated 00:00:14 ago)

Log Read Checkpoint  File /u01/app/ggs02/dirdat/bb000000

                     First Record  RBA 0

REPLICAT   RBIDIAB   Initialized   2013-08-11 17:40   Status STOPPED

Checkpoint Lag       00:00:00 (updated 00:00:12 ago)

Log Read Checkpoint  File /u01/app/ggs02/dirdat/ab000000

                     First Record  RBA 0

GGSCI (san.localdomain) 19> start mgr

Manager started.

GGSCI (san.localdomain) 20> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EBIDIBB     00:00:00      00:00:04

EXTRACT     RUNNING     PBIDIBA     00:00:00      00:00:09

REPLICAT    RUNNING     RBIDIAB     unknown       00:00:00

GGSCI (san.localdomain) 21> exit