实验环境:
源端:
Ip:192.168.40.10
DataBase:Oracle 11.2.0.1.0 ORCL
OS:OEL5.6
OGG:fbo_ggs_Linux_x86_ora11g_32bit
目标端:
Ip:192.168.40.128
DataBase:10.2.0.1.0 ORCL
OS:OEL5.6
OGG:fbo_ggs_Linux_x86_ora11g_32bit
首先配置好两台机子上的环境变量,在其中增加以下内容并使之生效:
export GGATE=$ORACLE_BASE/ogg
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$GGATE
并且均建立该路径:
mkdir $ORACLE_BASE/ogg
源端配置:
[oracle@badly9 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jun 7 17:23:51 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@ORCL>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Next log sequence to archive 7
Current log sequence 7
SYS@ORCL>select supplemental_log_data_min from v$database;
SUPPLEME
--------
NO
SYS@ORCL>alter database add supplemental log data;
Database altered.
SYS@ORCL>select supplemental_log_data_min from v$database;
SUPPLEME
--------
YES
SYS@ORCL>alter database force logging;
Database altered.
SYS@ORCL>create tablespace tbs_ogg
2 datafile '/u01/app/oracle/oradata/ORCL/datafile/tbs_ogg01.dbf' size 200M
3 autoextend on;
Tablespace created.
SYS@ORCL>create user ogg identified by ogg default tablespace tbs_ogg;
User created.
SYS@ORCL>grant connect,resource,dba to ogg;
Grant succeeded.
SYS@ORCL>grant execute on utl_file to ogg;
Grant succeeded.
SYS@ORCL>grant select any dictionary,select any table to ogg;
Grant succeeded.
SYS@ORCL>grant alter any table to ogg;
Grant succeeded.
SYS@ORCL>grant flashback any table to ogg;
Grant succeeded.
SYS@ORCL>grant execute on DBMS_FLASHBACK to ogg;
Grant succeeded.
目标端:
SYS@ORCL>create tablespace tbs_ogg
2 datafile '/u01/app/oracle/oradata/ORCL/tbs_ogg01.dbf' size 200M
3 autoextend on;
Tablespace created.
SYS@ORCL>create user ogg identified by ogg default tablespace tbs_ogg;
User created.
SYS@ORCL>grant connect,resource,dba to ogg;
Grant succeeded.
SYS@ORCL>grant execute on utl_file to ogg;
Grant succeeded.
SYS@ORCL>grant insert any table to ogg;
Grant succeeded.
SYS@ORCL>grant delete any table to ogg;
Grant succeeded.
SYS@ORCL>grant update any table to ogg;
Grant succeeded.
源端和目标端
[oracle@badly9 ~]$ tar -xvf fbo_ggs_Linux_x86_ora11g_32bit.tar
UserExitExamples/
UserExitExamples/ExitDemo_passthru/
UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
。。。略。。。
[oracle@badly9 ~]$ ./ggsci
源端:
GGSCI (badly9) 1> create subdirs
Creating subdirectories under current directory /u01/app/oracle/ogg
Parameter files /u01/app/oracle/ogg/dirprm: already exists
Report files /u01/app/oracle/ogg/dirrpt: created
Checkpoint files /u01/app/oracle/ogg/dirchk: created
Process status files /u01/app/oracle/ogg/dirpcs: created
SQL script files /u01/app/oracle/ogg/dirsql: created
Database definitions files /u01/app/oracle/ogg/dirdef: created
Extract data files /u01/app/oracle/ogg/dirdat: created
Temporary files /u01/app/oracle/ogg/dirtmp: created
Stdout files /u01/app/oracle/ogg/dirout: created
GGSCI (badly9) 2> edit params mgr
GGSCI (badly9) 3> view params mgr
port 7809
dynamicportlist 7800-8000
autoresta