oracle-dba-decommissioning-lifecycle-endlisted

USE THIS SKILL WHENEVER the user is retiring, decommissioning, sunsetting, parking, or ending the life of an Oracle database, PDB, schema, or instance - EVEN IF they do not name the specific task. Covers the FINAL backup before decommission (RMAN KEEP archival), orderly database shutdown / park (SHUTDOWN IMMEDIATE / srvctl stop), schema / object cleanup (reversible ACCOUNT LOCK + PASSWORD EXPIRE quarantine, and the irreversible DROP USER runbook), license / inventory reclamation evidence, data archival & retention compliance (logical archive export + ILM / Flashback Data Archive posture + governed purge), and secure data destruction (TDE crypto-erase / OS secure wipe / media shred). Trigger phrases: "decommission", "retire / sunset the database", "shut down for good", "park the DB", "drop the database / schema", "data destruction / sanitize / wipe", "retention / legal hold at end of life", "reclaim the license", "end of life", "tear down". Follows the oracle-dba-common contracts: SQLcl MCP saved connection db
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · AI & Automation · score 62

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

# Oracle DBA - Decommissioning & Lifecycle End The orderly, evidence-driven retirement of an Oracle database for Oracle 19c and 23ai (EE; single_instance and Data Guard; on-prem). Everything self-executing is **T1 (observe, read-only)** or **T2 (reversible, dry-run-default)**: the final KEEP backup, the orderly **park** (clean shutdown is reversible via `STARTUP`), the reversible **schema quarantine** (lock + expire, no drop), the logical **archive export**, and the read-only lifecycle reports. Every **irreversible end-state - `DROP DATABASE`, PDB unplug+drop, `DROP USER ... CASCADE`, retention purge, secure destruction, license reclamation - is T3** and lives only in `references/runbooks.md`: it prints exact commands for a human and never self-executes. **When in doubt, runbook.** ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | Final backup before decommission (RMAN KEEP archival + archivelog + CF/spfile autobackup) | L2 | T2 | `scripts/final_backup.sh` / `.ps1` + `sql/final_backup_verify.sql` (post) | yes - noop if a COMPLETED tagged backup exists within `--window-hours` (default 24h) | | Pre-decommission inventory / readiness snapshot | L2 | T1 | `scripts/predecommission_inventory.sh` / `.ps1` + `sql/predecommission_inventory.sql` | yes - read-only (emits KEYVAL + metric, never mutates) | | Database shutdown / decommission - orderly PARK