主备库都要操作：
任一节点解压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博客 ” ，链接：https://blog.itpub.net/29320885/viewspace-2121501/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
