1、安装达梦数据库；
2、开启归档
alter database archivelog;

alter database add archivelog ‘DEST=/home/dmdba/dmdata5236_arch, TYPE=LOCAL, FILE_SIZE=128, SPACE_LIMIT=1024’;

3、备份
backup database full to “DB_DAMENG_FULL_2022_02_18_13_33_20” backupset ‘DB_DAMENG_FULL_2022_02_18_13_33_20’;

4、创建表
CREATE TABLE “DM”.“DM_TEST”
(
“A1” VARCHAR(50),
“A2” VARCHAR(50),
“A3” TIMESTAMP(6) DEFAULT SYSDATE()) STORAGE(ON “TBS_DM”, CLUSTERBTR) ;

5、测试数据

INSERT INTO DM.DM_TEST(A1,A2)VALUES(‘A1’,‘A2’);

6、还原达梦数据库，使用归档还原到指定时间；
6.1备份还原.
./dmrman CTLSTMT=“RESTORE DATABASE ‘/home/dmdba/dmdata5237/DAMENG/dm.ini’ FROM BACKUPSET ‘/home/dmdba/dmdata5236/DAMENG/bak/DB_DAMENG_FULL_2022_02_18_14_08_47’”

6.2–通过归档恢复到指定时间(受归档刷盘时间影响)

./dmrman
recover database ‘/home/dmdba/dmdata5237/DAMENG/dm.ini’ with archivedir ‘/home/dmdba/dmdata5236_arch’ until time ‘2022-02-18 14:42:44’

6.3、–更新数据库db_magic
./dmrman
recover database ‘/home/dmdba/dmdata5237/DAMENG/dm.ini’ update db_magic;