Utilities definitions of Golden Gate Oracle

Utilities and tools definition of Golden Gate Oracle

GGSCI is the GoldenGate Software Command Interface. GGSCI is delivered as part of the GoldenGate software and can be started from the software installation directory using the ggsci command. From the GGSCI command prompt, you can enter commands to manage all parts of the GoldenGate environment including Extracts, Replicats, trails, the Manager, and so on.

Use the GoldenGate DEFGEN utility to generate GoldenGate table-definition files when your source and target tables are different (if the source and target tables are identical, it isn’t necessary to run DEFGEN). You can also use DEFGEN to generate a data-definitions file for a data-pump Extract that is doing data transformations on a middle-tier server.

Use the GoldenGate Logdump utility to view records in the GoldenGate trail files. Logdump lets you view the unstructured trail data in hex and ASCII format and count the number of records in the trail for debugging purposes.

If you ever need to undo database changes, you can use the GoldenGate Reverse utility. Reverse uses a special Extract to capture the before images of changes and then reverses the order of the transactions and writes a new trail file for doing the reversal. A Replicat then processes the special reversed trail to undo database changes. Reverse can be useful for backing out unwanted changes to the database or quickly restoring a test database back to its original state.

Veridata is an additional product from GoldenGate that you can use to verify that your source and target databases match. For critical business applications, you should always verify that your source and target databases match when doing replication. If the databases being replicated are used for failover, this is especially important. Data verification is usually time consuming and difficult to accomplish for large amounts of data.

Director is a graphical tool that you can use to centrally design, configure, manage, and monitor your entire GoldenGate environment. Director is made up of several components, including a centralized server and database repository, a client application, and a web browser interface



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