当前位置 博文首页 > LuciferLiu_DBA:OGG(11G)RAC-->单实例 搭建--同构同版本(数
项目 | 源库 | 目标库 |
操作系统 | RHEL6.9 | RHEL6.9 |
主机名 | p11g01,p11g02 | p11g |
IP地址 | 192.168.1.40/41 | 192.168.1.38 |
数据库及版本 | ORACLE11.2.0.4 | ORACLE11.2.0.4 |
数据库字符集 | AL32UTF8 | AL32UTF8 |
ORACLE SID | orcl1,orcl2 | ora11g |
Goldengate用户 | ogg | ogg |
Goldengate版本 | 112103(Linux x86-64) | 112103(Linux x86-64) |
--划分磁盘主分区
fdisk /dev/sdd
--查看主分区
lsblk
--格式化主分区
mkfs.ext4 /dev/sdd1
--新建/ogg目录(双节点)
mkdir -p /ogg
chown -R oracle:oinstall /ogg
chmod 775 /ogg
--挂载主分区到/ogg目录
mount /dev/sdd1 /ogg
--配置开机自动挂载
vim /etc/fstab
/dev/sdd1 /ogg ext4 defaults 0 0
--生效
mount -a
mkdir -p /ogg
chown -R oracle:oinstall /ogg
chmod 775 /ogg
如需配置 alias ggsci='rlwrap ggsci' 可参考:
https://blog.csdn.net/m0_50546016/article/details/112525017
cat<<EOF >> /home/oracle/.bash_profile
################ogg profile add#########################
export OGG_HOME=/ogg
export PATH=\$ORACLE_HOME/bin:\$PATH:\$OGG_HOME
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:\$OGG_HOME:/lib:/usr/lib
alias ggsci='rlwrap ggsci'
EOF
chown -R oracle:oinstall /soft/
su - oracle -c "tar -xvf /soft/fbo_ggs_Linux_x64_ora11g_64bit.tar -C /ogg"
SQL> show parameter db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string +DATA
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
SQL> create tablespace ogg_data datafile size 1024M;
Tablespace created.
SQL> create user ogg identified by ogg default tablespace ogg_data;
User created.
SQL> grant connect,resource,dba,create table,create sequence to ogg;
Grant succeeded.
create tablespace ogg_data datafile '/oradata/ora11g/ogg01.dbf' size 1024M;
create user ogg identified by ogg default tablespace ogg_data;
grant connect,resource,dba,create table,create sequence to ogg;
alter database add SUPPLEMENTAL log data;
alter database force logging;
select NAME,OPEN_MODE,FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN from v$database;
--设置归档路径
su - oracle
sqlplus / as sysdba
alter system set log_archive_dest_1='location=+DATA';
--关闭数据库实例
srvctl stop database -d orcl -o immediate
--开启数据库实例orcl1到mount状态
srvctl start instance -d orcl -i orcl1 -o mount
--开启归档
sqlplus / as sysdba
alter database archivelog;
--开启实例orcl1
alter database open;
--开启数据库实例orcl2
srvctl start instance -d orcl -i orcl2
--查看归档路径
archive log list;
alter system switch logfile;
mkdir /archivelog
chown -R oracle:oinstall /archivelog/
su - oracle
sqlplus / as sysdba
alter system set log_archive_dest_1='location=/archivelog';
shutdown immediate
startup mount
alter database archivelog;
alter database open;
archive log list;
alter system switch logfile;
alter system set recyclebin=off scope=spfile;
SQL> alter user scott account unlock;
User altered.
SQL> alter user scott identified by scott;
User altered.
加入对ASM的动态注册,具体配置根据环境决定。
注意:RAC所有节点都要配置
--所有节点都要配置
cat <<EOF >> /u01/app/11.2.0/grid/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(ORACLE_HOME=/u01/app/11.2.0/grid)
(SID_NAME = +ASM1)
)
)
EOF
--重启监听
srvctl stop listener
--查看监听服务
lsnrctl stat
lsnrctl services
--测试连接
sqlplus sys/oracle@192.168.1.40/+ASM as sysdba
sqlplus sys/oracle@192.168.1.41/+ASM as sysdba
--oracle下配置TNS
##节点一配置
cat <<EOF >> /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora
+ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.40)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
)
)
EOF
##节点二配置
cat <<EOF >> /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora
+ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.41)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
)
)
EOF
--TNS测试连接
sqlplus sys/oracle@+ASM as sysdba
cd /ogg
ggsci
GGSCI (s11g) 1> create subdirs
GGSCI (s11g) 1> edit params mgr
GGSCI (s11g) 2> view params mgr
port 7809
GGSCI (s11g) 3> start mgr
Manager started.
GGSCI (s11g) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (s11g) 6> sh netstat -ntpl|grep 7809
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::7809 :::* LISTEN 5760/./mgr
GGSCI (s11g) 7> sh ps -ef|grep mgr
root 14 2 0 09:59 ? 00:00:00 [async/mgr]
postfix 1683 1676 0 09:59 ? 00:00:00 qmgr -l -t fifo -u
oracle 5760 5752 0 11:52 ? 00:00:00 ./mgr PARAMFILE /ogg/dirprm/mgr.prm REPORTFILE /ogg/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
oracle 5852 5752 0 12:15 pts/0 00:00:00 sh -c ps -ef|grep mgr
oracle 5854 5852 0 12:15 pts/0 00:00:00 grep mgr
GGSCI (p11g01) 121> add trandata scott.*
2021-03-27 23:08:32 WARNING OGG-00869 No unique key is defined for table 'BONUS'. 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 SCOTT.BONUS.
Logging of supplemental redo data enabled for table SCOTT.DEPT.
Logging of supplemental redo log data is already enabled for table SCOTT.EMP.
2021-03-27 23:08:34 WARNING OGG-00869 No unique key is defined for table 'SALGRADE'. 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 SCOTT.SALGRADE.
GGSCI (p11g01) 122> info trandata scott.*
Logging of supplemental redo log data is enabled for table SCOTT.BONUS.
Columns supplementally logged for table SCOTT.BONUS: ENAME, JOB, SAL, COMM.
Logging of supplemental redo log data is enabled for table SCOTT.DEPT.
Columns supplementally logged for table SCOTT.DEPT: DEPTNO.
Logging of supplemental redo log data is enabled for table SCOTT.EMP.
Columns supplementally logged for table SCOTT.EMP: EMPNO.
Logging of supplemental redo log data is enabled for table SCOTT.SALGRADE.
Columns supplementally logged for table SCOTT.SALGRADE: GRADE, LOSAL, HISAL.
GGSCI (p11g01) 11> add extract ext1,tranlog,begin now,threads 2
EXTRACT added.
GGSCI (p11g01) 12> add exttrail /ogg/dirdat/et,extract ext1
EXTTRAIL added.
GGSCI (p11g01) 13> edit param ext1
GGSCI (p11g01) 14> view param ext1
EXTRACT ext1
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") --此处数据库字符集设为一致
USERID ogg, PASSWORD ogg
TRANLOGOPTIONS ASMUSER sys@+ASM,ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000
EXTTRAIL /ogg/dirdat/et
DYNAMICRESOLUTION
--DDL INCLUDE ALL
TABLE scott.*
GGSCI (p11g01) 15> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:02:07
GGSCI (p11g01) 16> add extract pump1,exttrailsource /ogg/dirdat/et,begin now
EXTRACT added.
GGSCI (p11g01) 17> add rmttrail /ogg/dirdat/et,extract pump1
RMTTRAIL added.
GGSCI (p11g01) 18> edit param pump1
GGSCI (p11g01) 19> view param pump1
EXTRACT pump1
RMTHOST 192.168.1.38, MGRPORT 7809
RMTTRAIL /ogg/dirdat/et
PASSTHRU
DYNAMICRESOLUTION
TABLE scott.*;
GGSCI (p11g01) 20> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:07:18
EXTRACT STOPPED PUMP1 00:00:00 00:01:40
GGSCI (p11g01) 21> edit params ./GLOBALS
GGSCI (p11g01) 22> view param /ogg/GLOBALS
GGSCHEMA ogg
checkpointtable ogg.checkpoint
GGSCI (p11g01) 23> add checkpointtable ogg.checkpoint
Successfully created checkpoint table ogg.checkpoint.
GGSCI (p11g) 10> add replicat rep1,exttrail /ogg/dirdat/et,checkpointtable ogg.checkpoint
REPLICAT added.
GGSCI (p11g) 11> edit param rep1
GGSCI (p11g) 12> view param rep1
REPLICAT rep1
setenv (ORACLE_SID=ora11g)
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db")
USERID ogg,PASSWORD ogg
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE /ogg/dirrpt/repr1.dsc,append,megabytes 100
MAP scott.*, TARGET scott.*;
GGSCI (p11g01) 59> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (p11g01) 101> start pump1
Sending START request to MANAGER ...
EXTRACT PUMP1 starting
GGSCI (p11g01) 105> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:00
EXTRACT RUNNING PUMP1 00:00:00 00:00:05
查看数据库中所有事务的开始时间,直到其大于抽取进程的启动时间再开始备份数
据库,因为GoldenGate 的只获取在Extract 启动以后的交易变化,在Extract 启动之
前开始而在Extract 启动以后才完成的交易GoldenGate 将会忽略这些交易,这些被忽
略的交易数据就会丢失。所以需要等数据库中所以的交易都在Extract 启动之后开始
的才能开始备份数据库。通过gv$transaction 视图来查看数据库中的交易:
SQL> select * from gv$transaction;
no rows selected
这里是测试环境没有事物,可以进行后面的备份了。
--当所有在Extract 启动之前的开始的交易都完成后,我们就可以使用expdp 备份生产端的数据库了。备份数据库的过程中一定要密切监控Extract 进程的状态,保证其一直正常运行:
GGSCI (p11g01) 107> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:05
EXTRACT RUNNING PUMP1 00:00:00 00:00:08
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
1147075
mkdir /backup
chown -R oracle:oinstall /backup/
SQL> create or replace directory dump_dir as '/backup';
Directory created.
expdp system/oracle directory=dump_dir dumpfile=scott.dmp logfile=scott.log schemas=scott flashback_scn= 1147075
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . exported "SCOTT"."DEPT" 5.929 KB 4 rows
. . exported "SCOTT"."EMP" 8.562 KB 14 rows
. . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
scp /backup/* 192.168.1.38:/backup
oracle@192.168.1.38's password:
scott.dmp 100% 256KB 256.0KB/s 00:01
scott.log 100% 1871 1.8KB/s 00:00
[oracle@p11g backup]$ impdp system/oracle directory=dump_dir dumpfile= scott.dmp logfile=imp_scott.log table_exists_action=replace SCHEMAS=scott
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."DEPT" 5.929 KB 4 rows
. . imported "SCOTT"."EMP" 8.562 KB 14 rows
. . imported "SCOTT"."SALGRADE" 5.859 KB 5 rows
. . imported "SCOTT"."BONUS" 0 KB 0 rows
GGSCI (p11g) 13> start rep1, aftercsn 1147075
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (p11g) 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:02
--测试前数据比对:源端目标端数据一致
SQL> conn scott/scott
Connected.
SQL> set line222
SQL> set pagesize100
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10
14 rows selected.
--源端insert
insert into emp (empno,ename,job) values (9874,'LUCIFER','DBA');
--源端update
update emp set ename='ECHO' where empno=7934;
--源端delete
delete from emp where empno=7369;
commit;
--比对源端目标端数据,已同步
SCOTT@ora11g>/
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- --------
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 ECHO CLERK 7782 23-JAN-82 1300 10
9874 LUCIFER DBA
14 rows selected.
--查看抽取进程记录
GGSCI (p11g01) 111> stats ext1
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2021-03-27 22:57:05.
Output to /ogg/dirdat/et:
Extracting from SCOTT.EMP to SCOTT.EMP:
*** Total statistics since 2021-03-27 22:49:41 ***
Total inserts 1.00
Total updates 1.00
Total deletes 1.00
Total discards 0.00
Total operations 3.00
--查看传输进程
GGSCI (p11g01) 112> stats pump1
Sending STATS request to EXTRACT PUMP1 ...
Start of Statistics at 2021-03-27 22:58:14.
Output to /ogg/dirdat/et:
Extracting from SCOTT.EMP to SCOTT.EMP:
*** Total statistics since 2021-03-27 22:49:41 ***
Total inserts 1.00
Total updates 1.00
Total deletes 1.00
Total discards 0.00
Total operations 3.00
--查看复制进程
GGSCI (p11g) 21> stats rep1
Sending STATS request to REPLICAT REP1 ...
Start of Statistics at 2021-03-27 22:58:41.
Replicating from SCOTT.EMP to SCOTT.EMP:
*** Total statistics since 2021-03-27 22:49:46 ***
Total inserts 1.00
Total updates 1.00
Total deletes 1.00
Total discards 0.00
Total operations 3.00
切记@marker_setup.sql 一定要在cd $OGG_HOME目录下执行否则会卡主。执行脚本时要输入ogg管理用户,本实例是ogg。
cd /ogg
sqlplus / as sysdba
grant execute on utl_file to ogg;
@marker_setup.sql
@ddl_setup.sql
@role_setup.sql
grant GGS_GGSUSER_ROLE to ogg;
@ddl_enable.sql
@ddl_pin ogg
GGSCI (p11g01) 114> edit param ext1
GGSCI (p11g01) 115> view param ext1
EXTRACT ext1
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") --此处数据库字符集设为一致
USERID ogg, PASSWORD ogg
TRANLOGOPTIONS ASMUSER sys@+ASM,ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000
EXTTRAIL /ogg/dirdat/et
DYNAMICRESOLUTION
DDL INCLUDE ALL
TABLE scott.*;
GGSCI (p11g01) 116> stop ext1
Sending STOP request to EXTRACT EXT1 ...
Request processed.
GGSCI (p11g01) 117> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (p11g01) 118> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:05
EXTRACT RUNNING PUMP1 00:00:00 00:00:08
GGSCI (p11g) 23> edit param rep1
GGSCI (p11g) 24> view param rep1
REPLICAT rep1
setenv (ORACLE_SID=ora11g)
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db")
USERID ogg,PASSWORD ogg
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE /ogg/dirrpt/repr1.dsc,append,megabytes 100
MAP scott.*, TARGET scott.*;
ddl include all
ddlerror default ignore retryop maxretries 3 retrydelay 5
GGSCI (p11g) 25> stop rep1
Sending STOP request to REPLICAT REP1 ...
Request processed.
GGSCI (p11g) 26> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (p11g) 27> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:00
--源端创建表
SQL> create table lucifer(id number not null,name varchar2(20));
Table created.
SQL> alter table lucifer add primary key(id);
Table altered.
--增加trandata
GGSCI (p11g01) 130> add trandata scott.lucifer
Logging of supplemental redo data enabled for table SCOTT.LUCIFER.
GGSCI (p11g01) 131> info trandata scott.lucifer
Logging of supplemental redo log data is enabled for table SCOTT.LUCIFER.
Columns supplementally logged for table SCOTT.LUCIFER: ID.
--目标端查看
SYS@ora11g>conn scott/scott
Connected.
SCOTT@ora11g>select table_name from user_tables;
TABLE_NAME
------------------------------
LUCIFER
SALGRADE
BONUS
EMP
DEPT
SCOTT@ora11g>desc lucifer
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(20)
假设节点一由于各种原因down机了,我们可以通过节点二mount ogg共享盘,切换到节点二进行同步
GGSCI (p11g01) 134> stop ext1
Sending STOP request to EXTRACT EXT1 ...
Request processed.
GGSCI (p11g01) 135> stop pump1
Sending STOP request to EXTRACT PUMP1 ...
Request processed.
GGSCI (p11g01) 136>
GGSCI (p11g01) 136>
GGSCI (p11g01) 136> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
GGSCI (p11g01) 137>
GGSCI (p11g01) 137>
GGSCI (p11g01) 137> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED EXT1 00:00:00 00:00:19
EXTRACT STOPPED PUMP1 00:00:00 00:00:15
[root@p11g02 ~]# mount /ogg
[root@p11g02 ~]# df -Th
Filesystem Type Size Used Avail Use% Mounted on
/dev/mapper/vg_p11g02-lv_root
ext4 50G 12G 35G 26% /
tmpfs tmpfs 2.0G 536M 1.5G 28% /dev/shm
/dev/sda1 ext4 477M 42M 410M 10% /boot
/dev/mapper/vg_p11g02-lv_home
ext4 45G 53M 43G 1% /home
/dev/sdd1 ext4 9.8G 251M 9.0G 3% /ogg
[oracle@p11g02 ~]$ cd /ogg
[oracle@p11g02 ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (p11g02) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT ABENDED EXT1 00:00:00 00:00:04
EXTRACT ABENDED PUMP1 00:00:00 00:00:09
GGSCI (p11g02) 2>
GGSCI (p11g02) 2>
GGSCI (p11g02) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT ABENDED EXT1 00:00:00 00:00:39
EXTRACT ABENDED PUMP1 00:00:00 00:00:45
GGSCI (p11g02) 3> start mgr
Manager started.
GGSCI (p11g02) 4> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (p11g02) 5> start pump1
Sending START request to MANAGER ...
EXTRACT PUMP1 starting
GGSCI (p11g02) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:01 00:00:04
EXTRACT RUNNING PUMP1 00:00:00 00:00:58
源端
SQL> select * from lucifer;
no rows selected
SQL> insert into lucifer(id,name) values (1,'lucifer');
1 row created.
SQL> insert into lucifer(id,name) values (2,'echo');
1 row created.
SQL> commit;
Commit complete.
SQL> create table echo(id number primary key,name varchar2(20));
Table created.
SQL> select * from lucifer;
ID NAME
---------- --------------------
1 lucifer
2 echo
SQL> desc echo
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(20)
源端增加trandata scott.echo
GGSCI (p11g02) 12> dblogin userid ogg,password ogg
Successfully logged into database.
GGSCI (p11g02) 13> add trandata scott.echo
Logging of supplemental redo data enabled for table SCOTT.ECHO.
GGSCI (p11g02) 14> info trandata scott.echo
Logging of supplemental redo log data is enabled for table SCOTT.ECHO.
Columns supplementally logged for table SCOTT.ECHO: ID.
目标端已同步
SCOTT@ora11g>select * from lucifer;
ID NAME
---------- --------------------
1 lucifer
2 echo
SCOTT@ora11g>desc echo
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(20)
?