oracle-data-guard
Installation
SKILL.md
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 |