–联机备份
–一、表空间备份与表空间还原
–1、表空间进行完全备份
backup tablespace main full backupset ‘/dm/dmbak/ts_full_bak_01’;
–2、增量备份表空间
backup tablespace main increment with backupdir ‘/dm/dmbak’ backupset ‘/dm/dmbak/ts_increment_bak_02’;

–表空间还原
–1、对MAIN表空间进行恢复
restore database ‘/dm/dmdbms/bin/dm.ini’ tablespace main from backupset ‘/dm/dmbak/ts_full_bak_02’;
–2、对MAIN表空间进行还原
recover database ‘/dm/dmdbms/bin/dm.ini’ tablespace main;

–二、表备份与还原
–1、备份表
backup table dmhr.city backupset ‘/dm/dmbak/tab_bak_01’;
–2、重构表，可以删除冗余
restore table dmhr.city struct from backupset ‘/dm/dmbak/tab_bak_01’;
–3、还原表
restore table dmhr.city from backupset ‘/dm/dmbak/tab_bak_01’;
–4、还原数据不重建索引（默认会重建索引）
restore table dmhr.city struct from backupset ‘/dm/dmbak/tab_bak_01’;
restore table dmhr.city without index from backupset ‘/dm/dmbak/tab_bak_01’;
–5、还原数据不重建约束（默认会重建约束）
restore table dmhr.city struct from backupset ‘/dm/dmbak/tab_bak_01’;
restore table dmhr.city without constraint from backupset ‘/dm/dmbak/tab_bak_01’;