Oracle主从配置

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:$ORACL{E}_H$