OGG配置DML单向复制一例及错误分析
通过查看Oracle安装文档中列出的Package Requirements可以查看在不同平台上需要的软件包,下面列出Asianux 3, Oracle Enterprise
环境:11.2.0.3+OEL5.7
192.168.1.55zlm sid:zlm11g
192.168.1.60zlm2 sid:zlm11g
gg软件包:ogg112101_fbo_ggs_Linux_x64_ora11g_64bit
相关阅读:
Oracle DML流程
PL/SQL“ ORA-14551: 无法在查询中执行 DML 操作”解决
MySQL常用DDL、DML、DCL语言整理(附样例)
Oracle基本事务和ForAll执行批量DML练习
Oracle DML语句(insert,update,delete) 回滚开销估算
一、安装OGG软件并配置实验环境
*******
源主库:
*******
1.把gg软件包复制到源主机,2次解压到gg安装目录gg11
[oracle@zlmdb_1]$ cd $OACLE_BASE
[oracle@zlm~]$ ls
接下来请看第2页精彩内容:
incremental_hot_database_backup.sh ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
incremental_hot_database_backup.sh.out orz.sh
[oracle@zlmoracle]$ mkdir gg11
[oracle@zlmoracle]$ cd gg11
[oracle@zlmgg11]$ unzip /home/oracle/ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
[oracle@zlmgg11]$ ll
total223764
-rw-rw-r--1 oracle oinstall 228556800 Apr 23 2012fbo_ggs_Linux_x64_ora11g_64bit.tar
-rwxrwxrwx1 oracle oinstall 220546 May 2 2012OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
-rwxrwxrwx1 oracle oinstall 93696 May 2 2012Oracle GoldenGate 11.2.1.0.1README.doc
-rwxrwxrwx1 oracle oinstall 24390 May 2 2012Oracle GoldenGate 11.2.1.0.1README.txt
[oracle@zlmgg11]$ tar xvoffbo_ggs_Linux_x64_ora11g_64bit.tar
UserExitExamples/
UserExitExamples/ExitDemo_more_recs/
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
UserExitExamples/ExitDemo_more_recs/readme.txt
.............
2.修改环境变量文件.bash_profile,加入OGG的环境变量
export GGHOME=/$ORACLE_BASE/gg11
exportPATH=$ORACLE_BASE/gg11:$ORACLE_HOME/bin:/usr/bin/:$PATH
[oracle@zlmgg11]$ . ~/.bash_profile
[oracle@zlmgg11]$ ggsci
ggsci:error while loading shared libraries: libnnz11.so: cannot open shared objectfile: No such file or directory
由于没有设置LD_LIBRARY_PATH环境变量,所以无法执行ggsci,重新添加到.bash_profile
在环境变量中添加如下命令:
export LD_LIBLARY_PATH=$ORACLE_BASE/gg11:$ORACLE_HOME/lib:$ORACLE_HOME/bin
重新source一下后执行ggsci
[oracle@zlmgg11]$ . ~/.bash_profile
[oracle@zlmgg11]$ ggsci
OracleGoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux,x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright(C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
3.创建OGG专用目录subdirs
GGSCI (zlm)1> create subdirs
Creatingsubdirectories under current directory /u01/app/oracle/gg11
Parameterfiles /u01/app/oracle/gg11/dirprm: already exists
Reportfiles /u01/app/oracle/gg11/dirrpt: created
Checkpointfiles /u01/app/oracle/gg11/dirchk:created
Processstatus files /u01/app/oracle/gg11/dirpcs: created
SQLscript files /u01/app/oracle/gg11/dirsql: created
Databasedefinitions files /u01/app/oracle/gg11/dirdef: created
Extractdata files /u01/app/oracle/gg11/dirdat: created
Temporaryfiles /u01/app/oracle/gg11/dirtmp: created
Stdoutfiles /u01/app/oracle/gg11/dirout: created
4.对源数据库设置补充日志,并开启归档模式和强制归档
SQL>alter database add supplemental log data;
Databasealtered.
SQL>alter system switch logfile;
Systemaltered.
SQL>select supplemental_log_data_min,log_mode,force_logging from v$database;
SUPPLEMELOG_MODE FOR
-------------------- ---
YES ARCHIVELOG NO
SQL> alterdatabase force logging;
Databasealtered.
SQL>select supplemental_log_data_min,log_mode,force_loggingfrom v$database;
SUPPLEMELOG_MODE FOR
-------------------- ---
YES ARCHIVELOG YES
5.编辑源数据库管理进程参数文件
GGSCI(zlm) 1> edit params mgr
Cannotload ICU resource bundle 'ggMessage', error code 2 - No such file or directory
Cannotload ICU resource bundle 'ggMessage', error code 2 - No such file or directory
Aborted
这里报错是因为之前进入ggsci界面是并没有在OGG安装目录,必须要在$GGHOME(如果配置过的话,我这里$GGHOME=/u01/app/oracle/gg11)
[oracle@zlm~]$ cd $ORACLE_BASE/gg11
[oracle@zlmgg11]$ ggsci
OracleGoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux,x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright(C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI(zlm) 1> edit params mgr
在mgr中添加入如下一行:(和vi编辑器一样操作)
PORT 7809
,上一篇: MySQL数据库单表查询
下一篇: 利用MRG_MyISAM存储引擎实现分表