oracle 12c goldengate 12c pdb1,pdb2 in same container 数据同步测试
$ sqlplus /nologSQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:25:11 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> alter system set enable_goldengate_replication=true;
System altered.
SQL> grant set container to c##ggadmin;
Grant succeeded.
SQL> grant dba to c##ggadmin;
Grant succeeded.
SQL> select privilege from dba_sys_privs where grantee = 'C##GGADMIN';
PRIVILEGE
----------------------------------------
DROP ANY EDITION
CREATE JOB
ALTER ANY TABLE
UNLIMITED TABLESPACE
ALTER SESSION
CREATE RULE SET
LOGMINING
SET CONTAINER
FLASHBACK ANY TABLE
CREATE ANY EDITION
CREATE RULE
PRIVILEGE
----------------------------------------
EXECUTE ANY RULE SET
CREATE EVALUATION CONTEXT
SELECT ANY TABLE
CREATE SESSION
DEQUEUE ANY QUEUE
UNLIMITED TABLESPACE
17 rows selected.
SQL> exec dbms_goldengate_auth.grant_admin_privilege('c##ggadmin','capture',container=>'all');
PL/SQL procedure successfully completed.
SQL> grant create session to c##ggadmin;
Grant succeeded.
SQL> grant alter session to c##ggadmin;
Grant succeeded.
SQL> grant set container to c##ggadmin;
Grant succeeded.
SQL> select privilege from dba_sys_privs where grantee = 'C##GGADMIN';
PRIVILEGE
----------------------------------------
CREATE JOB
ALTER ANY TABLE
UNLIMITED TABLESPACE
ALTER SESSION
CREATE RULE SET
LOGMINING
SET CONTAINER
FLASHBACK ANY TABLE
CREATE RULE
EXECUTE ANY RULE SET
CREATE EVALUATION CONTEXT
PRIVILEGE
----------------------------------------
SELECT ANY TABLE
CREATE SESSION
DEQUEUE ANY QUEUE
UNLIMITED TABLESPACE
15 rows selected.
SQL> alter user c##ggadmin default tablespace users;
User altered.
SQL> alter user c##ggadmin quota unlimited on users;
User altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
GGSCI (node1) 2> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
GGSCI (node1) 3> dblogin userid c#ggadmin,password oracle
ERROR: Unable to connect to database using user c#ggadmin. Please check privileges.
Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied.
GGSCI (node1) 4> dblogin userid c#ggadmin ,password oracle
ERROR: Unable to connect to database using user c#ggadmin. Please check privileges.
Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied.
GGSCI (node1) 5> dblogins userid c##ggadmin,password oracle
ERROR: Invalid command.
GGSCI (node1) 6> dblogin userid c##ggadmin,password oracle
Successfully logged into database CDB$ROOT.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7>
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7>
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7>
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 7>add extract ext1, integrated tranlog, begin now
EXTRACT (Integrated) added.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 8> register extract ext1 database container(pdb1)
2016-10-07 07:32:08INFO OGG-02003Extract EXT1 successfully registered with database at SCN 1879420.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 9> add schematrandata pdb1.source
2016-10-07 07:32:40ERROR OGG-01789Failed to ADD SCHEMATRANDATA on schema source, because schema does not exist.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 10> add schematrandata pdb1.test
2016-10-07 07:32:59INFO OGG-01788SCHEMATRANDATA has been added on schema test.
2016-10-07 07:32:59INFO OGG-01976SCHEMATRANDATA for scheduling columns has been added on schema test.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 11> add exttrail ./dirdat/ex, extract ext1
EXTTRAIL added.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 12> add checkpointtable pdb1.c##ggadmin.checkpoint
Successfully created checkpoint table pdb1.c##ggadmin.checkpoint.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 13> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:04:29
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 14> exit
$ sqlplus c##ggadmin/pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:36:14 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: ^C
$
$ sqlplus c##ggadmin/oracle@pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:36:33 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
$ cd
$ cd $ORACLE_HOME/network/admin
$ ls
listener.orasamplesshrept.lstsqlnet.oratnsnames.ora
$ vi tnsnames.ora
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DEV12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dev12c)
)
)
PDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb1)
)
)
PDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb2)
)
)
$
$
$ sqlplus c##ggadmin/oracle@pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:37:53 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
Last Successful login time: Fri Oct 07 2016 07:31:11 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> create user test identified by oracle account unlock;
User created.
SQL> alter user test quota unlimited on users;
User altered.
SQL> grant connect,resource,create session to test;
Grant succeeded.
SQL> connect test/oracle
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> connect test/oracle@pdb2
Connected.
SQL> create table source(id int primary key);
Table created.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
$ cd $GGHOME
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:07:58
GGSCI (node1) 2> view params ext1
ERROR: PARAMS file ext1 does not exist.
GGSCI (node1) 3> edit params ext1
GGSCI (node1) 4> viewparams ext1
ERROR: Invalid command.
GGSCI (node1) 5> view params ext1
EXTRACT ext1
USERID c##ggadmin, PASSWORD oracle
EXTTRAIL ./dirdat/ex
SOURCECATALOG pdb1
TABLE TEST.*;
GGSCI (node1) 6>
GGSCI (node1) 6> edit params rep1
GGSCI (node1) 7> view params rep1
REPLICAT rep1
USERID c##ggadmin@pdb2, password oracle
ASSUMETARGETDEFS
MAP pdb1.test.*, TARGET pdb2.test.*;
GGSCI (node1) 8>
GGSCI (node1) 8>
GGSCI (node1) 8> add replicat rep1, exttrail ./dirdat/ex, checkpointtable p002.c##ggadmin.checkpoint^[[D^[[1;5D^[[1;5D^[[1;5D^[[1;5D
ERROR: Invalid parameter specified for ADD REPLICAT.
GGSCI (node1) 9> add replicat rep1, exttrail ./dirdat/ex, checkpointtable pdb2.c##ggadmin.checkpoint
REPLICAT added.
GGSCI (node1) 10> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:10:45
REPLICAT STOPPED REP1 00:00:00 00:00:02
GGSCI (node1) 11> exit
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:42:53 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> exec dbms_goldengate_auth.grant_admin_privilege('c##ggadmin','apply',container=>'pdb2');
PL/SQL procedure successfully completed.
SQL>select privilege from dba_sys_privs where grantee = 'C##ggadmin';
no rows selected
SQL> select privilege from dba_sys_privs where grantee = 'C##GGADMIN';
PRIVILEGE
----------------------------------------
CREATE JOB
ALTER ANY TABLE
UNLIMITED TABLESPACE
ALTER SESSION
CREATE RULE SET
LOGMINING
SET CONTAINER
FLASHBACK ANY TABLE
CREATE RULE
EXECUTE ANY RULE SET
CREATE EVALUATION CONTEXT
PRIVILEGE
----------------------------------------
SELECT ANY TABLE
CREATE SESSION
DEQUEUE ANY QUEUE
UNLIMITED TABLESPACE
15 rows selected.
SQL> EXIT
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
$ GGSCI
-bash: GGSCI: command not found
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:12:39
REPLICAT STOPPED REP1 00:00:00 00:01:56
GGSCI (node1) 2> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (node1) 3> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:12:44
REPLICAT STOPPED REP1 00:00:00 00:02:02
GGSCI (node1) 4> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:12:47
REPLICAT STOPPED REP1 00:00:00 00:02:04
GGSCI (node1) 5> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:12:50
REPLICAT STOPPED REP1 00:00:00 00:02:08
GGSCI (node1) 6> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:12:51 00:00:01
REPLICAT STOPPED REP1 00:00:00 00:02:09
GGSCI (node1) 7> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (node1) 8> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:12:51 00:00:06
REPLICAT STOPPED REP1 00:00:00 00:02:15
GGSCI (node1) 9> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:12:51 00:00:09
REPLICAT STOPPED REP1 00:00:00 00:02:17
GGSCI (node1) 10> shell tail -10 ggserr.log
2016-10-07 07:44:26INFO OGG-06451Oracle GoldenGate Delivery for Oracle, rep1.prm:Triggers will be suppressed by default.
2016-10-07 07:44:26INFO OGG-01815Oracle GoldenGate Delivery for Oracle, rep1.prm:Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON)anon free: munmap
file alloc: mmap(MAP_SHARED)file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:44:27ERROR OGG-00446Oracle GoldenGate Delivery for Oracle, rep1.prm:Checkpoint table pdb2.c##ggadmin.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command in GGSCI.
2016-10-07 07:44:27ERROR OGG-01668Oracle GoldenGate Delivery for Oracle, rep1.prm:PROCESS ABENDING.
2016-10-07 07:44:28INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:30INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
GGSCI (node1) 11> add checkpointtable pdb2.c##ggadmin.checkpoint
ERROR: Not logged into database, use DBLOGIN.
GGSCI (node1) 12> dblogin userid c##ggadmin,password oracle
Successfully logged into database CDB$ROOT.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 13> add checkpointtable pdb2.c##ggadmin.checkpoint
Successfully created checkpoint table pdb2.c##ggadmin.checkpoint.
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 14> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:06 00:00:09
REPLICAT STOPPED REP1 00:00:00 00:05:28
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 15> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 16> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:10 00:00:02
REPLICAT RUNNING REP1 00:00:00 00:00:01
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 17> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:05 00:00:02
REPLICAT RUNNING REP1 00:00:00 00:00:00
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 18> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:05 00:00:03
REPLICAT RUNNING REP1 00:00:00 00:00:02
GGSCI (node1 as c##ggadmin@dev12c/CDB$ROOT) 19> exit
$ sqlplus test1/oracle@pdb1
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:48:06 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
$
$ sqlplus test/oracle@pdb1
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:48:23 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
Last Successful login time: Fri Oct 07 2016 07:20:59 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select count(*) from source;
COUNT(*)
----------
0
SQL> begin
2for i in 1..100
3loop
4insert into source values(i);
5commit;
6end loop;
7end;
8/
PL/SQL procedure successfully completed.
SQL> select count(*) from source;
COUNT(*)
----------
100
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:06 00:00:08
REPLICAT RUNNING REP1 00:00:00 00:00:00
GGSCI (node1) 2> stats ext1
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2016-10-07 07:49:15.
Output to ./dirdat/ex:
Extracting from PDB1.TEST.SOURCE to PDB1.TEST.SOURCE:
*** Total statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Daily statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Hourly statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Latest statistics since 2016-10-07 07:48:57 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
End of Statistics.
GGSCI (node1) 3> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:09 00:00:00
REPLICAT RUNNING REP1 00:00:00 00:00:03
GGSCI (node1) 4> stats rep1
Sending STATS request to REPLICAT REP1 ...
Start of Statistics at 2016-10-07 07:49:27.
Replicating from PDB1.TEST.SOURCE to PDB2.TEST.SOURCE:
*** Total statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Daily statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Hourly statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
*** Latest statistics since 2016-10-07 07:49:00 ***
Total inserts 100.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 100.00
End of Statistics.
GGSCI (node1) 5> exit
$ sqlplus test/oracle@pdb2
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 7 07:49:43 2016
Copyright (c) 1982, 2014, Oracle.All rights reserved.
Last Successful login time: Fri Oct 07 2016 07:38:41 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select tname from tab;
TNAME
--------------------------------------------------------------------------------
SOURCE
SQL> select count(*) from source;
COUNT(*)
----------
100
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
$ cat ggserr.log
2016-10-06 08:49:19INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle, oby.oby:GGSCI command (oracle): CREATE SUBDIRS.
2016-10-06 08:49:20INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle, oby.oby:GGSCI command (oracle): START MGR.
2016-10-06 08:49:20WARNING OGG-01877Oracle GoldenGate Manager for Oracle, mgr.prm:Missing explicit accessrule for server collector.
2016-10-06 08:49:20INFO OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #8).
2016-10-06 08:49:20INFO OGG-00983Oracle GoldenGate Manager for Oracle, mgr.prm:Manager started (port 7809).
2016-10-06 08:49:21INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle, oby.oby:GGSCI command (oracle): CREATE DATASTORE.
2016-10-06 08:49:50INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-06 08:50:07INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info mgr detail.
2016-10-06 08:50:22INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): create subdirs.
2016-10-06 08:54:01INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-06 09:14:18INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-06 09:14:23INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): create wallet.
2016-10-06 09:14:23INFO OGG-02096Oracle GoldenGate Command Interpreter for Oracle:Created wallet at location 'dirwlt'.
2016-10-06 09:14:23INFO OGG-02096Oracle GoldenGate Command Interpreter for Oracle:Opened wallet at location 'dirwlt'.
2016-10-06 09:14:46INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add credentialstore.
2016-10-06 09:14:46INFO OGG-02096Oracle GoldenGate Command Interpreter for Oracle:Credential store created in ./dircrd/.
2016-10-06 09:15:43INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add credentialstore add user C##GGADMIN@PDB1 ALIAS srcdb DOMAIN admin.
2016-10-06 09:15:43INFO OGG-02096Oracle GoldenGate Command Interpreter for Oracle:ERROR: Invalid argument 'add'.
2016-10-06 09:15:58INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): alter credentialstore add user C##GGADMIN@PDB1 ALIAS srcdb DOMAIN admin.
2016-10-06 09:16:00INFO OGG-02096Oracle GoldenGate Command Interpreter for Oracle:Credential store in ./dircrd/ altered.
2016-10-06 09:16:19INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info credentialstore domain admin.
2016-10-06 09:16:19INFO OGG-02096Oracle GoldenGate Command Interpreter for Oracle:Reading from ./dircrd/:.
2016-10-06 09:22:51INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-06 09:23:18INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin useridalias ALIAS srcdb DOMAIN admin.
2016-10-06 09:23:55INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid C##GGADMIN@PDB1 PASSWORD ***.
2016-10-06 09:24:17INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add trandata source.
2016-10-06 09:24:49INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add trandata sys.source.
2016-10-06 09:25:20INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add trandata pdb1.source.
2016-10-06 09:48:55INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin useridalias srcdb.
2016-10-06 09:49:30INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin useridalias SRCDB.
2016-10-06 09:51:08INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin useridalias srcdb DOMAIN admin.
2016-10-06 09:51:22INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add trandata test.source.
2016-10-06 09:54:10INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-06 11:57:43INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:21:33INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all;.
2016-10-07 07:21:35INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:21:38INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start mr.
2016-10-07 07:21:40INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start mgr.
2016-10-07 07:21:40WARNING OGG-01877Oracle GoldenGate Manager for Oracle, mgr.prm:Missing explicit accessrule for server collector.
2016-10-07 07:21:40INFO OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #8).
2016-10-07 07:21:40INFO OGG-00983Oracle GoldenGate Manager for Oracle, mgr.prm:Manager started (port 7809).
2016-10-07 07:29:41INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:29:44INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:30:01INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid c#ggadmin password ***.
2016-10-07 07:30:18INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid c#ggadminpassword ***.
2016-10-07 07:31:11INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid c##ggadmin password ***.
2016-10-07 07:31:30INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add extract ext1integrated tranlog, begin now.
2016-10-07 07:31:46INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): register extract ext1 database container(pdb1).
2016-10-07 07:32:08INFO OGG-02003Oracle GoldenGate Command Interpreter for Oracle:Extract EXT1 successfully registered with database at SCN 1879420.
2016-10-07 07:32:40INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add schematrandata pdb1.source.
2016-10-07 07:32:40ERROR OGG-01789Oracle GoldenGate Command Interpreter for Oracle:Failed to ADD SCHEMATRANDATA on schema source, because schema does not exist.
2016-10-07 07:32:59INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add schematrandata pdb1.test.
2016-10-07 07:32:59INFO OGG-01788Oracle GoldenGate Command Interpreter for Oracle:SCHEMATRANDATA has been added on schema test.
2016-10-07 07:32:59INFO OGG-01976Oracle GoldenGate Command Interpreter for Oracle:SCHEMATRANDATA for scheduling columns has been added on schema test.
2016-10-07 07:33:12INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add exttrail ./dirdat/exextract ext1.
2016-10-07 07:34:51INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add checkpointtable pdb1.c##ggadmin.checkpoint.
2016-10-07 07:36:00INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:39:28INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:39:36INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params ext1.
2016-10-07 07:40:27INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params rep1.
2016-10-07 07:41:47INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add replicat rep1exttrail ./dirdat/ex, checkpointtable p002.c##ggadmin.check.oint
2016-10-07 07:42:13INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add replicat rep1exttrail ./dirdat/ex, checkpointtable pdb2.c##ggadmin.checkpoint.
2016-10-07 07:42:15INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:09INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:13INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2016-10-07 07:44:13INFO OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :63789 (START EXTRACT EXT1 ).
2016-10-07 07:44:13INFO OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #6).
2016-10-07 07:44:13INFO OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2016-10-07 07:44:13INFO OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2016-10-07 07:44:13INFO OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as UTF-8.
2016-10-07 07:44:13INFO OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2016-10-07 07:44:14INFO OGG-03522Oracle GoldenGate Capture for Oracle, ext1.prm:Setting session time zone to source database time zone 'GMT'.
2016-10-07 07:44:14INFO OGG-02623Oracle GoldenGate Capture for Oracle, ext1.prm:Default source catalog name pdb1 will be used for source table name TEST.* mapping.
2016-10-07 07:44:14INFO OGG-01635Oracle GoldenGate Capture for Oracle, ext1.prm:BOUNDED RECOVERY: reset to initial or altered checkpoint.
2016-10-07 07:44:14INFO OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON)anon free: munmap
file alloc: mmap(MAP_SHARED)file free: munmap
target directories:
/u01/ogg12c/BR/EXT1.
2016-10-07 07:44:14INFO OGG-01851Oracle GoldenGate Capture for Oracle, ext1.prm:filecaching started: thread ID: 140043626657536.
2016-10-07 07:44:14INFO OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON)anon free: munmap
file alloc: mmap(MAP_SHARED)file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:44:15INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:18INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:19WARNING OGG-02045Oracle GoldenGate Capture for Oracle, ext1.prm:Database does not have streams_pool_size initialization parameter configured.
2016-10-07 07:44:19INFO OGG-02248Oracle GoldenGate Capture for Oracle, ext1.prm:Logmining server DDL filtering enabled.
2016-10-07 07:44:21INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:21INFO OGG-02068Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2016-10-07 07:44:21INFO OGG-02089Oracle GoldenGate Capture for Oracle, ext1.prm:Source redo compatibility version is: 12.1.0.2.0.
2016-10-07 07:44:21INFO OGG-02086Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated Dictionary will be used.
2016-10-07 07:44:21WARNING OGG-02905Oracle GoldenGate Capture for Oracle, ext1.prm:Replication of OID column in object tables may diverge.
2016-10-07 07:44:21INFO OGG-00993Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 started.
2016-10-07 07:44:21INFO OGG-01052Oracle GoldenGate Capture for Oracle, ext1.prm:No recovery is required for target file ./dirdat/ex000000000, at RBA 0 (file not opened).
2016-10-07 07:44:21INFO OGG-01478Oracle GoldenGate Capture for Oracle, ext1.prm:Output file ./dirdat/ex is using format RELEASE 12.2.
2016-10-07 07:44:22INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:25INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start rep1.
2016-10-07 07:44:25INFO OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :63790 (START REPLICAT REP1 ).
2016-10-07 07:44:25INFO OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #6).
2016-10-07 07:44:25INFO OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:REPLICAT REP1 starting.
2016-10-07 07:44:25INFO OGG-00995Oracle GoldenGate Delivery for Oracle, rep1.prm:REPLICAT REP1 starting.
2016-10-07 07:44:26INFO OGG-03059Oracle GoldenGate Delivery for Oracle, rep1.prm:Operating system character set identified as UTF-8.
2016-10-07 07:44:26INFO OGG-02695Oracle GoldenGate Delivery for Oracle, rep1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2016-10-07 07:44:26INFO OGG-02679Oracle GoldenGate Delivery for Oracle, rep1.prm:The Replicat process logged on to database PDB2 and can only apply to that database.
2016-10-07 07:44:26INFO OGG-06451Oracle GoldenGate Delivery for Oracle, rep1.prm:Triggers will be suppressed by default.
2016-10-07 07:44:26INFO OGG-01815Oracle GoldenGate Delivery for Oracle, rep1.prm:Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON)anon free: munmap
file alloc: mmap(MAP_SHARED)file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:44:27ERROR OGG-00446Oracle GoldenGate Delivery for Oracle, rep1.prm:Checkpoint table pdb2.c##ggadmin.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command in GGSCI.
2016-10-07 07:44:27ERROR OGG-01668Oracle GoldenGate Delivery for Oracle, rep1.prm:PROCESS ABENDING.
2016-10-07 07:44:28INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:44:30INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:47:10INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add checkpointtable pdb2.c##ggadmin.checkpoint.
2016-10-07 07:47:26INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid c##ggadmin password ***.
2016-10-07 07:47:35INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add checkpointtable pdb2.c##ggadmin.checkpoint.
2016-10-07 07:47:41INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:47:43INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start rep1.
2016-10-07 07:47:43INFO OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :63806 (START REPLICAT REP1 ).
2016-10-07 07:47:43INFO OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #6).
2016-10-07 07:47:43INFO OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:REPLICAT REP1 starting.
2016-10-07 07:47:43INFO OGG-00995Oracle GoldenGate Delivery for Oracle, rep1.prm:REPLICAT REP1 starting.
2016-10-07 07:47:43INFO OGG-03059Oracle GoldenGate Delivery for Oracle, rep1.prm:Operating system character set identified as UTF-8.
2016-10-07 07:47:43INFO OGG-02695Oracle GoldenGate Delivery for Oracle, rep1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2016-10-07 07:47:43INFO OGG-02679Oracle GoldenGate Delivery for Oracle, rep1.prm:The Replicat process logged on to database PDB2 and can only apply to that database.
2016-10-07 07:47:43INFO OGG-06451Oracle GoldenGate Delivery for Oracle, rep1.prm:Triggers will be suppressed by default.
2016-10-07 07:47:43INFO OGG-01815Oracle GoldenGate Delivery for Oracle, rep1.prm:Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON)anon free: munmap
file alloc: mmap(MAP_SHARED)file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-07 07:47:43INFO OGG-00996Oracle GoldenGate Delivery for Oracle, rep1.prm:REPLICAT REP1 started.
2016-10-07 07:47:43INFO OGG-02243Oracle GoldenGate Delivery for Oracle, rep1.prm:Opened trail file ./dirdat/ex000000000 at 2016-10-07 07:47:43.698711.
2016-10-07 07:47:43WARNING OGG-02760Oracle GoldenGate Delivery for Oracle, rep1.prm:ASSUMETARGETDEFS is ignored because trail file ./dirdat/ex000000000 contains table definitions.
2016-10-07 07:47:43INFO OGG-03522Oracle GoldenGate Delivery for Oracle, rep1.prm:Setting session time zone to source database time zone 'GMT'.
2016-10-07 07:47:44INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:47:54INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:47:55INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:48:57INFO OGG-06508Oracle GoldenGate Capture for Oracle, ext1.prm:Wildcard MAP (TABLE) resolved (entry pdb1.TEST.*): TABLE "PDB1"."TEST"."SOURCE".
2016-10-07 07:48:57INFO OGG-06509Oracle GoldenGate Capture for Oracle, ext1.prm:Using the following key columns for source table PDB1.TEST.SOURCE: ID.
2016-10-07 07:48:58INFO OGG-03506Oracle GoldenGate Delivery for Oracle, rep1.prm:The source database character set, as determined from the trail file, is UTF-8.
2016-10-07 07:48:58INFO OGG-06506Oracle GoldenGate Delivery for Oracle, rep1.prm:Wildcard MAP resolved (entry pdb1.test.*): MAP "PDB1"."TEST"."SOURCE", TARGET pdb2.test."SOURCE".
2016-10-07 07:49:00INFO OGG-02756Oracle GoldenGate Delivery for Oracle, rep1.prm:The definition for table PDB1.TEST.SOURCE is obtained from the trail file.
2016-10-07 07:49:00INFO OGG-06511Oracle GoldenGate Delivery for Oracle, rep1.prm:Using following columns in default map by name: ID.
2016-10-07 07:49:00INFO OGG-06510Oracle GoldenGate Delivery for Oracle, rep1.prm:Using the following key columns for target table PDB2.TEST.SOURCE: ID.
2016-10-07 07:49:11INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:49:15INFO OGG-01021Oracle GoldenGate Capture for Oracle, ext1.prm:Command received from GGSCI: STATS.
2016-10-07 07:49:23INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2016-10-07 07:49:27INFO OGG-01021Oracle GoldenGate Delivery for Oracle, rep1.prm:Command received from GGSCI: STATS.
$
页:
[1]