Configuration Risk Analysis forOracle GoldenGate

Oracle GoldenGate

AvailabilityGuard for Oracle GoldenGate

You’ve invested a great deal of time and effort in building a replicated environment using Oracle GoldenGate. But will those replicated servers work when you need them most? In the event of a disaster, is the replicated copy of your critical business data guaranteed to be consistent and complete? Will you be able to meet with business’s RPO and RTO requirements, and ensure a smooth and flawless recovery?

Let’s face it: it is difficult to keep your Oracle GoldenGate implementation perfectly aligned with vendor best-practices, and in sync with changes in Oracle database and other IT layers that Oracle GoldenGate interfaces with.

Oracle GoldenGate Configuration Risk Analysis

AvailabilityGuard automatically checks that your Oracle GoldenGate configuration follows Oracle’s best practices and verifying that It is configured correctly relative to the OS, Storage and other layers.

  • Incomplete data replication for DR
  • Oracle best practices for GoldenGate (Streams pool, Replicat parameters, Log Archiving, HANDLECOLLLIONS guidelines)
  • RPO (Lag) measurement and target SLA violation detection.
  • Verify data is available at a remote site.
  • Verify all required Oracle databases are protected (DataGuard, GoldenGate, Storage Replication or other mean as required).

Oracle Database and GoldenGate Environment

AvailabilityGuard ensures Oracle databases and underlying infrastructure are correctly configured to avoid data loss and downtime risks. It also detects any miconfigurations that could lead to potential problems in data availability and recoverability at the remote facility.

  • Collect Oracle and Database Server Config (Data Files, Tablespaces, DB Parameters, RAC config, ASM diskgroups and more)
  • Collect GoldenGate Configuration (Agent, Capture, Trail, Delivery (Replicat), measured RPO and more)
  • Top-down topology (Database, GoldenGate, Virtual Server, Physical Server, Storage)

Source and Standby Host Comparison

  • Host Configuration (installed software, kernel parameters, DNS, NIC and HBAs, computing power etc.)
  • Storage (disk type, I/O paths, RAID level, etc.)
  • Ensure DR database will be capable of providing the required service level.