1、BACKUP DATABASE '/dm/dmdata/DAMENG/dm.ini' FULL BACKUPSET '/dm/dmdata/DAMENG/bak/db_full_bak_01' compressed level 1;
CHECK BACKUPSET '/dm/dmdata/DAMENG/bak/db_full_bak_01';
2、生成映射文件
DUMP BACKUPSET'/dm/dmdata/DAMENG/bak/db_full_bak_01' DATABASE '/dm/dmdata/DAMENG/dm.ini' MAPPED FILE'/dm/dmdata/DAMENG/map_file_01.txt';
3、修改映射文件
vi /dm/dmdata/DAMENG/map_file_01.txt
4、恢复数据库
RESTORE DATABASE '/dm/dmdata/DAMENG/dm.ini' FROM BACKUPSET '/dm/dmdata/DAMENG/bak/db_full_bak_01' MAPPED FILE '/dm/dmdata/DAMENG/map_file_01.txt';
RECOVER DATABASE '/dm/dmdata/DAMENG/dm.ini' FROM BACKUPSET '/dm/dmdata/DAMENG/bak/db_full_bak_01';
RECOVER DATABASE '/dm/dmdata/DAMENG/dm.ini' UPDATE DB_MAGIC;
文章
阅读量
获赞