ORACLEOracle solutions

Oracle databases that stay up

Administration, standby databases, migrations and application support for Oracle estates, on-premises or hybrid.

dgmgrl · erpprod
DGMGRL> show configuration;

Configuration - erp_dg

  Protection Mode: MaxAvailability
  Members:
  erpprod  - Primary database
    erpstby  - Physical standby database

Fast-Start Failover: Enabled in Zero Data Loss Mode

Configuration Status:
SUCCESS

DGMGRL> validate database erpstby;

  Database Role:     Physical standby database
  Primary Database:  erpprod

  Ready for Switchover:  Yes
  Ready for Failover:    Yes (Primary Running)
DGMGRL> 
Illustration of a standby database health check with the Data Guard broker.

Disaster recovery

A standby ready to take over

We set up standby databases at a second site, test the switch regularly, and document exactly what happens when the primary fails.

  • Changes shipped continuously to the standby
  • Automatic or manual switchover, tested on a schedule
  • Applications reconnect to the new primary
redo shipping ApplicationsERP, web, reports Oracle databasePrimary · site A Oracle databaseUnavailable Oracle databaseStandby · site B Oracle databasePrimary · site B ObserverWatches both sitesNormal operation · changes copied to the standbyPrimary failed · standby promoted, applications reconnected
Animation: changes are copied to a standby database, which takes over if the primary fails.

A typical upgrade

The standby is built and tested before anything changes in production.

A typical Oracle upgrade with a standbyTypical example. Your timeline depends on scope.
Health check
Standby build
Switchover test
Upgrade rehearsal
Production upgrade
Monitoring
You receiveHealth check reportRecovery runbookSwitchover test results

What we do

Oracle work your team can rely on

Administration
Performance tuning, patching, backup and recovery.
Standby and recovery
Standby databases at a second site, with recovery tests.
Upgrades and moves
Version upgrades and platform moves with rehearsed cutovers.
Licensing review
Understand what you use and where you can save.
Application support
Maintenance and integration for Oracle-based applications.
Monitoring
Alerts on space, performance and replication health.

Platforms around your Oracle databases

  • Red Hat
  • Linux
  • VMware
  • PostgreSQL
  • Docker
  • Kubernetes
  • Grafana

Tell us about your Oracle estate

Versions, sizes and how you recover today: we will suggest where to start.

Talk to an Oracle engineer →

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. ETDLedger is an independent service provider and is not affiliated with Oracle.