停掉数据库:
./DmServiceDMTEST stop
确保dmap正在运行:
ps -ef|grep dmap
执行dmrman冷备:
./dmrman CTLSTMT="backup database '/dm8/dmdata/DMTEST/dm.ini' backupset '/dm8/backup/full/fullback_0619' COMPRESSED level 1 task thread 4 parallel 2";
查看备份集信息
./dmrman
show backupset '/dm8/backup/full/fullback_0619' info meta
备份目录需为新目录:
备份成功:
查看备份信息:
./dmrman
show backupset '/dm8/backup/full/fullbak0619_4' info meta;
查看数据库进程和dmap进程:
查看备份信息:
./dmrman
show backupset '/dm8/backup/full/fullback_0619_4';
./dmrman CTLSTMT="restore database '/dm8/dmdata/DMTEST/dm.ini' from backupset '/dm8/backup/full/fullback_0619'";
./dmrman CTLSTMT="recover database '/dm8/dmdata/DMTEST/dm.ini' from backupset '/dm8/backup/full/fullback_0619'";
./dmrman CTLSTMT="recover database '/dm8/dmdata/DMTEST/dm.ini' update db_magic";
查看数据库db_magic:
点击restore:
选择备份集及配置文件路径后点击ok
进行recover:
更新magic:
查看还原后的数据库db_magic:
文章
阅读量
获赞