1.环境介绍
主库:
cai/cai@192.168.10.166/TEST
备库:
cai/cai@192.168.10.168/TEST
注意:此处笔者用一样的环境是因为方便创建环境,和OGG没有关系!
2.用户和环境介绍
笔者此处用oracle用户配置,笔者不喜欢多用户,否则太邋遢!
3.安装ogg(主备都做)
[root@master ~]# su - oracle
[oracle@master ~]$ mkdir /oracle/ogg
[oracle@master ~]$ cd /oracle/ogg/
[oracle@master ogg]$ tar xvf /usr/src/fbo_ggs_Linux_x64_ora10g_64bit.tar
oracle@master ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 10g on Apr 23 2012 07:30:46
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (master) 1> create subdirs
Creating subdirectories under current directory /oracle/ogg
Parameter files /oracle/ogg/dirprm: already exists
Report files /oracle/ogg/dirrpt: created
Checkpoint files /oracle/ogg/dirchk: created
Process status files /oracle/ogg/dirpcs: created
SQL script files /oracle/ogg/dirsql: created
Database definitions files /oracle/ogg/dirdef: created
Extract data files /oracle/ogg/dirdat: created
Temporary files /oracle/ogg/dirtmp: created
Stdout files /oracle/ogg/dirout: created
create subdirs
至此OGG安装完成
4.配置ogg(主备都做)
[oracle@master ogg]$ pwd
/oracle/ogg
[oracle@master ogg]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 11月 20 10:49:17 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> alter system set log_archive_dest_1='location=/oracle/archive_log' scope=spfile;
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='arch_%t_%s_%r.arc' scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 536870912 bytes
Fixed Size 2022112 bytes
Variable Size 155190560 bytes
Database Buffers 373293056 bytes
Redo Buffers 6365184 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL>
SQL> alter database open;
Database altered.
SQL> alter database force logging; #启用强制归档
Database altered.
SQL> alter database add supplemental log data; #启用最少附加日志
Database altered.
SQL> select log_mode,supplemental_log_data_min,force_logging from v$database; //查看状态
LOG_MODE SUPPLEMENTAL_LOG_DATA_MI FORCE_LOG
------------------------------------ ------------------------ ---------
ARCHIVELOG YES YES
SQL> Alter system set recyclebin=off; //关闭recyclebin
System altered.
SQL> create user ogg identified by ogg;
User created.
SQL> grant execute on utl_file to ogg ;
Grant succeeded.
SQL> grant dba,connect,resource to ogg;
Grant succeeded.
SQL> host pwd
/oracle/ogg
SQL> @marker_setup.sql //这些脚本都是由ogg自带的,运行之,按提示需求输入,如上创建的用户名是ogg
SQL> @ddl_setup.sql;
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ogg;
Grant succeeded.
SQL> @ddl_enable.sql
SQL> create user cai identified by cai default tablespace users temporary tablespace temp; //创建需要同步数据的用户
SQL> grant connect,resource,dba to cai; //赋予权限
5.OGG进程介绍
MANAGER:进程调度和传输
EXTRACT:负责从源库获取数据(抽取进程)
REPLICAT:负责将数据应用到备库(队列进程)
6.配置OGG manager(主备都做)
GGSCI (slave) 3> edit params mgr //编辑mgr的参数文件
GGSCI (slave) 4> view params mgr //查看mgr的配置信息
PORT 7809
GGSCI (slave) 3> start manager //启动manager服务
Manager started.
GGSCI (slave) 1> info all //查看所有服务的状态
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
7.主库配置抽取进程
GGSCI (master) 1> dblogin userid ogg, password ogg
GGSCI (master) 1> add extract ext1,tranlog, begin now
GGSCI (master) 1> edit params ext1GGSCI (master) 2> view params ext1extract ext1 //extract进程名字ext1的配置参数userid ogg, password ogg //登录本地库的用户名和密码rmthost 192.168.10.168, mgrport 7809 //远程manager的地址和portrmttrail /oracle/ogg/dirdat/lt //exttrail的位置ddl include mapped objname cai.*;table cai.*; //用户的表GGSCI (master) 1> add exttrail /oracle/ogg/dirdat/lt, extract ext1
8.配置备库的队列进程
GGSCI (slave) 1> edit params ./GLOBAL GGSCI (slave) 2> dblogin userid ogg, password ogg Successfully logged into database. GGSCI (slave) 3> add checkpointtable ogg.chkpoint Successfully created checkpoint table ogg.chkpoint. GGSCI (slave) 4> add replicat rep1,exttrail /oracle/ogg/dirdat/lt, checkpointtable ogg.checkpoint REPLICAT added. GGSCI (slave) 5> edit params rep1 GGSCI (slave) 2> view params rep1 replicat rep1 ASSUMETARGETDEFS HANDLECOLLISIONS userid ogg,password ogg discardfile /oracle/ogg/dirdat/rep1_discard.txt,append, megabytes 10 DDL map cai.*, target cai.*; GGSCI (slave) 3> start rep1 GGSCI (slave) 3> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING //manager正在运行 REPLICAT RUNNING REP1 00:00:00 00:00:00 //replicat正在运行
9.主库启动抽取,查看进程状态
GSCI (master) 3> start ext1 GGSCI (master) 3> info all ram Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:04
10.测试
主库
[oracle@master ogg]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 11月 20 09:58:54 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> connect cai/cai Connected. SQL> CREATE TABLE cai1 ("ID" NUMBER NOT NULL ENABLE, "NAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, "SEX" VARCHAR2(4 BYTE) NOT NULL ENABLE); Table created. SQL> insert into cai1 values('2', 'testname', 'gril'); 1 row created. SQL> insert into cai1 values(1, 'goldangate1', '女y'); 1 row created. SQL> commit; Commit complete. SQL> select * from cai1; ID NAME SEX ---------- -------------------- ---- 2 testname gril 1 goldangate1 女y SQL> SQL> insert into cai1 values(3, 'dataguard1', '男y'); 1 row created. SQL> commit;
备库[oracle@slave ogg]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 11月 20 01:37:19 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> connect cai/cai Connected. SQL> select * from cai1; ID NAME SEX ---------- -------------------- ---- 2 testname gril 1 goldangate1 女y
11.附加
ogg错误日志
注意:如果服务起不来,或者有问题,可以查看次日值[oracle@slave ogg]$ pwd /oracle/ogg [oracle@slave ogg]$ ll ggserr.log -rw-rw-rw-. 1 oracle oinstall 3264 Nov 20 02:35 ggserr.log
同步故障可以查看
[oracle@slave dirdat]$ pwd /oracle/ogg/dirdat [oracle@slave dirdat]$ ll *.txt -rw-rw-rw-. 1 oracle oinstall 256 Nov 20 01:35 rep1_discard.txt
###############################################################
作者:john
转载请注明出处
本文由笔者原创