Database Management · Advanced level

Advanced level · Module 6: Database Capstone · Lesson 4 of 5

Backup, Replication and Recovery

Automate backups, add a standby, and prove recovery against the agreed RPO and RTO.

In this lesson you will

  • Implement backups and replication
  • Run and document recovery drills

Key concepts

automated backupsstandby replicafailoverrecovery drill

The lesson

Schedule automated, encrypted backups with off-site copies and configure a streaming standby.

Run a failover drill and a restore drill from backup. Record the actual data loss and time to recover.

Compare the results with the RPO and RTO, and fix gaps before declaring the system ready.

Step by step

  1. Configure automated, encrypted backups.
  2. Set up the standby.
  3. Run failover and restore drills.
  4. Record results against the targets.

Practice activity

Complete milestone 4: recovery evidence.

Expected result: Drill results that meet the RPO and RTO, or a plan to close any gap.

Check your understanding

  1. Which two drills prove recovery?

    Show answer

    A failover drill and a restore from backup.

  2. What should happen if a drill misses the RTO?

    Show answer

    Fix the gaps and repeat the drill before going live.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.