逻辑备份恢复

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