由于达梦启云平台的流式备份只支持对象存储,因此我们另外部署了一台挂载了普通NAS的虚拟机作为备份服务器,用MinIO将NAS封装成了对象存储,以支持启云平台的流式备份。
之前的运维经历中没有用到过这种备份模式,因此分享一些积累的小记。
【备份服务器】
1、停monio服务
[root@dm-monio ~]# docker stop minio
minio
[root@dm-monio ~]# umount /opt/minio/data
umount: /opt/minio/data: 目标忙.
2、杀掉目录下的进程
[root@dm-monio ~]# lsof /opt/minio/data
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
bash 2641111 root cwd DIR 0,58 0 4013369 /opt/minio/data
[root@dm-monio ~]# kill 2641111
3、重新挂载卷
[root@dm-monio ~]# umount /opt/minio/data
[root@dm-monio ~]# mount -o username=${username},password=${password},rw,,,vers=2.0 //${ip}/dmbackup /opt/minio/data
【启云Node1】
1、重新创建所需的桶
[root@node-1 ~]# mc ls dmbk
[root@node-1 ~]# mc mb dmbk/backup-dm1891315925574414336
Bucket created successfully `dmbk/backup-dm1891315925574414336`.
[root@node-1 ~]# mc ls dmbk
[2025-02-28 10:27:42 CST] 0B backup-dm1891315925574414336/
2、在平台发起备份验证桶的有效性
【备份服务器下载备份】
[root@dm-monio ~]# mc cp -r dmbk/backup-dm1838472304550551552/full_20241010133912244 /opt/minio/data/2024/dameng
...244/full_20241010133912244_9.bak: 8.65 GiB / 8.65 GiB ┃▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓┃ 49.81 MiB/s 2m57s
【在单机达梦库上还原】
1、还原整库:
[dmdba@localhost bin]$ ./DmServiceDMBACK stop
Stopping DmServiceDMBACK: [ OK ]
[dmdba@localhost bin]$ ./dmrman
dmrman V8
RMAN> RESTORE DATABASE '/dm8/data/DMBACK/dm.ini' FROM BACKUPSET'/dm8/dumpdir/full_20241010133912244';
RESTORE DATABASE '/dm8/data/DMBACK/dm.ini' FROM BACKUPSET '/dm8/dumpdir/full_20241010133912244';
file dm.key not found, use default license!
[Percent:100.00%][Speed:0.00M/s][Cost:00:01:25][Remaining:00:00:00]
restore successfully.
time used: 00:01:25.589
RMAN> recover DATABASE '/dm8/data/DMBACK/dm.ini' FROM BACKUPSET'/dm8/dumpdir/full_20241010133912244';
recover DATABASE '/dm8/data/DMBACK/dm.ini' FROM BACKUPSET '/dm8/dumpdir/full_20241010133912244';
[Percent:100.00%][Speed:320.75PKG/s][Cost:00:00:07][Remaining:00:00:00]
recover successfully!
time used: 00:00:22.645
RMAN> recover DATABASE '/dm8/data/DMBACK/dm.ini' UPDATE DB_MAGIC;
recover DATABASE '/dm8/data/DMBACK/dm.ini' UPDATE DB_MAGIC;
recover successfully!
time used: 00:00:01.050
RMAN> exit
time used: 0.140(ms)
[dmdba@ctyun-test-coremail-dmdb bin]$ ./DmServiceDMBACK start
Starting DmServiceDMBACK: [ OK ]
2、还原指定表空间:
RESTORE DATABASE '/dm8/data/DMBACK/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm8/dumpdir/DB_DAMENG_FULL_20241011_133829_698474';
RECOVER DATABASE '/dm8/data/DMBACK/dm.ini' TABLESPACE TBS ;
文章
阅读量
获赞