1.逻辑备份恢复

#全库导出
dexp sysdba/dameng123 file=dmfull.dmp log=dmfull.log directory=/dm/dmback full=y
#用户导出
dexp admin/admin1234 file=admin.dmp log=admin.log directory=/dm/dmback owner=admin
#表导出
dexp admin/admin1234 file=admin-fgedu.dmp log=admin-fgedu.log directory=/dm/dmback tables=fgedu
#导入
dimp sysdba/dameng123 file=dmfull.dmp log=imp_full.log directory=/dm/dmback full=y
dimp admin/admin1234 file=admin-fgedu.dmp log=imp-fgedu.log directory=/dm/dmback tables=fgedu

2.物理备份恢复

(1).无论冷备份还是热备份,我们的DmAPService 服务是必须开启的（数据库辅助插件服务）
$ DmAPService status
DmAPService (pid 24298) is running.
(2).热备
disql sysdba/dameng123
backup database full to "admin_full" backupset '/dm/dmback/admin_full_01';
增量
backup database increment base on backupset'/dm/dmback/admin_full_01' to \
"admin_incr_01" backupset '/dm/dmback/admin_full_incr_01';
(3).恢复
DmServicedm1db stop
cd /dm/dmdbms/dm8/bin/
./dmrman
restore database '/dm/dmdata/dm1db/dm.ini' from backupset '/dm/dmback/admin_full_01'
recover database '/dm/dmdata/dm1db/dm.ini' from backupset '/dm/dmback/admin_full_01'
restore database '/dm/dmdata/dm1db/dm.ini' from backupset '/dm/dmback/admin_full_incr_01'
recover database '/dm/dmdata/dm1db/dm.ini' from backupset '/dm/dmback/admin_full_incr_01'
recover database '/dm/dmdata/dm1db/dm.ini' with archivedir '/dm/arch';
recover database '/dm/dmdata/dm1db/dm.ini' with archivedir '/dm/arch' until time '2024-06-01 14:30:00';
recover database '/dm/dmdata/dm1db/dm.ini' update db_magic#丢失数据 慎用。
(4).查看备份集
RMAN> show backupset '/dm/dmback/admin_full_01';
RMAN> check backupset '/dm/dmback/admin_full_01';