Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the process of building oracle ogg under linux". In the daily operation, I believe that many people have doubts about the process of building oracle ogg under linux. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "the process of building oracle ogg under linux". Next, please follow the editor to study!

Original library:

Create user usera identified by usera

Grant resource, connect,dba to usera

Create table usera.test1 as select * from dba_objects where 1: 2

Alter table usera.test1 add constraint pk_test_table primary key (object_id) enable

Target Library:

Create user userb identified by userb

Grant resource, connect,dba to userb

Create table USERB.TEST2 as select * from dba_objects where 1: 2

Alter table uSERB.TEST2 add constraint pk_test_table2 primary key (object_id) enable

Original and target libraries:

Create tablespace GOLDENGATE_DATASPACE datafile'/ u01 size 2g

Create user goldengate identified by ggs_1234 default tablespace GOLDENGATE_DATASPACE temporary tablespace temp

Grant resource,connect,dba to goldengate

Grant unlimited tablespace to goldengate

Original and target libraries:

SELECT SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING FROM database must be YES

ALTER SYSTEM SWITCH LOGFILE

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

ALTER SYSTEM SWITCH LOGFILE

Alter database force logging

SELECT SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING FROM V$DATABASE

Archive log list # must be in archive mode

Shutdown immediate

Startup mount

Alter database archivelog

Alter database open

Archive log list

Download the software support.oracle.com:

Patches and updates-- "Product [Oracle GoldenGate]--" release [GGATE 11.1.1.1.0-20]-- "platform [Linux x86]

This environment is rhel5 32-bit: p13072170_111112_LINUX.zip

Install ogg under / u01/app/ogg

[oracle@host03 ~] $echo $ORACLE_BASE

/ u01/app/oracle

Su-oracle

Cd / u01/app/

Mkdir ogg

Cd ogg

Upload p13072170_111112_LINUX.zip to the / u01/app/ogg/ directory

Unzip p13072170_111112_LINUX.zip

Tar-xvf fbo_ggs_Linux_x86_ora11g_32bit.tar

[oracle@host03 ~] $PWD

/ u01/app/oracle/ogg

Mkdir dirdat

Mkdir dirrpt

Mkdir dirprm

Mkdir dirpcs

Service iptables status confirms that the firewall is off

Getenforce confirms that selinux is off

Start mgr:

Cd / u01/app/ogg

. / ggsci

Info all

Edit params mgr

# [oracle@host03 dirprm] $cat mgr.prm

# PORT 7809

# DYNAMICPORTLIST 7800-7810

# PURGEOLDEXTRACTS. / dirdat/*/*, USECHECKPOINTS, MINKEEPDAYS 7

# AUTOSTART ER *

# AUTORESTART ER *, RETRIES 5, WAITMINUTES 3, RESETMINUTES 30

# [oracle@host03 dirprm] $pwd

# / u01/app/ogg/dirprm

EDIT PARAMS. / GLOBALS

# [oracle@host03 ogg] $cat GLOBALS

# CHECKPOINTTABLE goldengate.ggschkpt

# [oracle@host03 ogg] $pwd

# / u01/app/ogg

GGSCI (host03.example.com) 1 > info all

Program Status Group Lag Time Since Chkpt

MANAGER STOPPED

GGSCI (host03.example.com) 2 > start mgr

Manager started.

GGSCI (host03.example.com) 4 > info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

Add checkpoint table to the destination side

GGSCI (host03.example.com) 7 > dblogin userid goldengate

Password:

Successfully logged into database.

GGSCI (host03.example.com) 8 > ADD CHECKPOINTTABLE ggschkpt

Successfully created checkpoint table GGSCHKPT.

GGSCI (host03.example.com) 10 > info trandata usera.test1

Logging of supplemental redo log data is disabled for table USERA.TEST1.

GGSCI (host03.example.com) 11 > DELETE TRANDATA usera.test1

Logging of supplemental redo log data is already disabled for table USERA.TEST1.

