OGG monitor 11.1 for ogg 11.2部署手册

章芋文

1571

23页

8次

2019-12-17

5墨值下载

OGG monitor 11.1 for ogg 11.2OGG monitor 11.1 for ogg 11.2

配置OGG 环境

[oracle@localhost ogghome]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25

reserved.

GGSCI (localhost.localdomain) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

GGSCI (localhost.localdomain) 2> create subdirs

Creating subdirectories under current directory /u01/ogg/ogghome

Parameter files /u01/ogg/ogghome/dirprm: already

exists

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

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

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

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

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

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

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

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

GGSCI (localhost.localdomain) 3> edit params mgr

USERID ogguser,PASSWORD ogguser

PORT 7848

GGSCI (localhost.localdomain) 1> edit params ./GLOBALS

GGSCHEMA ogguser

CHECKPOINTTABLE ogguser.checkpoint

SQL> conn awen/oracle

Connected.

SQL> create table ogg_obj as select * from dba_objects where 1=2;

Table created.

SQL> create table ogg_seg as select * from dba_segments where 1=2;

Table created.

SQL> conn scott/oracle

Connected.

SQL> create table ogg_obj as select * from dba_objects where 1=2;

Table created.

SQL> create table ogg_seg as select * from dba_segments where 1=2;

Table created.

GGSCI (localhost.localdomain) 2> dblogin userid ogguser,password

ogguser

Successfully logged into database.

GGSCI (localhost.localdomain) 4> add trandata awen.ogg_obj

2013-08-22 10:17:15 WARNING OGG-00869 No unique key is defined

for table 'OGG_OBJ'. All viable columns will be used to represent

the key, but may not guarantee uniqueness. KEYCOLS may be used to

define the key.

Logging of supplemental redo data enabled for table AWEN.OGG_OBJ.

GGSCI (localhost.localdomain) 5> add trandata awen.ogg_seg

2013-08-22 10:17:27 WARNING OGG-00869 No unique key is defined

for table 'OGG_SEG'. All viable columns will be used to represent

the key, but may not guarantee uniqueness. KEYCOLS may be used to

define the key.

Logging of supplemental redo data enabled for table AWEN.OGG_SEG.

GGSCI (localhost.localdomain) 6> add extract awen_ext, tranlog,

begin now

EXTRACT added.

of 23

5墨值下载

关注

评论