disql联机备份
--数据库备份
--mount模式下不允许数据库备份
--完全备份
SQL> BACKUP DATABASE FULL BACKUPSET '/opt/dmdbms/dm_bak/db_full_bak_01';
--增量备份
SQL> BACKUP DATABASE INCREMENT WITH BACKUPDIR '/opt/dmdbms/dm_bak' BACKUPSET '/opt/dmdbms/dm_bak/db_incre_bak_01';
DMrman脱机备份还原
--数据库备份
--数据库处于脱机状态
数据库停服务后,保证dmap服务正常运行
./dmrman
--完全备份
RMAN>BACKUP DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FULL BACKUPSET '/opt/dmdbms/dm_bak/db_full_bak_02';
--增量备份
RMAN>BACKUP DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' INCREMENT WITH BACKUPDIR '/opt/dmdbms/dm_bak ' BACKUPSET '/opt/dmdbms/dm_bak/db_incre_bak_02';
数据库还原
-校验待还原备份集的合法性(如果确定合法该步可省略)
RMAN>CHECK BACKUPSET '/opt/dmdbms/dm_bak/db_full_bak_01';
RMAN>RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/dm_bak/db_full_bak_01';
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/dm_bak/db_full_bak_01';
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC;
附:请反复确认指定的dm.ini路径是否是你要还原的库!!!