DatabaseCritical Severity
Verifikasi Backup Database Harian
Prosedur pengecekan backup database harian — pastikan backup terbaru tersedia, tidak corrupt, dan bisa di-restore.
Estimasi: 10 menit
6 Langkah
Automatable## Prosedur: Verifikasi Backup Database Harian
### Langkah-langkah
**Step 1: Cek backup file exists**
```bash
ls -la /backups/db/$(date +%Y-%m-%d)*
```
**Step 2: Verifikasi file size**
Expected: > 100MB (jika < 10MB, kemungkinan backup gagal)
**Step 3: Checksum verification**
```bash
sha256sum /backups/db/latest.sql.gz
```
**Step 4: Test restore di staging**
```bash
pg_restore --dbname=test_db /backups/db/latest.sql.gz
```
**Step 5: Verify data integrity**
```sql
SELECT count(*) FROM users;
SELECT count(*) FROM sessions;
```
**Step 6: Report hasil**
Catat hasil verifikasi di log monitoring.
Runbook Ini Dapat Diotomatisasi
Hubungi support untuk mengimplementasikan automasi ini