ogg_安装配置12Cgg 由ADG抽取数据_孙成子子

http://blog.sina.com.cn/u/2199343467

首页博文目录关于我

个人资料

微博

加好友发纸条

写留言加关注

博客等级：
博客积分：

博客访问：
关注人气：
获赠金笔：0支
赠出金笔：0支
荣誉徽章：

正文字体大小：大中小

ogg_安装配置12Cgg 由ADG抽取数据

(2015-07-06 22:20:15)

标签：

adg

ogg

12c

mine

分类： goldengate

12c新特性关于对ADG支持描述如下：

Active Data Guard (ADG) - A new processing option (TRANLOGOPTIONS MINEFROMACTIVEDG) is introduced allowing you to configure Classic Extract to mine online redo logs shipped to the Oracle Active Data Guard standby system allowing real-time replication directly from ADG hosts. Oracle GoldenGate connects to the standby database to get metadata and other required data as needed. This mode is useful in load sensitive environments where ADG is already in place or can be implemented. It can also be used as cost effective method to implement high availability using the ADG Broker role planned (switchover) and failover (unplanned) changes.

其实也就是在参数文件中多了上面参数MINEFROMACTIVEDG.

安装OGG 12C。

创建需要目录，配置环境变量LD_LIBRARY_PATH等。

http://s6/mw690/002oQdHJzy6TDduxx3vd5&690由ADG抽取数据" TITLE="ogg_安装配置12Cgg 由ADG抽取数据" />

http://s9/mw690/002oQdHJzy6TDdxSOOA08&690由ADG抽取数据" TITLE="ogg_安装配置12Cgg 由ADG抽取数据" />

http://s10/mw690/002oQdHJzy6TDeW2I4xd9&690由ADG抽取数据" TITLE="ogg_安装配置12Cgg 由ADG抽取数据" />

http://s11/mw690/002oQdHJzy6TDeWV8Aa3a&690由ADG抽取数据" TITLE="ogg_安装配置12Cgg 由ADG抽取数据" />

http://s11/mw690/002oQdHJzy6TDeXMfrA9a&690由ADG抽取数据" TITLE="ogg_安装配置12Cgg 由ADG抽取数据" />

[ora11@prim ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Aug 7 2014 09:14:25

Operating system character set identified as UTF-8.

GGSCI (prim) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

GGSCI (prim) 2> create subdirs

Creating subdirectories under current directory /u01/ogg

Parameter files /u01/ogg/dirprm: already exists

Report files /u01/ogg/dirrpt: created

Checkpoint files /u01/ogg/dirchk: created

Process status files /u01/ogg/dirpcs: created

SQL script files /u01/ogg/dirsql: created

Database definitions files /u01/ogg/dirdef: created

Extract data files /u01/ogg/dirdat: created

Temporary files /u01/ogg/dirtmp: created

Credential store files /u01/ogg/dircrd: created

Masterkey wallet files /u01/ogg/dirwlt: created

Dump files /u01/ogg/dirdmp: created

至此12.1.2.1.0安装完毕，可以进行配置，进行同步。

升级12.1.2.1.0到12.1.2.1.5，发现现在的升级步骤和oracle数据库的如此的相似，之前都是覆盖文件来升级。

$unzip PATCH.zip

$cd

[ora11@prim 20704740]$ /u01/ogg/OPatch/opatch apply -oh /u01/ogg/

Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7

Oracle Home : /u01/ogg

Central Inventory : /u01/app/oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.7

OUI version : 11.2.0.3.0

Log file location : /u01/ogg/cfgtoollogs/opatch/opatch2015-07-06_22-51-44PM.log

Applying interim patch '20704740' to OH '/u01/ogg'

Verifying environment and performing prerequisite checks...

Do you want to proceed? [y|n]

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/ogg')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

Patching component oracle.oggcore.ora11g, 12.1.2.1.0...

Patch 20704740 successfully applied

Log file location: /u01/ogg/cfgtoollogs/opatch/opatch2015-07-06_22-51-44PM.log

OPatch succeeded.

[ora11@prim 20704740]$ /u01/ogg/OPatch/opatch lsinventory -oh /u01/ogg/

Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7

Oracle Home : /u01/ogg

Central Inventory : /u01/app/oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.7

OUI version : 11.2.0.3.0

Log file location : /u01/ogg/cfgtoollogs/opatch/opatch2015-07-06_22-53-14PM.log

Lsinventory Output file location : /u01/ogg/cfgtoollogs/opatch/lsinv/lsinventory2015-07-06_22-53-14PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle GoldenGate Core 12.1.2.1.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 20704740 : applied on Mon Jul 06 22:52:36 CST 2015

Unique Patch ID: 18899382

Created on 5 May 2015, 13:16:27 hrs PST8PDT

Bugs fixed:

19818362, 20021370, 19264441, 18996447, 19241234, 19414121, 19545128

19721652, 20660883, 19132627, 18875912, 20543714, 17866697, 20367405

19889991, 19244349, 20092876, 20045536, 19987316, 20554464, 19142865

19681198, 20148126, 19067094, 19798268, 20577891, 19560158, 19920244

19602692, 18958026, 19535319, 20641896, 17423191, 20563015, 19516537

19441114, 20078949, 19374174, 19681035, 19782389, 19903590, 19781984

19724915, 19327073, 20531064, 19594967

--------------------------------------------------------------------------------

OPatch succeeded.

[ora11@prim 20704740]$ cd ../../

[ora11@prim u01]$ cd ogg

[ora11@prim ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.1.2.1.5 20635622 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150320.0454_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 22 2015 02:38:13

Operating system character set identified as UTF-8.

GGSCI (prim) 1>

配置简单获取本地extract文件：

--local extract file

Extract ep_fme1

SetEnv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)

UserID ggs, Password 123456

ExtTrail ./dirdat/f1

TranlogOptions RawDeviceOffset 0

TranlogOptions ALTARCHIVEDLOGFORMAT yj1a-%r-%t-%S.arc

TranlogOptions MINEFROMACTIVEDG

DynamicResolution

NoCompressUpdates

NoCompressDeletes

ReportCount Every 30 Minutes, Rate

Report at 01:00

ReportRollover at 01:15

DiscardFile ./dirrpt/ep_fme1.dsc, Purge

DiscardRollover at 02:00 ON SUNDAY

TABLE SUN.*

GGSCI>add extract ep_fme1,tranlog ,threads 2,begin now

GGSCI>add exttrail ./dirdat/f1, extract ep_fme1, megabytes 100

现在就可以收取ADG中的日志文件啦。

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report

前一篇：TT_Communication link failure.This operation has Timed Out.

后一篇：python_实现记录遍历目录信息并进行检索

新浪BLOG意见反馈留言板　欢迎批评指正