MSAMM
Back to course

Oracle Apps DBA: Keeping E-Business Suite Alive · Module 5 · Backup and recovery

Cold backups: when they are still right

Lesson 47 of 184 · 2 min

Simple, complete, and REQUIRES AN OUTAGE. The estates where that is STILL the correct trade. A cold backup is the database shut down and its files copied. No tool, no catalogue, no special knowledge — a file copy of a consistent set of files. Restoring is copying them back. THE VIRTUES ARE REAL AND UNDERRATED. It is trivially verifiable: you can see the files. It needs no expertise to restore, which matters when the person restoring at 3am is not you. And it works regardless of archive log mode, which is the only backup that does — a cold copy of a shut-down database is consistent by construction. THE COST IS THE OUTAGE, AND IT IS PROPORTIONAL TO SIZE. A small database is minutes; a large one is hours, every time. That is what rules it out for most production estates — and "most" is doing real work in that…

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Oracle Apps DBA: Keeping E-Business Suite Alive, with a certificate on completion and a fourteen-day refund window.

See the course and enrol9 free lessons

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 5 · Backup and recovery

  1. 1What you are actually protecting against
  2. 2The restore you have never testedFree preview
  3. 3Recovery objectives, in plain terms
  4. 4Cold backups: when they are still right
  5. 5RMAN, from nothing
  6. 6Full, incremental and the strategy behind them
  7. 7Backing up the application tier
  8. 8Point-in-time recovery
  9. 9Restoring to a different host
  10. 10How long does a restore actually take
  11. 11Where the backups live
  12. 12What breaks: five backup failures
  13. 13Lab briefing · Lose the database and get it back