§ 03 — Database Administration
Students often use "backup" and "recovery" as if they mean the same thing. They are related, but not identical.
A good DBA asks not only, "Do we have backups?" but also:
Important backup ideas include:
A backup that has never been tested is only a promise, not proof.
When organizations recover from failure, two measures are very important:
| Term | Meaning |
|---|---|
| RPO | Recovery Point Objective — how much data loss is acceptable |
| RTO | Recovery Time Objective — how long downtime can last |
Example:
These values shape the backup plan. A weekly backup alone is not enough for a system with strict RPO and RTO.
Restore planning should include:
DBAs are expected to think in service terms, not just file terms.
Pro2 reviewers locked
Part of this subject's paid reviewers. Not included in this printout.
Done with this module? Track it — your progress shows on the subject list.
Studying with blockmates? Send them this lesson.
Up next
Lesson 7: Security, Access Control, Auditing, and Data Privacy→←Previous: Lesson 5: Transactions, Concurrency Control, and Recovery Basics