DM查询查db_magic、增量备份恢复示例

最新推荐文章于 2023-07-06 17:17:17 发布

峰言吾

最新推荐文章于 2023-07-06 17:17:17 发布

阅读量314

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/iiiief/article/details/129265725

版权

库离线情况下，查db_magic技巧

#查归档连续性
./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'

增量备份还原测试

环境准备

su - dmdba
cd /home/dmdba/dmdbms/bin
#初始化命令，其参数设置为国网常用参数，初始化前保证目录权限正常，且没有DAMENG目录。
./dminit PATH=/dbdata/dmdata extent_size=16 page_size=32 case_sensitive=y
#前台启动命令，出现SYSTEM IS READY表示启动成功，然后Ctrl + c 关闭即可
./dmserver /dbdata/dmdata/DAMENG/dm.ini ```

alter database mount;
alter database add archivelog 'type=local,dest=/dbarch/dmarch,file_size=128,space_limit=20000';
alter database archivelog;
alter database open;

备份

BACKUP DATABASE BACKUPSET '/dbbak/dmbak/db_full';
BACKUP DATABASE INCREMENT WITH BACKUPDIR '/dbbak/dmbak/' BACKUPSET
'/dbbak/dmbak/db_increment_bak_05';
BACKUP DATABASE INCREMENT WITH BACKUPDIR '/dbbak/dmbak/' BACKUPSET
'/dbbak/dmbak/db_increment_bak_06';

增量还原恢复

restore database '/dbdata/dmdata/DAMENG/dm.ini' from backupset
'/dbbak/dmbak/db_increment_bak_06' WITH BACKUPDIR '/dbbak/dmbak/';
recover database '/dbdata/dmdata/DAMENG/dm.ini' from backupset
'/dbbak/dmbak/db_increment_bak_06';
recover database '/dbdata/dmdata/DAMENG/dm.ini' update db_magic;
#3、从归档恢复，依照参数酌情修改
restore database '/dbdata/dmdata/DAMENG/dm.ini' from backupset
'/dbbak/dmbak/db_full';
recover database '/dbdata/dmdata/DAMENG/dm.ini' from backupset
'/dbbak/dmbak/db_full';
RECOVER DATABASE '/dbdata/dmdata/DAMENG/dm.ini' WITH ARCHIVEDIR '/dbarch/dmarch'
use db_magic 104821606 UNTIL TIME '2021-09-16 10:56:40';
#恢复时通常需要指定db_magic，这个值用于区分不同库的文件，即使是同一个库，经历还原恢复后变更了
db_magic,它旧的那些归档日志也是不能直接用的。所以需要use db_magic 方式指定，如果需要恢复到最
新时间点，UNTIL TIME不写即可。