主备库都要操作:
任一节点解压ogg 并设置环境变量
121210_fbo_ggs_Linux_x64_shiphome.zip
解压 ./runInstaller 图形界面安装
数据库打补丁
p16764834_112030_Linux-x86-64.zip
@?/sqlpatch/16764834/postinstall.sql
[
oracle@tbrac01 ogg]$ vi ~/.bash_profile
export PATH=$ORACLE_HOME/bin:
/u01/app/ogg:$PATH
export SHLIB_PATH=/u01/app/ogg:$ORACLE_HOME/lib
创建ogg应用目录
[
oracle@tbrac01 ogg]$ source ~/.bash_profile
[
oracle@tbrac01 ogg]$
ggsci
GGSCI (tbrac01) 1>
create subdirs
Creating subdirectories under current directory /u01/app/ogg
Parameter files /u01/app/ogg/dirprm: already exists
Report files /u01/app/ogg/dirrpt: created
Checkpoint files /u01/app/ogg/dirchk: created
Process status files /u01/app/ogg/dirpcs: created
SQL script files /u01/app/ogg/dirsql: created
Database definitions files /u01/app/ogg/dirdef: created
Extract data files /u01/app/ogg/dirdat: created
Temporary files /u01/app/ogg/dirtmp: created
Stdout files /u01/app/ogg/dirout: created
开启主库的force logging和补充日志功能
SQL>
ALTER DATABASE FORCE LOGGING;
Database altered.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
System altered.
SQL> SELECT name,open_mode,force_logging,supplemental_log_data_min FROM v$database;
NAME OPEN_MODE FOR SUPPLEME
--------- -------------------- --- --------
TRAC READ WRITE YES YES
创建ogg的管理用户
SQL> CREATE TABLESPACE goldengate DATAFILE '
+dg_data/hubsrac
/goldengate01.dbf' SIZE 100M AUTOEXTEND ON;
Tablespace created.
SQL> CREATE USER oggadmin IDENTIFIED BY oggadmin DEFAULT TABLESPACE goldengate;
User created.
SQL> GRANT dba TO oggadmin;
Grant succeeded.
SQL> grant execute on UTL_FILE to oggadmin;
Grant succeeded.
备库
创建ogg的管理用户
SQL> CREATE TABLESPACE goldengate DATAFILE '+DG_DATA01/fograc/
goldengate01.dbf' SIZE 100M AUTOEXTEND ON;
Tablespace created.
SQL> CREATE USER oggadmin IDENTIFIED BY oggadmin DEFAULT TABLESPACE goldengate;
User created.
SQL> GRANT dba TO oggadmin;
Grant succeeded.
SQL> grant execute on UTL_FILE to oggadmin;
Grant succeeded.
执行oggadmin授权脚本
[
oracle@tbrac01 ~]$ cd /u01/app/ogg/
[
oracle@tbrac01 ogg]$ sqlplus / as sysdba
SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant ggs_ggsuser_role to oggadmin;
SQL> @ddl_enable.sql
SQL> EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE( grantee => 'oggadmin', privilege_type => 'CAPTURE', grant_select_privileges=> true, do_grants => TRUE);
[
oracle@tbrac01 ~]$ cd /u01/app/ogg/
[
oracle@tbrac01 ogg]$ ./ggsci
GGSCI (tbrac01) 2> edit params ./global
GGSCHEMA oggadmin
~
至此 ogg基本安装完成,配置主库的ogg同步FOG用户表
主库配置:
配置管理进程
GGSCI> EDIT PARAM MGRPORT 7809
开启FOG下的所有表的追踪日志
GGSCI (tbrac01) 1> dblogin userid oggadmin password oggadmin
Successfully logged into database.
GGSCI (tbrac01) 3> ADD TRANDATA test.*
创建初级提取组ex1
将进程ex1
注册到数据库
GGSCI (hubsrac01 as oggadmin@fograc1) 7> dblogin userid oggadmin,password oggadmin
GGSCI (hubsrac01 as
oggadmin@fograc1) 7> register extract fm1 database
GGSCI (hubsrac01 as
oggadmin@fograc1) 10> add extract fm1 integrated tranlog,begin now
EXTRACT added.
GGSCI (hubsrac01 as
oggadmin@fograc1) 12> add exttrail /u01/app/ogg/ogg12/dirdat/fm,extract fm1
EXTTRAIL added.
GGSCI (hubsrac01 as
oggadmin@fograc1) 12> edit params fm1
EXTRACT fm1
USERID oggadmin, PASSWORD oggadmin
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 100)
EXTTRAIL /u01/app/ogg/ogg12/dirdat/fm
DYNAMICRESOLUTION
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA,REPORT
FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
WARNLONGTRANS 1H, CHECKINTERVAL 5M
GETTRUNCATES
TABLE
test.*;
GGSCI (hubsrac01 as
oggadmin@fograc1) 14> add extract df1 exttrailsource /u01/app/ogg/ogg12/dirdat/fm
EXTRACT added.
GGSCI (hubsrac01 as
oggadmin@fograc1) 16> add rmttrail /mnt/fogbackup/ogg/ogg12/dirdat/f1,extract df1
RMTTRAIL added.
GGSCI (hubsrac01 as
oggadmin@fograc1) 12> edit params df1
EXTRACT dp1
USERID oggadmin, PASSWORD oggadmin
RMTHOST 192.168.234.21, MGRPORT 7809
RMTTRAIL
/mnt/fogbackup/ogg
/ogg12/dirdat/d1
table
test.*;
target
GGSCI (fograc-dg4) 2> dblogin userid oggadmin,password oggadmin
Successfully logged into database.
GGSCI (fograc-dg4 as
oggadmin@fogdg4) 3> add checkpointtable oggadmin.chkptab
Successfully created checkpoint table oggadmin.chkptab.
GGSCI (fograc-dg4 as
oggadmin@fogdg4) 6> edit params mgr
PORT 7809
GGSCI (fograc-dg4 as
oggadmin@fogdg4) 4> EDIT PARAMS ./GLOBALS
GGSCHEMA oggadmin
CHECKPOINTTABLE oggadmin.chkptab
GGSCI (fograc-dg4 as
oggadmin@fogdg4) 7> add replicat rf1,exttrail
/mnt/fogbackup/ogg
/ogg12/dirdat/f1
REPLICAT added.
GGSCI (fograc-dg4 as
oggadmin@fogdg4) 8> edit params rf1
REPLICAT rp1
USERID oggadmin, PASSWORD oggadmin
ASSUMETARGETDEFS
HANDLECOLLISIONS
DISCARDFILE
/mnt/fogbackup/ogg
/ogg12/discards.dsc, PURGE
map
test.*, target
test.*;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29320885/viewspace-2121501/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29320885/viewspace-2121501/