上传ggs_Linux_x86_ora9i_32bit.zip
#mkdir /goldengate
#chown oracle.dba /goldengate
#unzip ggs_Linux_x86_ora9i_32bit.zip
#mv ggs_Linux_x86_ora9i_32bit.tar /glodengate
$cd /goldengate
$tar -xvf ggs_Linux_x86_ora9i_32bit.tar
$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 9i on Oct 4 2011 23:54:15
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ogg2) 1> help
GGSCI Command Summary:
Object: Command:
SUBDIRS CREATE
ER INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
LAG, REGISTER, SEND, START, STATS, STATUS, STOP
UNREGISTER
EXTTRAIL ADD, ALTER, DELETE, INFO
GGSEVT VIEW
MANAGER INFO, SEND, START, STOP, STATUS
MARKER INFO
PARAMS EDIT, VIEW
REPLICAT ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND,
START, STATS, STATUS, STOP
REPORT VIEW
RMTTRAIL ADD, ALTER, DELETE, INFO
TRACETABLE ADD, DELETE, INFO
TRANDATA ADD, DELETE, INFO
SCHEMATRANDATA ADD, DELETE, INFO
CHECKPOINTTABLE ADD, DELETE, CLEANUP, INFO
Commands without an object:
(Database) DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE
(DDL) DUMPDDL
(Miscellaneous) FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,
SHOW, VERSIONS, ! (note: you must type the word
COMMAND after the ! to display the ! help topic.)
i.e.: GGSCI (sys1)> help ! command
For help on a specific command, type HELP .
Example: HELP ADD REPLICAT
GGSCI (ogg2) 2> create subdirs
Creating subdirectories under current directory /goldengate
Parameter files /goldengate/dirprm: created
Report files /goldengate/dirrpt: created
Checkpoint files /goldengate/dirchk: created
Process status files /goldengate/dirpcs: created
SQL script. files /goldengate/dirsql: created
Database definitions files /goldengate/dirdef: created
Extract data files /goldengate/dirdat: created
Temporary files /goldengate/dirtmp: created
Veridata files /goldengate/dirver: created
Veridata Lock files /goldengate/dirver/lock: created
Veridata Out-Of-Sync files /goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /goldengate/dirver/oosxml: created
Veridata Parameter files /goldengate/dirver/params: created
Veridata Report files /goldengate/dirver/report: created
Veridata Status files /goldengate/dirver/status: created
Veridata Trace files /goldengate/dirver/trace: created
Stdout files /goldengate/dirout: created
生成的相关目录说明:
dirchk:检查点(Checkpoint)文件目录
dirdat:Trail与Extract文件目录
dirdef:通过DEFGEN工具生成的源或目标的数据定义文件目录
dirpcs:存放进程状态文件
dirprm:各进程参数文件目录
dirrpt:进程报告文件目录
dirsql:SQL脚本文件目录
dirtmp:当事务所需要的内存超过已分配内存时,缺省存储目录。
#mkdir /goldengate
#chown oracle.dba /goldengate
#unzip ggs_Linux_x86_ora9i_32bit.zip
#mv ggs_Linux_x86_ora9i_32bit.tar /glodengate
$cd /goldengate
$tar -xvf ggs_Linux_x86_ora9i_32bit.tar
$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 9i on Oct 4 2011 23:54:15
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ogg2) 1> help
GGSCI Command Summary:
Object: Command:
SUBDIRS CREATE
ER INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
LAG, REGISTER, SEND, START, STATS, STATUS, STOP
UNREGISTER
EXTTRAIL ADD, ALTER, DELETE, INFO
GGSEVT VIEW
MANAGER INFO, SEND, START, STOP, STATUS
MARKER INFO
PARAMS EDIT, VIEW
REPLICAT ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND,
START, STATS, STATUS, STOP
REPORT VIEW
RMTTRAIL ADD, ALTER, DELETE, INFO
TRACETABLE ADD, DELETE, INFO
TRANDATA ADD, DELETE, INFO
SCHEMATRANDATA ADD, DELETE, INFO
CHECKPOINTTABLE ADD, DELETE, CLEANUP, INFO
Commands without an object:
(Database) DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE
(DDL) DUMPDDL
(Miscellaneous) FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,
SHOW, VERSIONS, ! (note: you must type the word
COMMAND after the ! to display the ! help topic.)
i.e.: GGSCI (sys1)> help ! command
For help on a specific command, type HELP .
Example: HELP ADD REPLICAT
GGSCI (ogg2) 2> create subdirs
Creating subdirectories under current directory /goldengate
Parameter files /goldengate/dirprm: created
Report files /goldengate/dirrpt: created
Checkpoint files /goldengate/dirchk: created
Process status files /goldengate/dirpcs: created
SQL script. files /goldengate/dirsql: created
Database definitions files /goldengate/dirdef: created
Extract data files /goldengate/dirdat: created
Temporary files /goldengate/dirtmp: created
Veridata files /goldengate/dirver: created
Veridata Lock files /goldengate/dirver/lock: created
Veridata Out-Of-Sync files /goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /goldengate/dirver/oosxml: created
Veridata Parameter files /goldengate/dirver/params: created
Veridata Report files /goldengate/dirver/report: created
Veridata Status files /goldengate/dirver/status: created
Veridata Trace files /goldengate/dirver/trace: created
Stdout files /goldengate/dirout: created
生成的相关目录说明:
dirchk:检查点(Checkpoint)文件目录
dirdat:Trail与Extract文件目录
dirdef:通过DEFGEN工具生成的源或目标的数据定义文件目录
dirpcs:存放进程状态文件
dirprm:各进程参数文件目录
dirrpt:进程报告文件目录
dirsql:SQL脚本文件目录
dirtmp:当事务所需要的内存超过已分配内存时,缺省存储目录。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764468/viewspace-719666/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764468/viewspace-719666/