{"id":1519,"date":"2010-04-13T09:46:42","date_gmt":"2010-04-13T14:46:42","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=1519"},"modified":"2012-09-08T10:13:26","modified_gmt":"2012-09-08T15:13:26","slug":"goldengate-commands-misc-commands","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=1519","title":{"rendered":"GoldenGate Commands: Misc Commands"},"content":{"rendered":"

Misc Commands<\/h2><\/span>\n

!<\/h3><\/span>\n

Execute current or history command.<\/p>\n

Syntax<\/h4><\/span>\n
! [n | -n | string]\r\nn: execute command line n in the command history.\r\n-n: execute n lines before the current line.\r\nstring: execute last command that starts with string.\r\n<\/pre>\n
Examples<\/h4><\/span>\n
\r\n!\r\n! 4\r\n! -9\r\n! show\r\n<\/pre>\n
CREATE SUBDIRS<\/h2><\/span>\n
Create default directories within GoldenGate home directory.<\/p>\n
FC<\/h2><\/span>\n
Edit previous commands before execute.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nFC [n | -n | string]\r\nn: execute command line n in the command history.\r\n-n: execute n lines before the current line.\r\nstring: execute last command that starts with string.\r\n<\/pre>\n
* Command editing:
\n– Enter fc<\/em> command
\n– Position cursor under the character you want to edit<\/p>\n
\r\ni : insert text\r\nr : replace text\r\n: you can directly type in replacement text, same as r \r\nd: delete character\r\n<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 48> history\r\n\r\nGGSCI Command History\r\n\r\n   39: help info\r\n   40: help add replicat\r\n   41: versions\r\n   42: VIEW GGSEVT\r\n   43: view report\r\n   44: view reports\r\n   45: view report r_gt.rpt\r\n   46: view report R_GT.rpt\r\n   47: view report dirrpt\/R_GT.rpt\r\n   48: history\r\n\r\n\r\nGGSCI 49> info mgr\r\n\r\nManager is running (IP port wlbox.7809).\r\n\r\n\r\nGGSCI 50> fc\r\nGGSCI 50> info mgr\r\nGGSCI 50..     all\r\nGGSCI 50> info all\r\nGGSCI 50..\r\n\r\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nEXTRACT     RUNNING     E_GT        00:00:00      00:00:01    \r\nREPLICAT    RUNNING     R_GT        00:00:00      00:00:04    \r\n\r\n\r\nGGSCI 51> fc\r\nGGSCI 51> info all\r\nGGSCI 51..     e_gt\r\nGGSCI 51> info e_gt\r\nGGSCI 51..\r\n\r\nEXTRACT    E_GT      Last Started 2012-09-08 07:24   Status RUNNING\r\nCheckpoint Lag       00:00:00 (updated 00:00:05 ago)\r\nLog Read Checkpoint  Oracle Redo Logs\r\n                     2012-09-08 08:11:30  Seqno 188, RBA 3990016\r\n                     SCN 0.6670083 (6670083)\r\n<\/pre>\n
HELP<\/h2><\/span>\n
Displays command help<\/p>\n
Syntax<\/h3><\/span>\n
\r\nHELP [cmd]<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 40> help add replicat\r\n\r\n \r\nADD REPLICAT \r\n \r\nUse ADD REPLICAT to create a Replicat group. Unless SPECIALRUN is \r\nspecified, ADD REPLICAT creates checkpoints so that processing \r\ncontinuity is maintained from run to run. Before creating a Replicat \r\ngroup, review the Oracle GoldenGate Windows and UNIX Administrator's \r\nGuide. \r\n \r\nThis command cannot exceed 500 bytes in size for all keywords and \r\ninput, including any text that you enter for the DESC option. \r\n...\r\n<\/pre>\n
HISTORY<\/h2><\/span>\n
View command history.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nHISTORY [n]\r\n\r\nn: display n number of command history.\r\n<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 14> history 2\r\nGGSCI Command History\r\n   13: history\r\n   14: history 2<\/pre>\n
INFO ALL<\/h2><\/span>\n
Display status and lag of all Manager, Extract, Replicat processes.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nINFO ALL [TASKS | ALLPROCESSES]\r\n\r\nTASKS: display tasks only.\r\n<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 15> info all\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\nMANAGER     STOPPED\r\nEXTRACT     STOPPED     ODISC       00:00:00      16:33:41\r\nEXTRACT     STOPPED     ODIT1P      00:00:00      16:33:42\r\n\r\nGGSCI 16> info all tasks\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nGGSCI 17> info all all processes\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\nMANAGER     STOPPED\r\nEXTRACT     STOPPED     ODISC       00:00:00      16:33:56\r\nEXTRACT     STOPPED     ODIT1P      00:00:00      16:33:56<\/pre>\n
INFO MARKER<\/h2><\/span>\n
View recently processed markers from a NonStop system.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nINFO MARKER [COUNT n]\r\nCOUNT : view most recent n markers. \r\n<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 18> info marker\r\nNo markers to display.\r\n\r\nGGSCI 19> info marker count 2\r\nNo markers to display.<\/pre>\n
OBEY<\/h2><\/span>\n
Execute a command file.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nOBEY <\/pre>\n
Examples<\/h3><\/span>\n
\r\nOBEY .\/mycommands.txt<\/pre>\n
SHELL<\/h2><\/span>\n
Execute shell commands.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nSHELL <\/pre>\n
Examples<\/h3><\/span>\n
\r\nSHELL dir\r\n<\/pre>\n
SHOW<\/h2><\/span>\n
Show GoldenGate environment.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nSHOW<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 36> show\r\n\r\nParameter settings:\r\n\r\nSET SUBDIRS    ON\r\nSET DEBUG      OFF\r\n\r\nCurrent directory: \/u01\/Oracle\/GoldenGate\/gg1121\r\n\r\nUsing subdirectories for all process files\r\n\r\nEditor:  vi\r\n\r\nReports (.rpt)                 \/u01\/Oracle\/GoldenGate\/gg1121\/dirrpt\r\nParameters (.prm)              \/u01\/Oracle\/GoldenGate\/gg1121\/dirprm\r\nStdout (.out)                  \/u01\/Oracle\/GoldenGate\/gg1121\/dirout\r\nReplicat Checkpoints (.cpr)    \/u01\/Oracle\/GoldenGate\/gg1121\/dirchk\r\nExtract Checkpoints (.cpe)     \/u01\/Oracle\/GoldenGate\/gg1121\/dirchk\r\nProcess Status (.pcs)          \/u01\/Oracle\/GoldenGate\/gg1121\/dirpcs\r\nSQL Scripts (.sql)             \/u01\/Oracle\/GoldenGate\/gg1121\/dirsql\r\nDatabase Definitions (.def)    \/u01\/Oracle\/GoldenGate\/gg1121\/dirdef\r\n<\/pre>\n
VERSIONS<\/h2><\/span>\n
Show OS and DB versions.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nVERSIONS<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 41> versions\r\nOperating System:\r\nLinux\r\nVersion #1 SMP Mon Mar 29 20:06:41 EDT 2010, Release 2.6.18-194.el5\r\nNode: wlbox\r\nMachine: i686\r\n\r\nDatabase:\r\nOracle Database 10g Express Edition Release 10.2.0.1.0 - Product\r\nPL\/SQL Release 10.2.0.1.0 - Production\r\nCORE    10.2.0.1.0      Production\r\nTNS for Linux: Version 10.2.0.1.0 - Production\r\nNLSRTL Version 10.2.0.1.0 - Production\r\n\r\n<\/pre>\n
VIEW GGSEVT<\/h2><\/span>\n
View GoldenGate event logs.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nVIEW GGSEVT<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 42> VIEW GGSEVT\r\n\r\n2012-09-07 20:21:31  INFO    OGG-00987  Oracle GoldenGate Command Interpreter fo\r\nr Oracle:  GGSCI command (oracle): START MANAGER.\r\n2012-09-07 20:22:16  INFO    OGG-00987  Oracle GoldenGate Command Interpreter fo\r\nr Oracle:  GGSCI command (oracle): EDIT MANAGER MGR.\r\n2012-09-07 20:22:33  INFO    OGG-00987  Oracle GoldenGate Command Interpreter fo\r\nr Oracle:  GGSCI command (oracle): EDIT PARAMS MGR.\r\n2012-09-07 20:22:54  INFO    OGG-00987  Oracle GoldenGate Command Interpreter fo\r\nr Oracle:  GGSCI command (oracle): start manager.\r\n\r\n<\/pre>\n
VIEW REPORT<\/h2><\/span>\n
View process report generated by Extract or Replicat.<\/p>\n
Syntax<\/h3><\/span>\n
\r\nVIEW REPORT {[n] | }\r\n: The name of the group. The command assumes the report file named\r\n.rpt in the GoldenGate dirrpt sub-directory.\r\nn: The number of an old report. Report files are numbered from 0 (the most\r\nrecent) to 9 (the oldest).\r\n: A fully qualified file name, such as c:\\ggs\\dirrpt\\orders.rpt.<\/pre>\n
Examples<\/h3><\/span>\n
\r\nGGSCI 47> view report dirrpt\/R_GT.rpt\r\n\r\n\r\n***********************************************************************\r\n                 Oracle GoldenGate Delivery for Oracle\r\n    Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO\r\n   Linux, x86, 32bit (optimized), Oracle 10g on Apr 23 2012 07:23:02\r\n \r\nCopyright (C) 1995, 2012, Oracle and\/or its affiliates. All rights reserved.\r\n\r\n\r\n                    Starting at 2012-09-08 07:28:18\r\n***********************************************************************\r\n\r\nOperating System Version:\r\nLinux\r\nVersion #1 SMP Mon Mar 29 20:06:41 EDT 2010, Release 2.6.18-194.el5\r\nNode: wlbox\r\nMachine: i686\r\n                         soft limit   hard limit\r\nAddress Space Size   :    unlimited    unlimited\r\nHeap Size            :    unlimited    unlimited\r\nFile Size            :    unlimited    unlimited\r\nCPU Time             :    unlimited    unlimited\r\n...\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Misc Commands ! Execute current or history command. Syntax ! [n | -n | string] n: execute command line n in the command history. -n: execute n lines before the current line. string: execute last command that starts with string. … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[88],"tags":[231,587],"class_list":["post-1519","post","type-post","status-publish","format-standard","hentry","category-goldengate","tag-commands","tag-goldengate"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-ov","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1519"}],"version-history":[{"count":12,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1519\/revisions"}],"predecessor-version":[{"id":5883,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1519\/revisions\/5883"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}