ABSTRACT
This chapter demonstrates some basic administration and configuration of Oracle GoldenGate covering credentials, as well as the use of the GoldenGate Software Command Line Interface (GGSCI) tool. Automation can be executed using the HISTORY command, as a script redirected in a shell into GGSCI, and also as a file name added as the parameter to the OBEY command within the GGSCI tool. The simplest method of backup for a GoldenGate installation is to back up all source and target databases, but also to include backup copies of the entire GoldenGate home directory with all GoldenGate processes not running at the time of the backup snapshot. Encryption can also be stored locally on each server or centrally on a designated server. The simplest method of managing encrypted passwords is by using an encryption key stored in a local file, which can be used for password and trail encryption.
