Posted in 2016

usefull goldengate commands

---
- GoldenGate Guru

- Manager
  - each manager needs a default PORT for communication
  - each manager instance has another PORT
  - use DYNAMICPORTLIST on target hosts after FW
  - commands:
    ggsci> EDIT PARAMS MGR
    ggsci> START MANAGER
    ggsci> STOP MANAGER [!]

- OBEY Files # frequently used commands
  - OBEY file_name
	# example - start_extract
	ADD EXTRACT myext, TRANLOG, BEGIN now
	START EXTRACT myext
	INFO EXTRACT myext, DETAIL
	INFO REPLICAT myrep, DETAIL

    ggsci> OBEY start_extract

- Controlling EXTRACT|REPLICAT
  - Start/Stop
    ggsci> START|STOP {EXTRACT|REPLICAT} group_name or extgroup* # wildcard
  - Delete EXTRACT
    ggsci> DBLOGIN USERID user, PASSWORD pwd
    ggsci> STOP EXTRACT group_name
    ggsci> DELETE EXTRACT group_name
    ggsci> UNREGISTER EXTRACT group_name,database_name # Oracle

  - Delete REPLICAT
    ggsci> STOP REPLICAT group_name
    ggsci> DBLOGIN USERID user, PASSWORD pwd
    ggsci> DELETE REPLICAT group_name

  - View a Parameter File
    ggsci> VIEW PARAMS group_name   
Advertisements

Author:

Database administrator who loves to work with Oracle software. (Sometimes not)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s