OGG（11G）RAC--＞单实例搭建--同构同版本（数据泵初始化）

Lucifer三思而后行

发布于 2021-08-17 15:19:35

6290

文章被收录于专栏：公众号：Lucifer三思而后行公众号：Lucifer三思而后行

一、环境介绍

项目	源库	目标库
操作系统	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)

二、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)

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2021/03/26 ，如有侵权请联系 cloudcommunity@tencent.com 删除

数据库

本文分享自作者个人站点/博客前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

本文参与腾讯云自媒体同步曝光计划，欢迎热爱写作的你一起参与！

登录后参与评论

0 条评论

热度

OGG（11G）RAC--＞单实例 搭建--同构同版本（数据泵初始化）

OGG（11G）RAC--＞单实例 搭建--同构同版本（数据泵初始化）

一、环境介绍

二、GoldenGate安装（源端+目标端）

1、创建OGG安装目录（RAC采用共享盘挂载目录）

源端

目标端

2、修改OGG操作系统用户环境变量（所有RAC节点均配置）

3、上传OGG安装介质并解压

4、建立OGG表空间及用户，给用户授权

源端

目标端

5、配置数据库参数

附加日志

强制日志

检查是否开启

开启归档日志模式

源端

目标端

关闭回收站

解锁scott用户

6 、TNS配置（所有RAC节点均配置）

7、GGSCI初始化目录

三、GoldenGate配置

1、配置mgr进程（源端+目标端）

2、添加表级trandata（源端）

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

4、配置pump传输进程（源端）

5、添加GLOBALS参数文件，创新检查点表（源端+目标端）

6、配置replicat复制进程（目标端）

四、数据初始化（EXPDP）

1、启动源端的EXTRACT进程

2、查看数据库中所有事务的开始时间

3、EXPDP 备份源端数据库

源端查询当前数据库SCN

创建导出目录

备份源端数据库

将备份文件传到目标端

目标端IMPDP 初始化数据

用SCN 启动Replicat

五、检查同步是否正常

1、DML测试

开启DDL

在源端执行与DDL同步相关的SQL脚本

源端extract 配置

目标端replicat 配置

DDL测试

六、测试RAC共享盘切换

1、节点一停止所有进程

2、节点二mount ogg共享盘

3、开启所有进程

4、测试同步

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

OGG（11G）RAC--＞单实例搭建--同构同版本（数据泵初始化）

OGG（11G）RAC--＞单实例搭建--同构同版本（数据泵初始化）