1.前提安装好数据库,本文数据库版本为11.2.0.4;ogg软件解要到相应的目录,本文解压在/home/n目录下
2.创建一个操作系统用户n,属于oinstall组(为了登录数据库)
3.a.检查数据库最小附加日志是否打开
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
b.打开数据库最小附加日志开关
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
c.切换归档日志,使附加日志开关生效
ALTER SYSTEM SWITCH LOGFILE;
开归档(目标端可以不开归档)
4.配置环境变量:
[n@test1 ~]$ vim ~/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export TEMP=/oradata/tmp
export TMPDIR=/oradata/tmp
export ORACLE_BASE=/oradata/app/oracle
export ORACLE_HOME=/oradata/app/oracle/11.2.0/db
export ORACLE_SID=source2
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib //一定要
源端配置:
1.配置ogg用户:
SQL>Create user scofy identified by scofy ;
SQL>grant dba to scofy;