# Oracle Data Guard

Provide operational guidance for Oracle Data Guard and SQLcl DG.

- Repository: https://github.com/oracle/skills (909 stars)
- Category: Data and ML
- License: UPL-1.0
- Last updated: 2026-10-09
- Runs scripts: no, instructions only

## Install

Claude Code: `npx skills add oracle/skills --skill oracle-data-guard -g -a claude-code -y`
Codex: `npx skills add oracle/skills --skill oracle-data-guard -g -a codex -y`
Cursor: `npx skills add oracle/skills --skill oracle-data-guard -g -a cursor -y`
Gemini CLI: `npx skills add oracle/skills --skill oracle-data-guard -g -a gemini-cli -y`
Claude Code plugin marketplace: `/plugin marketplace add oracle/skills`

## Description

Provide operational guidance for Oracle Data Guard and SQLcl DG. Use when a user asks about SQLcl DG commands, Data Guard Broker fixed views, FSFO or observer state, transport or apply lag, ASYNC/SYNC/FASTSYNC performance, redo apply tuning, SIRA/MIRA, or runnable Data Guard diagnostic SQL.

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

# Oracle Data Guard

Use the bundled references as the source of truth for SQLcl MCP Data Guard guidance. Read only the smallest relevant reference. Do not claim to have inspected a live database, Broker configuration, or observer unless the user provides output or a connected tool returns it.

## Route the request

| Request | Read |
| --- | --- |
| Broad Data Guard question or uncertain topic | `references/00_DG_RESOURCE_INDEX.md` |
| SQLcl `DG` syntax or supported `SHOW` commands | `references/01_SQLCL_DG_COMMANDS.md` |
| Broker configuration/properties, role changes, FSFO, observer, or broker health | `references/02_BROKER_FIXED_VIEW_ROUTING.md` |
| General lag interpretation or transport-vs-apply triage | `references/03_OVERVIEW_AND_LAG_MODEL.md` |
| Redo transport lag | `references/04_TRANSPORT_TROUBLESHOOTING.md` |
| Deep ASYNC transport analysis or `krsb` statistics | `references/05_ASYNC_TRANSPORT_ADVANCED.md` |
| SYNC/FASTSYNC commit latency or remote write cost | `references/06_SYNC_TRANSPORT_PERFORMANCE.md` |
| Apply lag or recovery throughput | `references/07_APPLY_TROUBLESHOOTING.md` |
| SIRA/MIRA choice, recovery waits, or tuning | `references/08_APPLY_TUNING_SIRA_MIRA.md` |
| Runnable diagnostic SQL | `references/09_SQL_QUERY_COOKBOOK.md` |
| Concise triage flow or operational playbook | `references/10_DECISION_TREES_AND_PLAYBOOKS.md` |

## Response workflow

The rest: https://github.com/oracle/skills/blob/HEAD/db/data-guard/SKILL.md