gate]$ sqlplus gguser/system
SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 19 22:01:32 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from t;
A B
---------- ----------
1 a
2 b
3 c
SQL>
8.配置用户数据实时更新
source节点:
GGSCI (oracle11g) 14> add extract eoraaa, tranlog, begin now, threads 1
EXTRACT added.
GGSCI (oracle11g) 15> info extract *
EXTRACT EORAAA Initialized 2016-11-20 06:17 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:30 ago)
Log Read Checkpoint Oracle Redo Logs
2016-11-20 06:17:37 Thread 1, Seqno 0, RBA 0
SCN 0.0 (0)
GGSCI (oracle11g) 16> edit params eoraaa
EXTRACT EORAAA
USERID gguser, PASSWORD "system"
RMTHOST 192.168.3.90, MGRPORT 7809
RMTTRAIL ./dirdat/aa
TABLE gguser.t;
GGSCI (oracle11g) 18> add rmttrail ./dirdat/aa, extract eoraaa, megabytes 10
RMTTRAIL added.
GGSCI (oracle11g) 19> info rmttrail *
Extract Trail: ./dirdat/aa
Extract: EORAAA
Seqno: 0
RBA: 0
File Size: 10M
GGSCI (oracle11g) 20> start extract eoraaa
Sending START request to MANAGER ...
EXTRACT EORAAA starting
GGSCI (oracle11g) 21> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORAAA 00:00:00 00:00:09
GGSCI (oracle11g) 22> info extract eoraaa, detail
EXTRACT EORAAA Initialized 2016-11-20 06:17 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:10:50 ago)
Log Read Checkpoint Oracle Redo Logs
2016-11-20 06:17:37 Thread 1, Seqno 0, RBA 0
SCN 0.0 (0)
Target Extract Trails:
Remote Trail Name Seqno RBA Max MB
./dirdat/aa 0 0 10
Extract Source Begin End
Not Available * Initialized * 2016-11-20 06:17
Current directory /u01/glodengate
Report file /u01/glodengate/dirrpt/EORAAA.rpt
Parameter file /u01/glodengate/dirprm/eoraaa.prm
Checkpoint file