oracle-dba-backup-and-recoverylisted

USE THIS SKILL WHENEVER the user mentions RMAN, backups, restore, recover/recovery, Data Pump, expdp/impdp, archivelog, FRA / fast recovery area, retention policy, crosscheck, obsolete/expired backups, recovery catalog, control file or spfile autobackup, restore points, flashback, PITR / point-in-time recovery, TSPITR, block media recovery / block corruption, DR drills, cross-platform CONVERT, or any of the errors ORA-01578 (block corruption), ORA-19xxx (RMAN/backup I/O), or RMAN-xxxxx — EVEN IF they do not name the specific task. Covers scheduled RMAN full/incremental/archivelog backups, RMAN CONFIGURE, backup status monitoring and VALIDATE, crosscheck+delete within retention, recovery-catalog maintenance, Data Pump export/import, guaranteed restore point create/list/drop, and (plan-only, human-driven) recovery runbooks. Follows the oracle-dba-common contracts: SQLcl MCP saved connection dba_ai_conn, Oracle Wallet secrets (never plaintext), --dry-run defaults on T2, and tier gating (max self-execute = T2; al
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · API & Backend · score 62

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

# Oracle DBA - Backup & Recovery Physical backups (RMAN), logical backups (Data Pump), backup verification & lifecycle (validate / crosscheck / catalog), guaranteed restore points, and the plan-only Tier-3 recovery runbooks for Oracle 19c and 23ai (EE; single-instance and Data Guard; on-prem). Everything self-executing is **T1 (observe)** or **T2 (reversible, dry-run-default)**. Every actual **restore/recover is T3** and lives only in `references/runbooks.md` — it prints commands for a human and never self-executes. ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | RMAN scheduled full (level-0) backup + archivelog + CF autobackup | L1 | T2 | `scripts/rman_full_backup.sh` / `.ps1` -> `rman/full.rman` | yes — noop if a COMPLETED DB FULL/INCR exists within `--window-hours` (default 20h) | | RMAN incremental backup (level 0/1, differential/cumulative, IUB) | L1 | T2 | `scripts/rman_incremental_backup.sh` / `.ps1` -> `rman/incr.rman` | yes — noop if matching COMPLETED incr/level-0 exists within window | | RMAN archivelog backup (+ optional input reclaim) | L1 | T2 | `scripts/rman_archivelog_backup.sh` / `.ps1` -> `rman/arch.rman` | yes — noop when no archived logs have `backup_count=0` | | RMAN persistent CONFIGURE (retention, parallelism, compression, encryption-aware) + CF/spfile autobackup | L2 | T2 | `scripts/configure_rman.sh` / `.ps1` -> `rm