库备份:
backup database full backupset ‘DB_DAMENG_FULL’;
表结构备份:
backup database full ddl_clone backupset ‘DB_DAMENG_FULL’;
表备份:
backup table “SYSDBA”.“TEST” backupset ‘/home/dm_bak/tab_bak’;
表还原:
drman>restore table struct from backupset ‘/home/dm_bak/tab_bak’; //只还原表结构
drman>RESTORE TABLE WITHOUT INDEX FROM BACKUPSET ‘/home/dm_bak/tab_bak’; //不包括重建索引
drman>RESTORE table WITHOUT CONSTRAINT FROM BACKUPSET ‘/home/dm_bak/tab_bak’; //不包括约束
表空间备份:
backup tablespace “SYSTEM” full backupset ‘TS_SYSTEM_FULL’;
归档备份:
backup archivelog all backupset 'ARCH_FULL;
归档可以指定时间段备份
backup archivelog time between ‘2020-12-09 11:10:28’ and ‘2020-12-09 11:10:28’ backupset ‘ARCH_FULL’;
用drman还原数据库
停库:./dmserver stop
恢复: ./dmrman CTLSTMT=“RESTORE DATABASE ‘/dm/data/DAMENG/dm.ini’ FROM BACKUPSET ‘/dm/data/BACKUP_FILE’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dm/data/DAMENG/dm.ini’ FROM
BACKUPSET ‘/dm/data/BACKUP_FILE’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dm/data/DAMENG/dm.ini’ UPDATE DB_MAGIC”