DM7数据库的增量备份与还原

DM7数据库的增量备份与还原

增量备份示例语句(类似SQL命令在线执行)

BACKUP DATABASE  BACKUPSET '/dbbak/dmbak/db_full';
BACKUP DATABASE  INCREMENT WITH BACKUPDIR '/dbbak/dmbak/'  BACKUPSET '/dbbak/dmbak/db_increment_bak_01';
BACKUP DATABASE  INCREMENT WITH BACKUPDIR '/dbbak/dmbak/'  BACKUPSET '/dbbak/dmbak/db_increment_bak_02';
--WITH BACKUPDIR：用于增量备份中，指定基备份的搜索目录
--BASE ON BACKUPSET：用于增量备份中，为增量备份指定基备份集路径
--BACKUP DATABASE  INCREMENT BASE ON BACKUPSET '/dbbak/dmbak/db_full'  BACKUPSET '/dbbak/dmbak/db_increment_bak_03';

还原恢复示例语句(使用$DM_HOME/bin/下的dmrman工具)

restore database '/dbdata/dmdata/DAMENG/dm.ini' from backupset '/dbbak/dmbak/db_increment_bak_02' WITH BACKUPDIR '/dbbak/dmbak/';
recover database '/dbdata/dmdata/DAMENG/dm.ini' from backupset '/dbbak/dmbak/db_increment_bak_02';
recover database '/dbdata/dmdata/DAMENG/dm.ini' update db_magic;

使用归档日志还原与恢复(使用$DM_HOME/bin/下的dmrman工具)

--首先需要一次有效的全备把数据还原好
restore database '/dbdata/dmdata/DAMENG/dm.ini' from backupset '/dbbak/dmbak/db_full';
--重做备份中的redo日志
recover database '/dbdata/dmdata/DAMENG/dm.ini' from backupset '/dbbak/dmbak/db_full';
--指定归档日志文件存放的目录、db_magic等参数，进行归档日志的重做
RECOVER DATABASE '/dbdata/dmdata/DAMENG/dm.ini' WITH ARCHIVEDIR '/dbarch/dmarch' use db_magic 104821606;
--
--
--
--
--查归档连续性
./dmrachk arch_path=/dbarch/dmarch

--查db_magic，从单个归档文件中查
./dmrachk arch_fil=/dbarch/dmarch/ARCHIVE_LOCAL1_2019061208085947282.log

--#查db_magic,从库产生的备份中查
./dmrman 
SHOW BACKUPSET '/dbbak/dmbak/db_full'
--如需了解细节，建立阅读DM官方备份还原手册