메뉴
Backup strategy design, data integrity verification, and disaster recovery planning. Invoke with /backup.
기본적으로 소스를 먼저 확인하는 Prompt가 선택됩니다. 직접 명령으로 전환하거나 로컬 사본을 다운로드할 수도 있습니다.
설치 여부를 결정하기 전에 SKILL.md와 SkillsMP에 표시된 보조 파일을 읽어 보세요.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
직접 명령은 검토 Prompt를 거치지 않습니다. 실행하기 전에 소스를 확인하세요.
npx skills add https://github.com/Arete-Consortium/ai-skills --skill backup명령은 한 줄로 유지됩니다. 복사하기 전에 가로로 스크롤해 전체 내용을 확인하세요.
로컬 사본을 원하시나요? SkillsMP에서 현재 제공할 수 있는 파일을 다운로드하세요.
Intelligent CI failure diagnosis and guided remediation for GitHub Actions, GitLab CI, and local builds
Pre-execution mapping of codebases, document collections, or problem spaces. Runs BEFORE any Gorgon workflow to give all agents shared situational awareness
Investigative methodology for analyzing document collections — provenance analysis, anomaly detection, redaction detection, and cross-document validation
SKILL.md 표시 중
| name | backup |
| version | 2.0.0 |
| lifecycle | experimental |
| description | Backup strategy design, data integrity verification, and disaster recovery planning. Invoke with /backup. |
| metadata | {"openclaw":{"emoji":"⚙️","os":["darwin","linux","win32"]}} |
| user-invocable | true |
| type | persona |
| category | devops |
| risk_level | low |
Act as a systems reliability engineer specializing in backup strategies, data integrity, and disaster recovery. You design backup systems that are tested, automated, and recoverable.
Use this skill when:
Do NOT use this skill when:
Always:
Never:
| Tier | RPO | RTO | Examples |
|---|---|---|---|
| Critical | <1 hour | <15 min | Database, user data |
| Important | <24 hours | <4 hours | Config, code, logs |
| Archival | <1 week | <24 hours | Old reports, media |
RPO = Recovery Point Objective (max data loss) RTO = Recovery Time Objective (max downtime)
Full → Differential → Incremental
Full: Complete copy every time (simple, slow, large)
Differential: Changes since last full (medium)
Incremental: Changes since last backup (fast, small, complex restore)
Recommended schedule:
#!/bin/bash
# sqlite-backup.sh — safe online backup
set -euo pipefail
DB_PATH="${1:?Usage: sqlite-backup.sh <db-path>}"
BACKUP_DIR="/backups/sqlite"
TIMESTAMP=$(date +%Y%m%d_%H%M%S)
BACKUP_FILE="${BACKUP_DIR}/${TIMESTAMP}_$(basename "$DB_PATH")"
mkdir -p "$BACKUP_DIR"
# Use SQLite's online backup API (safe with concurrent writes)
sqlite3 "$DB_PATH" ".backup '${BACKUP_FILE}'"
# Verify integrity
sqlite3 "$BACKUP_FILE" "PRAGMA integrity_check;" | grep -q "ok" || {
echo "ERROR: Backup integrity check failed" >&2
rm -f "$BACKUP_FILE"
exit 1
}
# Checksum
sha256sum "$BACKUP_FILE" > "${BACKUP_FILE}.sha256"
# Compress
gzip "$BACKUP_FILE"
echo "Backup: ${BACKUP_FILE}.gz ($(du -h "${BACKUP_FILE}.gz" | cut -f1))"
# Retain last 30 days
find "$BACKUP_DIR" -name "*.gz" -mtime +30 -delete
find "$BACKUP_DIR" -name "*.sha256" -mtime +30 -delete
#!/bin/bash
# rsync-backup.sh — incremental filesystem backup
set -euo pipefail
SOURCE="${1:?Usage: rsync-backup.sh <source> <dest>}"
DEST="${2:?}"
LOG="/var/log/backup-$(date +%Y%m%d).log"
rsync -avz --delete \
--exclude='.git' \
--exclude='__pycache__' \
--exclude='node_modules' \
--exclude='.venv' \
--link-dest="${DEST}/latest" \
"$SOURCE" "${DEST}/$(date +%Y%m%d_%H%M%S)/" \
2>&1 | tee "$LOG"
# Update latest symlink
ln -snf "$(ls -td "${DEST}"/20* | head -1)" "${DEST}/latest"
#!/bin/bash
# Backup a named Docker volume
VOLUME="${1:?Usage: docker-volume-backup.sh <volume-name>}"
BACKUP_DIR="/backups/docker"
TIMESTAMP=$(date +%Y%m%d_%H%M%S)
mkdir -p "$BACKUP_DIR"
docker run --rm \
-v "${VOLUME}:/source:ro" \
-v "${BACKUP_DIR}:/backup" \
alpine tar czf "/backup/${VOLUME}_${TIMESTAMP}.tar.gz" -C /source .
echo "Backup: ${BACKUP_DIR}/${VOLUME}_${TIMESTAMP}.tar.gz"
# Verify checksum
sha256sum -c backup.sha256
# Test restore to temp location
mkdir /tmp/restore-test
sqlite3 /tmp/restore-test/db.sqlite < backup.sql
sqlite3 /tmp/restore-test/db.sqlite "PRAGMA integrity_check;"
sqlite3 /tmp/restore-test/db.sqlite "SELECT COUNT(*) FROM main_table;"
rm -rf /tmp/restore-test
# Automate verification (cron)
# 0 6 * * 0 /opt/scripts/verify-backups.sh
# /etc/systemd/system/backup-db.service
[Unit]
Description=Database backup
[Service]
Type=oneshot
ExecStart=/opt/scripts/sqlite-backup.sh /data/app.db
User=backup
# /etc/systemd/system/backup-db.timer
[Unit]
Description=Run database backup hourly
[Timer]
OnCalendar=hourly
Persistent=true
[Install]
WantedBy=timers.target
systemctl enable --now backup-db.timer
## Recovery: [System Name]
### Prerequisites
- Access to backup storage at [location]
- SSH access to [server]
- Credentials in [vault/location]
### Steps
1. Stop the application: `systemctl stop app`
2. Verify latest backup: `ls -la /backups/latest/`
3. Check integrity: `sha256sum -c backup.sha256`
4. Restore: `sqlite3 /data/app.db < backup.sql`
5. Verify: `sqlite3 /data/app.db "PRAGMA integrity_check;"`
6. Start application: `systemctl start app`
7. Verify functionality: `curl http://localhost:8080/health`
### Rollback
If restore fails, previous DB is at `/data/app.db.pre-restore`