Merry Christmas & Happy 2027! Less downtime. More good times. Celebrating 13 years of sorlavit.com
Skip to content
Sorlavit KimIT Support, Network & Infrastructure Services Let’s talk

ปุ่มแปลไทยจะเปิดบทความผ่าน Google Translate เพื่อแปลอัตโนมัติ โดยคงโค้ดและคำสั่งไว้ตามต้นฉบับ

Oracle Database / Data Guard & High Availability

Use broker validation before planning a role transition

A healthy-looking standby can still have configuration or recovery gaps that complicate a switchover. Gather readiness diagnostics in advance.

Compiled for Sorlavit Kim · Published · Updated · 1 min read

Environment and inputs: Oracle Database 19c baseline · SQL*Plus-compatible SQL unless RMAN, DGMGRL, ADRCI or a host shell is specified. Check release, patch level, edition and container first.

Start with this diagnostic

Use the stated SQL, RMAN, DGMGRL or host shell and replace sample names with approved targets. DBA and V$ views need authorized catalog access in the correct container. Do not grant broad privileges for an example.

VALIDATE DATABASE VERBOSE 'STBY';

Read the result

In DGMGRL, validation reports checks for the selected member. It can perform diagnostic work but does not execute a switchover or certify the whole application cutover.

Resolve and verify

Resolve reported issues and include service routing, backup, monitoring and rollback steps in the transition plan. Rehearse the full runbook in the supported environment.

Operational precautions

Do not treat one successful validation as authorization to transition roles or as proof of zero application downtime.

Share this article

Back to all articles