Thursday, March 15, 2012

Golden Gate Commands : Part1

GGSCI (test1.domain.com) 32> info mgr
Manager is running (IP port test1.domain.com.7809).
GGSCI (test1.domain.com) 34> INFO marker
GGSCI (test1.domain.com) 35> info extract ext3
GGSCI (test1.domain.com) 36> info extract ext3,detail
GGSCI (test1.domain.com) 37> VIEW GGSEVT
*************************************************************************************
VIEW REPORT {group_name[n] | file_name}
GGSCI (test1.domain.com) 44> view report ext3/view report rep3
GGSCI (test1.domain.com) 45> lag extract ext3 --Sending GETLAG request to EXTRACT EXT3
GGSCI (test1.domain.com) 48> dumpddl show
GGSCI (test1.domain.com) 48> history
GGSCI (test1.domain.com) 50> history 5
GGSCI (test1.domain.com) 51> VERSIONS
Operating System:
Linux
Version #1 Wed Jan 5 19:22:18 EST 2005, Release 2.6.9-5.EL
Node: test1.domain.com
Machine: i686

Database:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

**********************************************************************

GGSCI (test1.domain.com) 52> fc
GGSCI (test1.domain.com) 52> VERSIONS
GGSCI (test1.domain.com) 52..
GGSCI (test1.domain.com) 53> fc 9
GGSCI (test1.domain.com) 53> info all
GGSCI (test1.domain.com) 53..
GGSCI (test1.domain.com) 57> shell ls -lrt /home/oracle/gg
GGSCI (test1.domain.com) 58> obey /home/oracle/golden.txt --run command from external file
GGSCI (test1.domain.com) 59> info all
GGSCI (test1.domain.com) 60> view report ext3
[oracle@test1 ~]$ cat golden.txt
info all
view report ext3

No comments: