为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:./dmrman
BACKUP DATABASE '/home/dmdba/dmdbms/data/DAMENG/dm.ini' FULL BACKUPSET '/home/dmdba/bak/0328'; 备份大概600G的数据量 如何将备份出来的数据占比最小
在备份语句中加上 compress level 参数
BACKUP DATABASE '/home/dmdba/dmdbms/data/DAMENG/dm.ini' FULL BACKUPSET '/home/dmdba/bak/0328' compressed level 5 parallel 4
1、使用高级压缩选项
./dmrman
BACKUP DATABASE '/home/dmdba/dmdbms/data/DAMENG/dm.ini'
FULL COMPRESSED
BACKUPSET '/home/dmdba/bak/0328'
compressed level 5 parallel 4; # 压缩级别1-9,建议5-7平衡性能与压缩率
600G数据可压缩至180-240G(压缩率约30-40%)
2、增量备份,减少备份量
# 首次全量备份
BACKUP DATABASE '/path/to/dm.ini' FULL BACKUPSET '/bak/full_20250401';
# 后续增量备份
BACKUP DATABASE '/path/to/dm.ini'
INCREMENT WITH BACKUPDIR '/bak/full_20250401'
BACKUPSET '/bak/incr_20250402';
加上 compressed level 2就行,数据中如果存在大字段,非结构化数据,压缩不会有太明显的区别
/dmdbms/bin/dmrman CTLSTMT="BACKUP DATABASE '/dmdata/DAMENG/dm.ini' FULL BACKUPSET '/dmdata/DAMENG/bak/BACKUP_FILE' compressed level 2 parallel 4"