【Oracle】OGG单向复制配置(一)

2014-11-24 17:01:07 · 作者: · 浏览: 0

实验环境:

源端:

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