O'Reilly logo

Instant Oracle GoldenGate by Tony Bruzzese

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing Oracle GoldenGate (Simple)

So far we've talked mostly about configurations and very little about managing an OGG instance. We'll discuss some of the more common management commands you'll probably use most often.

How to do it…

Here you'll get to know some of the most useful commands for displaying OGG status and/or for root cause analysis investigation.

  1. We would be investigating long-running transactions when there is a sequence lag of 1 or more logs difference between the recovery checkpoint and the current checkpoint. We do it using the following command:
    GGSCI> info ex01sand showch
    

    The output of the preceding command will be as follows:

    
    Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
     Thread #: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required