ogg - 墨天轮文档

ogg

respark

950

13页

11次

2019-10-22

5墨值下载

1 --创建 ogg 用户

useradd -u 2100 -g oinstall -G dba ogg

passwd ogg

su - ogg

vi .bash_profile

export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/lib

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/jdk/bin:$PATH

source .bash_profile

2 下载安装 ogg

mkdir -p /u01/app/ogg

chown -R oracle:oinstall /u01/app/ogg

unzip V34339-01.zip

tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/app/ogg/

chown -R oracle:oinstall /u01/app/ogg

/u01/app/ogg

./ggsci

3 源端和目标端创建 OGG 表空间和 OGG 用户

create tablespace ogg datafile '/u01/app/oracle/oradata/orcl/ogg01.dbf' size 50M

autoextend on;

create user ogg identified by ogg default tablespace ogg;

grant CONNECT, RESOURCE to ogg;

grant SELECT ANY DICTIONARY, SELECT ANY TABLE to ogg;

grant ALTER ANY TABLE to ogg;

grant FLASHBACK ANY TABLE to ogg;

grant EXECUTE on DBMS_FLASHBACK to ogg;

grant insert any table to ogg;

grant update any table to ogg;

grant delete any table to ogg;

源端开归档，开日志补充，开最小附加日志

select NAME,OPEN_MODE,FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN from v$database;

select LOG_MODE,SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING from

v$database;

开归档：

shutdown immediate

startup mount

alter database archivelog;

alter database open;

开日志补充：

alter database force logging;

开启开最小附加日志：

alter database add supplemental log data;

再次查看状态：

select LOG_MODE,SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING from

v$database;

开启 enable_goldengate_replication 参数

开启数据库 GoldenGate 参数(这个参数 OGG12 版本以后需要开启)：

alter system set enable_goldengate_replication=true scope=both;

---源端运行 OGG 支持 DDL 脚本

如果要让 OGG 支持 DDL 操作，还需要额外运行几个脚本，这些脚本是 OGG 带的而不是 ORACLE 带的，源

端与目标端都需要

---SYS@ orcl >@/u01/app/ogg/marker_setup.sql

---SYS@ orcl >@/u01/app/ogg/ddl_setup.sql

---SYS@ orcl >@/u01/app/ogg/role_setup.sql

---SYS@ orcl >@/u01/app/ogg/ddl_enable.sql

4 开始进行搭建

源端

4.1 创建 OGG 的管理目录

GGSCI (DSI) 1> create subdirs

Creating subdirectories under current directory /u01/app/ogg

Parameter files /u01/app/ogg/dirprm: already exists

Report files /u01/app/ogg/dirrpt: created

Checkpoint files /u01/app/ogg/dirchk: created

Process status files /u01/app/ogg/dirpcs: created

SQL script files /u01/app/ogg/dirsql: created

Database definitions files /u01/app/ogg/dirdef: created

Extract data files /u01/app/ogg/dirdat: created

Temporary files /u01/app/ogg/dirtmp: created

Stdout files /u01/app/ogg/dirout: created

4.2 建立测试表

SYS@ ogg >@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlsampl.sql

--源端

SYS@ orcl> conn scott/tiger

Connected.

SCOTT@ orcl >create table emp_ogg as select * from emp;

Table created.

SCOTT@ orcl >create table dept_ogg as select * from dept;

Table created.

SCOTT@ orcl >alter table EMP_OGG add constraint PK_EMPNO_OGG primary key

(EMPNO);

Table altered.

SCOTT@ orcl >alter table DEPT_OGG add constraint PK_DEPTNO_OGG primary key

(DEPTNO);

Table altered.

--目标端

SYS@ ogg >conn scott/tiger

Connected.

SCOTT@ ogg > create table emp_ogg as select * from emp where 1=2;

Table created.

SCOTT@ ogg >create table dept_ogg as select * from dept where 1=2;

Table created.

SCOTT@ ogg >alter table EMP_OGG add constraint PK_EMPNO_OGG primary key (EMPNO);

Table altered.

SCOTT@ ogg >alter table DEPT_OGG add constraint PK_DEPTNO_OGG primary key

(DEPTNO);

Table altered.

4.3 源端添加表级 TRANDATA

GGSCI (DSI) 2> DBLOGIN USERID ogg, PASSWORD ogg

Successfully logged into database.

GGSCI (DSI) 3> add trandata scott.emp_ogg

Logging of supplemental redo log data is already enabled for table

of 13

5墨值下载

关注

评论