--源端数据库配置

[oracle@db12c ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Tue Apr 8 14:24:15 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

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

SQL> alter database add supplemental log data;

Database altered.

SQL> alter database force logging;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> create user c##ggadmin identified by ggadmin;

User created.

SQL> grant dba to c##ggadmin;

Grant succeeded.

SQL> exec dbms_goldengate_auth.grant_admin_privilege('C##GGADMIN',container=>'all');

PL/SQL procedure successfully completed.

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ZHONGWC1 READ WRITE NO
4 ZHONGWC2 READ WRITE NO
SQL> alter session set container=zhongwc1;

Session altered.

SQL> alter database add supplemental log data;

Database altered.

SQL> alter database add supplemental log data;

Database altered.

SQL> create user ggtest identified by ggtest;

User created.

SQL> grant dba to ggtest;

Grant succeeded.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ZHONGWC1 READ WRITE NO
SQL> conn ggtest/ggtest@zhongwc1
Connected.
SQL> create table tab01(sid number(8),sname varchar2(20));

Table created.

--源端ogg配置

[oracle@db12c ggs]$ 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 (db12c) 1> dblogin useridalias ggzhongwc1 --连到zhongwc1 PDB
Successfully logged into database ZHONGWC1.

GGSCI (db12c) 2> add schematrandata ggtest allcols

2014-04-08 14:37:57 INFO OGG-01788 SCHEMATRANDATA has been added on schema ggtest.

2014-04-08 14:37:57 INFO OGG-01976 SCHEMATRANDATA for scheduling columns has been added on schema ggtest.

2014-04-08 14:37:57 INFO OGG-01977 SCHEMATRANDATA for all columns has been added on schema ggtest.

GGSCI (db12c) 3> capture tabledef ggtest.tab01
Default catalog name ZHONGWC1 will be used for table specification ggtest.tab01.
Table definitions for ZHONGWC1.GGTEST.TAB01:
SID NUMBER (8)
SNAME VARCHAR (20)

GGSCI (db12c) 4> dblogin useridalias ggroot --连接CDB$ROOT
Successfully logged into database CDB$ROOT.

GGSCI (db12c) 5> register extract ext1 database container (zhongwc1) --Register the Integrated Extract
Extract EXT1 successfully registered with database at SCN 2014272.

--Add the Extract and Data Pump process groups

GGSCI (db12c) 7> add extract ext1 integrated tranlog, begin now
EXTRACT added.

GGSCI (db12c) 8> add exttrail ./dirdata/lt extract ext1
EXTTRAIL added.

GGSCI (db12c) 9> add extract extdp1 exttrailsource ./dirdat/lt, begin now
EXTRACT added.

GGSCI (db12c) 10> add rmttrail ./dirdat/rt extract extdp1
RMTTRAIL added.