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

This article mainly introduces "the summary of common commands in goldengate". In daily operation, I believe that many people have doubts about the summary of common commands in goldengate. 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 of "summary of common commands in goldengate". Next, please follow the editor to study!

1. View help

Help, help add exttrail

two。 Displays current GoldenGate environment information

Show

3. View running status

Info all, info mgr, info extract emytest

GGSCI (center) 6 > info rchuc, showch

REPLICAT RCHUC Last Started 2013-12-06 15:13 Status ABENDED

Checkpoint Lag 00:00:00 (updated 442 ago 2913 ago)

Log Read Checkpoint File / u01/app/ggate/dirdat/zsap_chuc/re000011

First Record RBA 2605820

Current Checkpoint Detail:

Read Checkpoint # 1

GGS Log Trail

In this way, a lot of information will be displayed and will not be posted.

4. Start and stop services

Start mgr,stop mgr

Start extract emytest,stop extract emytest

Start replicat rmytest,stop replicat rmytest

If it can't be stopped.

Kill extract emytest

5. Historical command

History

6. Use OBEY (run a file automatically)

Testdb@mytest ggs] $cat / home/testdb/ggs/yzhq.txt

Status manager

Status mgr

[testdb@mytest ggs] $

GGSCI (mytest.mugua) 1 > obey yzhq.txt

GGSCI (mytest.mugua) 2 > status manager

Manager is running (IP port mytest.mugua.7809).

GGSCI (mytest.mugua) 3 > status mgr

Manager is running (IP port mytest.mugua.7809).

GGSCI (mytest.mugua) 4 >

7. Use shell script

Ggsci

< [testdb@mytest ggs]$ ggsci < yzhq.txt GoldenGate Command Interpreter for Oracle Version 10.4.0.12 Build 001 Linux, x86, 32bit (optimized), Oracle 10 on Aug 21 2009 14:34:04 Copyright (C) GoldenGate Software, Inc. 1995-2009. The GoldenGate software may include other code written by third parties; details regarding such third party code, including applicable copyright, legal and licensing notices are available at http://support.goldengate.com. GGSCI (mytest.mugua) 1>

Manager is running (IP port mytest.mugua.7809).

GGSCI (mytest.mugua) 2 >

Manager is running (IP port mytest.mugua.7809).

GGSCI (mytest.mugua) 3 >

[testdb@mytest ggs] $

8. Modify parameter file

Edit params

9. The directory where the parameter files are stored

Storing parameter files

10. Syntax in the parameter file

[,] [&]

11. View command

View params mgr-View parameters

View report emytest-View process reports

twelve。 View statistics for an operation

STATS {EXTRACT | REPLICAT}

Stats er*

13. View the error log contents of GoldenGate

VIEW GGSEVT Contents

14. Deleting a process group

Delete emytest

15.send command

Send extract emugua1, showtrans

Send extract emugua1, status

SEND EXTRACT process name, SKIPTRANS

Skip transactions

SEND EXTRACT process name, FORCETRANS

The transaction is considered to have been committed

Send process name forcestop

Forced killing

16. Alert related commands

-- set tumble

Alter extract EMUGUA1 etrollover

-- set the starting position of the crawling process

Alter EMUGUA1 extseqno 11,extrba 0

-- set the location where the delivery process starts

Alter PMUGUA1 extseqno 11,extrba 0

-- set the start time

ALTER EXTRACT EMUGUA1, TRANLOG, BEGIN 2012-09-14 13:30

-- sets the location where the replication process starts

Alter REPLICAT RMUGUA1 extseqno 10, extrba 0

At this point, the study of "summary of common commands in goldengate" 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.