Oracle GoldenGate配置文档
一.源端配置
1.数据库开启归档
查看数据库是否开启归档
sqlplus / as sysdba
SQL> archive log list;
数据库开启归档
shutdown immediate;
startup mount;
alter database archivelog;
执行上边命令如果遇到ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
将数据库起到open状态,正常关闭shutdown immediate,再起到mount状态
解决办法:alter database open ; 再从shutdown immediate往下执行
alter database open;
alter system archive log start;
启用库级别补充日志
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL> ALTER SYSTEM SWITCH LOGFILE;
开启数据库强制日志模式
alter database force logging;
检查SQL> SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
2.安装goldengate
创建ogg安装目录(用root用户)
mkdir /opt/ogg
chown oracle:oinstall /datafile/ogg -R
将压缩文件复制到ogg安装路径下,并更改属主
chown oracle:oinstall /datafile/ogg/fbo_ggs_Linux_x64_ora11g_64bit.tar
切换到oracle用户并解压
su - oracle
cd /opt/ogg
tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar
设置PATH及LD_LIBRARY_PARH
vim ~/.bash_profile
export PATH=/datafile/ogg: O R A C L E H O M E / b i n : ORACLE_HOME/bin: ORACLEH