GGSCI (host03.example.com) 12 > ADD TRANDATA usera.test1

Logging of supplemental redo data enabled for table USERA.TEST1.

GGSCI (host03.example.com) 13 > INFO TRANDATA usera.test1

Logging of supplemental redo log data is enabled for table USERA.TEST1

Target-side definition files, which may be needed for different database types.

-- [oracle@host03 ogg] $vi. / dirprm/defgen20160908.prm

-- [oracle@host03 ogg] $cat. / dirprm/defgen20160908.prm

-- DEFSFILE. / dirdef/ecom20110908.def

-- USERID GOLDENGATE, PASSWORD ggs_1234

-- TABLE usera.test1

-- [oracle@host03 ogg] $. / defgen parameter. / dirprm/defgen20160908.prm

-- 2017-09-17 23:39:11 ERROR OGG-00012 Command line error:invalid startup syntax: parameter.

-- 2017-09-17 23:39:11 ERROR OGG-01668 PROCESS ABENDING.

[oracle@host03 ogg] $cat / dev/null >. / dirrpt/extecom.dsc

[oracle@host03 ogg] $cat / dev/null >. / dirrpt/dppecom.dsc

[oracle@host03 ogg] $cat / dev/null >. / dirrpt/iniecom.dsc

[oracle@host03 ogg] $mkdir. / dirdat/ecom

[oracle@host03 ogg] $cd dirdat/ecom/

[oracle@host03 ecom] $ls # make sure it is empty

Edit the source library to extract process parameter files

[oracle@host03 ogg] $pwd

/ u01/app/ogg

[oracle@host03 ogg] $vi. / dirprm/extecom.prm

# EXTRACT extecom

# SETENV (ORACLE_HOME= "/ u01/app/oracle/product/11.2.0/dbhome_1")

# SETENV (ORACLE_SID= "mydb")

# USERID goldengate, password ggs_1234

#

# discardfile. / dirrpt/extecom.dsc, append, megabytes 1000

# discardrollover at 3:00

#

# warnlongtrans 2h, checkinterval 3m

#

# EXTTRAIL. / dirdat/ecom/ss, megabytes 100

# NUMFILES 3000

# DYNAMICRESOLUTION

# EOFDELAYCSECS 10

#

# TABLE usera.test1

# Edit the source database delivery process parameter file

Vi. / dirprm/dppecom.prm

# EXTRACT dppecom

# RMTHOST 192.168.56.101, MGRPORT 7809

# RMTTRAIL. / dirdat/target/rs

# DISCARDFILE. / dirrpt/dppecom.dsc, PURGE

# PASSTHRU

# DYNAMICRESOLUTION

# EOFDELAYCSECS 10

#

# TABLE usera.test1

Target Library:

[oracle@host03 ogg] $cat / dev/null >. / dirrpt/repecom.dsc

[oracle@host03 ogg] $cat / dev/null >. / dirrpt/rinecom.dsc

# create a target library to initialize the loading process parameter file

Vi. / dirprm/rinecom.prm

# REPLICAT repecom

#

# SETENV (NLS_LANG= "american_america.ZHS16GBK")

# SETENV (ORACLE_HOME= "/ u01/app/oracle/product/11.2.0/dbhome_1")

# SETENV (ORACLE_SID= "mydb")

# USERID goldengate, password ggs_1234

#-SOURCEDEFS. / dirdef/ecom20110908.def

#

# ASSUMETARGETDEFS

#-HANDLECOLLISIONS

#

# reperror default,discard

# DISCARDFILE. / dirrpt/repecom.dsc, PURGE, megabytes 1000

#

#-EXTTRAIL. / dirdat/target/rs

#

# NUMFILES 150

# DYNAMICRESOLUTION

# ALLOWNOOPUPDATES

# GROUPTRANSOPS 1000

#

# MAP USERA.TEST1, TARGET USERB.TEST2

Add process

