DM数据库相关知识(待补充)

1. 使用达梦数据库备份表并还原步骤

首先要开启联机归档模式:

ALTER DATABASE MOUNT;
ALTER DATABASE ADD ARCHIVELOG 'DEST = /dm8/data/arch, TYPE = local, FILE_SIZE = 1024, SPACE_LIMIT = 2048'
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
checkpoint(100);
backup database full backupset '/dm8/backup/full01';
#关闭dm服务 切换到dmrman命令行工具
restore database '/opt/dmdbms/data/DAMENG/dm.ini' from backupset '/dm8/backup/full01';
# 将数据恢复到 2022-10-18 17:21:29
RECOVER  database '/opt/dmdbms/data/DAMENG/dm.ini' WITH ARCHIVEDIR '/dm8/data/arch' UNTIL TIME'2022-10-18 17:21:29';
# 修改模数值
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC;