Dev.to
7/22/2026

The original title is "Oracle RMAN Recovery Runbook: Restore, Recover, Prove It"
Original: Oracle RMAN Recovery Runbook: Restore, Recover, Prove It
Short summary
A practical Oracle RMAN recovery runbook covering restore vs recover distinctions, failure-to-command mapping, and specific procedures for block-level, datafile, whole-database, and point-in-time recoveries. Emphasizes that restore copies datafiles from backup while recover applies redo logs to roll them forward. Includes concrete RMAN commands for Oracle 19c with notes for 23ai/26ai, and stresses that untested backups are hopes, not plans.
- •RESTORE copies datafiles from backup; RECOVER applies redo to roll forward — confusing them worsens outages
- •Match the recovery scope to the failure: single datafile, block, or whole DB
- •Point-in-time recovery uses SET UNTIL in a RUN block before restore and recover, followed by OPEN RESETLOGS
Generated with AI, which can make mistakes.
Is this a good recommendation for you?



