oracle-dba-cloning-refresh-migrationlisted

USE THIS SKILL for ANY Oracle cloning, environment refresh, or migration request — even when the user does NOT name the task or tool. Covers: RMAN DUPLICATE / database clone, PDB clone & refreshable clones (hot/remote-over-DB-link), snapshot / storage (ASM/NFS/array) clones via hot-backup mode, Data Pump schema refresh (impdp REMAP), test/dev refresh orchestration + non-prod data masking/subsetting, classic transportable tablespaces (TTS), cross-platform transportable tablespaces (XTTS) + endian conversion, Zero Downtime Migration (ZDM) to cloud, and heterogeneous (non-Oracle Gateway / HS / GoldenGate-staging) migration readiness. TRIGGER on symptoms and codes too: "clone prod to test", "refresh QA from prod", "duplicate the database", "stand up a copy", "move to OCI/cloud", "go-live cutover", "transport these tablespaces", "different endian platform", "mask PII in the copy"; and on ORA-19505 / ORA-19625 (DUPLICATE file issues), ORA-65261/65000 (refreshable PDB), ORA-39001/39002/ 39082/39083/31626/31693 (Data
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · API & Backend · score 62

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

# Oracle DBA - Cloning, Refresh & Migration Domain skill for copying, refreshing, and moving Oracle databases (19c & 23ai EE, single_instance / Data Guard, on-prem). It imports `oracle-dba-common`: all in-DB work runs through the SQLcl MCP saved connection `dba_ai_conn` (wallet-backed), secrets resolve from the Oracle Wallet only, and every script obeys the tier rules in `_common/references/conventions.md`. Read-only readiness/precheck automation lives here; every DESTRUCTIVE clone/transport/cutover is a print-only Tier-3 runbook. ## Scope & risk map Every task in the domain, its blast level, autonomy tier, the mechanism that performs it, and whether it is safely re-runnable. `sqlcl-mcp:` = SQL run via `dba_ai_conn`; `script:` = OS wrapper (`.sh`+`.ps1` pair, dry-run default at T2); `runbook:` = print-only. | Task | Level | Tier | Mechanism | Idempotent? | |------|-------|------|-----------|-------------| | Migration source readiness report | OBSERVE | T1 | sqlcl-mcp:sql/migration_source_readiness.sql | yes | | RMAN DUPLICATE clone — source precheck | OBSERVE | T1 | sqlcl-mcp:sql/clone_db_precheck.sql | yes | | PDB clone status (pre/postcheck helper) | OBSERVE | T1 | sqlcl-mcp:sql/pdb_clone_status.sql | yes | | Snapshot / storage-clone readiness | OBSERVE | T1 | sqlcl-mcp:sql/snapshot_clone_readiness.sql | yes | | Schema-refresh (Data Pump) precheck | OBSERVE | T1 | sqlcl-mcp:sql/schema_refresh_precheck.sql | yes | | Data Pump job status (refresh postcheck) | OBSERVE | T1