DM备份恢复

逻辑备份恢复

dexp、dimp

全库导出

dexp sysdba/dameng123 file=dmfull.dmp log=dmfull.log directory=/dm/dmback full=y

用户导出

dexp xpc/xpc123456 file=xpc.dmp log=xpc.log directory=/dm/dmback owner=xpc

导出表

dexp xpc/xpc123456 file=table-xpc1.dmp log=table-xpc.log directory=/dm/dmback tables=xpc

全库导入

drop table xpc.xpc;
dimp sysdba/dameng123 file=dmfull.dmp log=imp_full.log directory=/dm/dmback full=y
select * from xpc.xpc;

表导入

drop table xpc.xpc;
dimp xpc/xpc123456 file=table-xpc1.dmp log=imp-xpc.log directory=/dm/dmback tables=xpc
select * from xpc.xpc;

物理备份恢复

冷备

数据库处于归档模式

DmServicexpc stop
DmAPService status

cd /dm/dmdbms/dm8/bin
./dmrman
backup database '/dm/dmdata/xpc/dm.ini' backupset '/dm/dmback/xpc_full_01';

冷备恢复

cd /dm/dmdata/xpc
mv *.dbf /home/dmdba/bk

./dmrman
restore database '/dm/dmdata/xpc/dm.ini' from backupset '/dm/dmback/xpc_full_01'
recover database '/dm/dmdata/xpc/dm.ini' from backupset '/dm/dmback/xpc_full_01'
recover database '/dm/dmdata/xpc/dm.ini' update db_magic
exit;
DmServicexpc start
登录查看状态
select name,status$ from v$database;

热备（全备）

disql sysdba/dameng123
backup database full to "xpc_full_02" backupset '/dm/dmback/xpc_full_02';

热备（增量）

backup database increment base on backupset '/dm/dmback/xpc_full_02' to "xpc_incr_02" backupset '/dm/dmback/xpc_full_incr_02';

热备恢复

DmServicexpc stop
DmAPService status
cd /dm/dmdata/xpc
mv *.dbf /home/dmdba/bak

cd /dm/dmdbms/dm8/bin/
./dmrman
restore database '/dm/dmdata/xpc/dm.ini' from backupset '/dm/dmback/xpc_full_02'
restore database '/dm/dmdata/xpc/dm.ini' from backupset '/dm/dmback/xpc_full_incr_02'
recover database '/dm/dmdata/xpc/dm.ini' from backupset '/dm/dmback/xpc_full_02'
recover database '/dm/dmdata/xpc/dm.ini' from backupset '/dm/dmback/xpc_full_incr_02'
recover database '/dm/dmdata/xpc/dm.ini' update db_magic
exit;

DmServicexpc start