Huaiyao Jin

Huaiyao Jin

数据备份再检查 + 新的冷备

作为一名 DBA,深知备份的重要性,以及备份可用性的检查的重要性。

今天来检查一下设置好的备份策略有没有被正常地执行。

对照着我的个人数据分级与备份体系 - 2025

照片和视频

mac mini 上 Time machine 里的备份

远程到家里的 mac mini,可以看到最新的时间戳。

家用服务器上的 MT-Photos

jinhuaiyao@jinhuaiyao-t7820:/media/jinhuaiyao/data2/HYPhoto$ find . -mtime -1 -exec ls -ltr {} +  |tail
-rw-rw-rw- 1 root root   3123224 Mar 21 07:16 G4 Instant - 3-21-2026, 7.16.24am.jpg
-rw-rw-rw- 1 root root   1598933 Mar 21 08:39 IMG_5361.HEIC
-rw-rw-rw- 1 root root    440308 Mar 21 08:54 IMG_1866.JPG
-rw-rw-rw- 1 root root   1380533 Mar 21 09:39 IMG_5363.HEIC
-rw-rw-rw- 1 root root   3060951 Mar 21 09:39 IMG_5364.HEIC
-rw-rw-rw- 1 root root   1388246 Mar 21 09:39 IMG_5367.HEIC
-rw-rw-rw- 1 root root   3340990 Mar 21 10:02 G4 Instant - 3-21-2026, 10.02.52am.jpg
-rw-rw-rw- 1 root root   2190676 Mar 21 10:15 IMG_1877.PNG
-rw-rw-rw- 1 root root       435 Mar 21 11:18 IMG_1706.MOV.xmp
-rw-rw-rw- 1 root root       435 Mar 21 11:19 IMG_1807.MOV.xmp

可以看到最新的文件。

MT-Photos 的备份

jinhuaiyao@jinhuaiyao-t7820:/media/jinhuaiyao/data2/HYPhoto$ crontab -l
10 4 * * * cd /media/jinhuaiyao/data1/nextcloud/admin/files  && sudo rsync -avh  * /media/jinhuaiyao/backup/Nextcloud
30 4 * * * cd /media/jinhuaiyao/data1/nextcloud/admin/files  && sudo rsync -avh  * /media/jinhuaiyao/data2/Nextcloud
20 4 * * * cd /media/jinhuaiyao/data2 && rsync -avh  HYPhoto /media/jinhuaiyao/backup


jinhuaiyao@jinhuaiyao-t7820:/media/jinhuaiyao/backup/HYPhoto$  find . -mtime -1 -exec ls -ltr {} +  |tail
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao    251581 Mar 19 09:03 IMG_1802.JPG
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao    251581 Mar 19 09:03 IMG_1802_2.JPG
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao    251581 Mar 19 09:03 IMG_1802_1.JPG
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao   2655260 Mar 19 12:01 IMG_1806.HEIC
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao   2655260 Mar 19 12:01 IMG_1806_1.HEIC
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao   2158177 Mar 19 12:07 IMG_1807.HEIC
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao   3837559 Mar 19 12:07 IMG_1807_2.MOV
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao   2158177 Mar 19 12:07 IMG_1807_2.HEIC
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao   2158177 Mar 19 12:07 IMG_1807_1.HEIC
-rw-rw-rw- 1 jinhuaiyao jinhuaiyao       435 Mar 20 17:30 IMG_1807_2.MOV.xmp

这里最新的文件是 3 月 19 号的,是因为过去两天没有手动打开手机上的 MT-Photos app,刚刚备份了增量数据就没问题了。

文档资料

Nextcloud 里的备份文件夹

看一下文件夹的时间戳,没问题。

服务器上 Nextcloud 的备份


jinhuaiyao@jinhuaiyao-t7820:/media/jinhuaiyao/data2$ crontab -l
10 4 * * * cd /media/jinhuaiyao/data1/nextcloud/admin/files  && sudo rsync -avh  * /media/jinhuaiyao/backup/Nextcloud
30 4 * * * cd /media/jinhuaiyao/data1/nextcloud/admin/files  && sudo rsync -avh  * /media/jinhuaiyao/data2/Nextcloud
20 4 * * * cd /media/jinhuaiyao/data2 && rsync -avh  HYPhoto /media/jinhuaiyao/backup

jinhuaiyao@jinhuaiyao-t7820:~$ cd /media/jinhuaiyao/data1/nextcloud/admin/files  && sudo rsync -avh  * /media/jinhuaiyao/backup/Nextcloud
sending incremental file list

sent 4.89M bytes  received 10.15K bytes  1.96M bytes/sec
total size is 1.61T  speedup is 328,716.98
jinhuaiyao@jinhuaiyao-t7820:/media/jinhuaiyao/data1/nextcloud/admin/files$ cd /media/jinhuaiyao/data1/nextcloud/admin/files  && sudo rsync -avh  * /media/jinhuaiyao/data2/Nextcloud
sending incremental file list

sent 4.89M bytes  received 10.14K bytes  1.96M bytes/sec
total size is 1.61T  speedup is 328,717.52

没有新的文件,说明都正常 rsync 复制了。

两周前新增加了放置于 Google Drive 的冷备

订阅了 Google AI Pro,有 2T 的 Google Drive 空间,利用一下。

export GPG_TTY=$(tty)

cd /Users/jinhuaiyao/Nextcloud/

tar -czf - Personal | gpg -c --cipher-algo AES256 | split -b 10G - /Users/jinhuaiyao/Downloads/Nextcloud.Personal.tar.gz.gpg.

tar -czf - Config Learning Reading | gpg -c --cipher-algo AES256 | split -b 10G - /Users/jinhuaiyao/Downloads/Nextcloud.Others.tar.gz.gpg.

把最重要的 4 个文件夹打包后用 gpg 加密,然后分割成 10G 一个的文件,上传到 Google Drive,作为冷备,增加一份保障。

就这样。