Point-in-time recovery (PITR) in DynamoDB - Step-by-Step Execution

Concept Flow - Point-in-time recovery (PITR)

Enable PITR on Table

↓

Continuous Backups

↓

Data Changes Recorded

↓

Choose Recovery Time

↓

Restore Table to Chosen Time

↓

New Table Created with Restored Data

PITR keeps continuous backups of your DynamoDB table. You pick a time, and it restores the table to that exact moment.

Execution Sample

DynamoDB

1. Enable PITR on 'Orders' table
2. Make changes: add, update, delete items
3. Choose recovery time: 10:00 AM
4. Restore table to 10:00 AM state

Shows enabling PITR, making changes, then restoring the table to a past time.

Execution Table

Step	Action	Backup State	Recovery Time Chosen	Result
1	Enable PITR on 'Orders'	Backups start from now	None	PITR enabled
2	Add item A	Backup records item A	None	Item A added
3	Update item B	Backup records update	None	Item B updated
4	Delete item C	Backup records deletion	None	Item C deleted
5	Choose recovery time 10:00 AM	Backups up to 10:00 AM	10:00 AM	Recovery time set
6	Restore table to 10:00 AM	Backups used to restore	10:00 AM	New table with data as of 10:00 AM created
7	Use restored table	N/A	10:00 AM	Data reflects state at 10:00 AM

💡 Restoration completes with a new table reflecting the chosen point in time.

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4	After Step 6
Table Data	Empty	Item A added	Item B updated	Item C deleted	Restored to 10:00 AM state

Key Moments - 2 Insights

Why does PITR create a new table instead of changing the original?

Because the original table keeps changing, PITR restores data to a new table to avoid overwriting current data, as shown in step 6 of the execution_table.

Can I restore to a time before PITR was enabled?

No, PITR only keeps backups from when it was enabled, so recovery times before enabling are not available, as seen in step 1 where backups start.

Visual Quiz - 3 Questions

Look at the execution_table, what is the backup state after adding item A?

A Backups start from now

B Backup records deletion

C Backup records item A

D Backups up to 10:00 AM

💡 Hint

Check the 'Backup State' column at step 2 in the execution_table.

At which step is the recovery time chosen?

A Step 4

B Step 5

C Step 6

D Step 7

💡 Hint

Look for 'Choose recovery time' action in the execution_table.

If PITR was not enabled, what would happen when trying to restore?

A Restoration would fail because no backups exist

B Restoration would create a new table anyway

C Original table would be overwritten

D Restoration would restore to current time

💡 Hint

Refer to step 1 where backups start only after PITR is enabled.

Concept Snapshot

Point-in-time recovery (PITR) in DynamoDB:
- Enable PITR to start continuous backups
- Changes are recorded automatically
- Choose any time within retention to restore
- Restoration creates a new table with data at that time
- Original table remains unchanged during recovery

Full Transcript

Point-in-time recovery (PITR) in DynamoDB allows you to protect your table data by continuously backing up changes. Once enabled, every change to the table is recorded. When you want to recover, you pick a specific time, and DynamoDB creates a new table that reflects the data as it was at that moment. This way, your original table stays safe and unchanged. PITR only works from the time you enable it, so you cannot restore to times before activation. This process helps you fix mistakes or recover lost data easily.