OGG（11G）RAC--＞單實例 搭建--同構同版本（數據泵初始化）

一、環境介紹

二、GoldenGate安裝（源端+目標端）

1、創建OGG安裝目錄（RAC采用共享盤掛載目錄）

源端

--劃分磁盤主分區 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

2、修改OGG操作系統用戶環境變量（所有RAC節點均配置）

如需配置 alias ggsci='rlwrap ggsci’ 可參考：

https://blog.csdn.net/m0_50546016/article/details/112525017

cat<> /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

3、上傳OGG安裝介質并解壓

chown -R oracle:oinstall /soft/ su - oracle -c "tar -xvf /soft/fbo_ggs_Linux_x64_ora11g_64bit.tar -C /ogg"

4、建立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;

5、配置數據庫參數

附加日志

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;

解鎖scott用戶

SQL> alter user scott account unlock; User altered. SQL> alter user scott identified by scott; User altered.

6 、TNS配置（所有RAC節點均配置）

加入對ASM的動態注冊，具體配置根據環境決定。

注意：RAC所有節點都要配置

--所有節點都要配置 cat <> /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 <> /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 <> /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

7、GGSCI初始化目錄

cd /ogg ggsci GGSCI (s11g) 1> create subdirs

三、GoldenGate配置

1、配置mgr進程（源端+目標端）

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

2、添加表級trandata（源端）

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.

3、配置extract抽取進程（源端）

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

4、配置pump傳輸進程（源端）

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

5、添加GLOBALS參數文件，創新檢查點表（源端+目標端）

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.

6、配置replicat復制進程（目標端）

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.*;

四、數據初始化（EXPDP）

1、啟動源端的EXTRACT進程

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

2、查看數據庫中所有事務的開始時間

查看數據庫中所有事務的開始時間，直到其大于抽取進程的啟動時間再開始備份數 據庫，因為GoldenGate 的只獲取在Extract 啟動以后的交易變化，在Extract 啟動之 前開始而在Extract 啟動以后才完成的交易GoldenGate 將會忽略這些交易，這些被忽 略的交易數據就會丟失。所以需要等數據庫中所以的交易都在Extract 啟動之后開始 的才能開始備份數據庫。通過gv$transaction 視圖來查看數據庫中的交易： SQL> select * from gv$transaction; no rows selected 這里是測試環境沒有事物，可以進行后面的備份了。

3、EXPDP 備份源端數據庫

--當所有在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

源端查詢當前數據庫SCN

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

目標端IMPDP 初始化數據

[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

用SCN 啟動Replicat

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

五、檢查同步是否正常

1、DML測試

--測試前數據比對：源端目標端數據一致 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

開啟DDL

在源端執行與DDL同步相關的SQL腳本

切記@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

源端extract 配置

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

目標端replicat 配置

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

DDL測試

--源端創建表 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)

六、測試RAC共享盤切換

假設節點一由于各種原因down機了，我們可以通過節點二mount ogg共享盤，切換到節點二進行同步

1、節點一停止所有進程

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

2、節點二mount ogg共享盤

[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

3、開啟所有進程

[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

4、測試同步

源端

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)

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。