GoldenGate单向DDL同步(七)
values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 512M
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1G
CACHESIZEMAX (strict force to disk): 881M
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 environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file /data/oracle/ogg11/dirdat/lt000004 at 2013-04-17 13:19:20
Switching to next trail file /data/oracle/ogg11/dirdat/lt000005 at 2013-04-17 13:19:20 due to EOF, with current RBA 1046
Opened trail file /data/oracle/ogg11/dirdat/lt000005 at 2013-04-17 13:19:20
Processed extract process graceful restart record at seq 5, rba 986.
7. 同步测试
源库登录stat用户，创建表并插入数据：
SQL> conn stat/stat
Connected.
SQL> create table tp_test(act varchar2(10),dt date default sysdate);
Table created.
SQL> insert into tp_test(act) values('ins');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from tp_test;
ACT DT
---------- ---------
ins 17-APR-13
目标库登录stat用户，查看数据是否同步：
SQL> conn stat/stat
Connected.
SQL> select * from tp_test;
ACT DT
---------- ---------
ins 17-APR-13