oracle-dba-flashback-technologieslisted

USE THIS SKILL WHENEVER the user mentions Oracle Flashback in any form — Flashback Query / AS OF, Flashback Version Query / VERSIONS BETWEEN, Flashback Table, Flashback Drop / recyclebin / "undrop" a dropped table, Flashback Transaction / TRANSACTION_BACKOUT / backing out a committed transaction, restore points (normal or GUARANTEE FLASHBACK DATABASE), Flashback Data Archive / FDA / "Total Recall" / long-term row history, or Flashback Database / FLASHBACK DATABASE TO RESTORE POINT / rewinding the whole database — EVEN IF they do not name the exact task. Also triggers on undo-based "get the old rows back", "recover a dropped/truncated table without a restore", or errors ORA-01555 (snapshot too old), ORA-08180 (no snapshot at this time), ORA-38xxx (flashback/restore point), ORA-55xxx (flashback archive / transaction backout). Covers read-only inspection (Flashback Query/Version Query, recyclebin/FDA/restore-point listing), reversible T2 recovery (Flashback Table, Flashback Drop undrop, Flashback Transaction bac
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · API & Backend · score 62

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

# Oracle DBA - Flashback Technologies Oracle's flashback family for **19c and 23ai** (EE; single_instance and Data Guard; on-prem): undo-based inspection and rewind (Flashback Query / Version Query, Flashback Table, Flashback Transaction), recyclebin recovery (Flashback Drop), restore points (normal and GUARANTEE FLASHBACK DATABASE), Flashback Data Archive (FDA) for long-term history, and the plan-only **Tier-3 FLASHBACK DATABASE** rewind. Everything self-executing is **T1 (observe)** or **T2 (reversible, dry-run-default)**. **FLASHBACK DATABASE rewinds the whole DB and is T3** — it lives only in `references/runbooks.md#flashback-database`, prints commands for a human, and never self-executes. > Decision order, least-disruptive first: **Flashback Query** (just look) -> **Flashback > Table / Drop / Transaction** (one object/txn, online, T2) -> **TSPITR / RECOVER TABLE** > (backup-and-recovery skill, T3) -> **FLASHBACK DATABASE** (whole DB, T3, last resort > before full PITR). Always inspect with a read-only query before any mutating flashback. ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | Flashback Query (AS OF) + Flashback Version Query (VERSIONS BETWEEN) | L2 | T1 | `scripts/flashback_query.sh` / `.ps1` + `sql/flashback_query.sql` | yes — read-only (no DML/DDL; emits row sample + context) | | Recyclebin inventory (undrop candidates) | L