1. 首页 > ITPUX技术网 > 正文

Oracle Goldengate OBEY参数用法

Oracle Goldengate OBEY用法

OBEY
Use OBEY to process a file that contains a list of Oracle GoldenGate commands. OBEY is
useful for executing commands that are frequently used in sequence.
You can call one OBEY file from another one. This is called a nested OBEY file. You can nest
up to 16 OBEY files. To use nested OBEY files, you must enable the functionality by first
issuing the ALLOWNESTED command. See page 88.
Syntax OBEY
Example 1 obey ./mycommands.txt
The preceding command executes a file that might look something like this:
add extract fin, tranlog, begin now
add exttrail ggs/dirdat/aa, extract fin
add extract hr, tranlog, begin now
add exttrail ggs/dirdat/bb, extract hr
start extract *
info extract *, detail

Example 2
The following illustrates a nested OBEY file. Assume an OBEY file named addcmds.txt. Inside
this file, there is another OBEY command that calls the OBEY file named startcmds.txt, which
executes another set of commands.
obey ./addcmds.txt
Argument Description
COUNT Restricts the list to a specified number of the most recent markers.
Argument Description
The fully qualified name of the file that contains the list of commands.
GGSCI Commands
SHELL
Oracle GoldenGate Windows and UNIX Reference Guide 93
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(This executes the following:)
add extract fin, tranlog, begin now
add exttrail ggs/dirdat/aa, extract fin
add extract hr, tranlog, begin now
add exttrail ggs/dirdat/bb, extract hr
add replicat fin2, exttrail ggs/dirdat/aa, begin now
add replicat hr2, exttrail ggs/dirdat/bb, begin now
obey ./startcmds.txt
(The nested startcmds.txt file executes the following:)
start extract *
info extract *, detail
start replicat *
info replicat *, detail

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

联系我们

在线咨询:点击这里给我发消息

微信号:itpux-com

工作日:9:30-18:30,节假日休息