[oracle@host03 ogg] $pwd

/ u01/app/ogg

[oracle@host03 ogg] $mkdir dirchk

Extraction process:

GGSCI (host03.example.com) 15 > ADD EXTRACT extecom, tranlog, begin now

EXTRACT added.

GGSCI (host03.example.com) 16 > info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED EXTECOM 00:00:00 00:00:03

GGSCI (host03.example.com) 18 > ADD EXTTRAIL. / dirdat/ecom/ss, EXTRACT extecom, megabytes 100

EXTTRAIL added.

GGSCI (host03.example.com) 19 > info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED EXTECOM 00:00:00 00:00:39

Delivery process:

GGSCI (host03.example.com) 20 > ADD EXTRACT dppecom, exttrailsource. / dirdat/ecom/ss

EXTRACT added.

GGSCI (host03.example.com) 21 > ADD RMTTRAIL. / dirdat/target/rs, EXTRACT dppecom, megabytes 100

RMTTRAIL added.

GGSCI (host03.example.com) 22 > info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED DPPECOM 00:00:00 00:00:22

EXTRACT STOPPED EXTECOM 00:00:00 00:02:47

Replication process:

GGSCI (host03.example.com) 23 > add replicat repecom, exttrail. / dirdat/ecom/ss

REPLICAT added.

GGSCI (host03.example.com) 24 > info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED DPPECOM 00:00:00 00:01:06

EXTRACT STOPPED EXTECOM 00:00:00 00:03:31

REPLICAT STOPPED REPECOM 00:00:00 00:00:18

GGSCI (host03.example.com) 30 > delete replicat repecom # # because different directories are better

Deleted REPLICAT REPECOM.

GGSCI (host03.example.com) 31 > info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED DPPECOM 00:00:00 00:02:53

EXTRACT STOPPED EXTECOM 00:00:00 00:05:18

[oracle@host03 ogg] $pwd

/ u01/app/ogg

[oracle@host03 ogg] $mkdir. / dirdat/target/

GGSCI (host03.example.com) 32 > add replicat repecom, exttrail. / dirdat/target/rs

REPLICAT added.

GGSCI (host03.example.com) 33 > info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED DPPECOM 00:00:00 00:03:42

EXTRACT STOPPED EXTECOM 00:00:00 00:06:07

REPLICAT STOPPED REPECOM 00:00:00 00:00:02

Start the process:

[oracle@host03 ogg] $pwd

/ u01/app/ogg

[oracle@host03 ogg] $mkdir dirtmp

[oracle@host03 dirprm] $mv rinecom.prm repecom.prm

GGSCI (host03.example.com) 52 > start EXTECOM

Sending START request to MANAGER...

EXTRACT EXTECOM starting

GGSCI (host03.example.com) 56 > start DPPECOM

Sending START request to MANAGER...

EXTRACT DPPECOM starting

GGSCI (host03.example.com) 57 > start REPECOM

Sending START request to MANAGER...

REPLICAT REPECOM starting

Test it.

Original library:

Sqlplus usera/usera

Select * from test1; # No record

Insert into test1 select * from dba_objects where rownum stats DPPECOM

Sending STATS request to EXTRACT DPPECOM...

Start of Statistics at 2017-09-18 00:25:20.

Output to. / dirdat/target/rs:

Extracting from USERA.TEST1 to USERA.TEST1:

* Total statistics since 2017-09-18 00:22:18 * *

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total discards 0.00

Total operations 1.00

* Daily statistics since 2017-09-18 00:22:18 * *

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total discards 0.00

Total operations 1.00

* Hourly statistics since 2017-09-18 00:22:18 * *

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total discards 0.00

Total operations 1.00

* Latest statistics since 2017-09-18 00:22:18 * *

Total inserts 1.00

Total updates 0.00

Total deletes 0.00

Total discards 0.00

Total operations 1.00

End of Statistics.

At this point, the study of "the process of building oracle ogg under linux" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.