oracle-dba-data-guard-disaster-recoverylisted

USE THIS SKILL for ANY Oracle Data Guard / standby / disaster-recovery / HA request - EVEN IF the user does not name the task. Triggers: physical/standby database, redo transport & apply, apply/transport LAG, archive/redo GAP, switchover, FAILOVER, reinstate failed primary, standby build/rebuild (RMAN active duplicate), Active Data Guard / real-time query / DML redirect, Fast-Start Failover (FSFO) + observer, snapshot standby, cascaded standby, Data Guard broker (dgmgrl), protection modes (Max Protection/Availability/ Performance), Far Sync, role-based services. Symptoms: "standby is behind", "apply stopped", "MRP not running", "redo not shipping", "lost the primary", "DR site", "promote standby". Error codes: ORA-16xxx broker/DG family (ORA-16700/16766/16778/16789/16809/16810/16664/16661 reinstate, ORA-16143/16131), ORA-01153, ORA-19909 (standby_became_primary), ORA-00752, RMAN-05xxx during DUPLICATE ... FOR STANDBY, CRS-xxxx when srvctl relocates DG services. Follows oracle-dba-common contracts: in-DB work
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · AI & Automation · score 62

Install: claude install-skill Shreyas70773/oracle-dba-agentic-skills

# Oracle DBA - Data Guard / Disaster Recovery Physical-standby Data Guard for Oracle **19c and 23ai**, Enterprise Edition, single-instance and Data Guard, on-prem. In-DB SQL runs through the SQLcl MCP server on the saved connection **`dba_ai_conn`** (wallet). Host tools (`dgmgrl`, `rman`, `srvctl`, `sqlplus`) cannot go through the SQLcl MCP server (it is in-DB only) - they run from a shell via a script or a runbook, and would later front a guarded `oracle-dba-ops` MCP. ## Scope & risk map Every task in this domain (both authoring halves), with its self-execute tier and the exact mechanism. T1 = read-only/observe (self-executes freely); T2 = reversible (self-executes only with `--dry-run` default + explicit `--execute`); T3 = destructive / role-change / structural (runbook-only + `require_approval_token`, NEVER self-executes). | Task | Level | Tier | Mechanism (path) | Idempotent? | |------|-------|------|------------------|-------------| | Data Guard status / health snapshot | L1 | T1 | script:`scripts/dg_status.sh` / `scripts/dg_status.ps1` (db\|broker\|all) + sqlcl-mcp:`sql/dg_status.sql` | yes (read-only) | | Apply + transport lag report | L1 | T1 | sqlcl-mcp:`sql/dg_lag_monitor.sql`; tighter pre-role-change: `sql/dg_apply_lag.sql` | yes (read-only) | | Standby Redo Apply (MRP) status | L1 | T1 | sqlcl-mcp:`sql/standby_apply_status.sql` | yes (read-only) | | DG readiness PASS/FAIL inventory | L1 | T1 | sqlcl-mcp:`sql/dg_config_check.sql` | yes (read-only) | | Archive /