【DM版本】:DM8
【操作系统】：linux
【CPU】:
【问题描述】*：还原语句使用了 without还是无法还原
restore table "A"."A" without index without constraint from backupset 'E:\DB\DM\data\DAMENGA\bak\TAB_A_A_2023_04_25_18_28_02' device type disk;
回答 0
暂无回答
Dora
测试用例是恢复至新表中，新表不存在索引可以恢复成功
原表恢复使用以下语句
restore table struct without index with constraint from backupset 'd:\dmdbms\data_GBK\DAMENG\bak\TAB_SYSDBA_TAB_FOR_IDX_01_2023_04_24_17_51_16' device type disk;
restore table without index with constraint from backupset 'd:\dmdbms\data_GBK\DAMENG\bak\TAB_SYSDBA_TAB_FOR_IDX_01_2023_04_24_17_51_16' device type disk;
管理工具表备份有相关ddl语句可以参考
测试用例是恢复至新表中，新表不存在索引可以恢复成功
原表恢复使用以下语句
restore table struct without index with constraint from backupset 'd:\dmdbms\data_GBK\DAMENG\bak\TAB_SYSDBA_TAB_FOR_IDX_01_2023_04_24_17_51_16' device type disk;
restore table without index with constraint from backupset 'd:\dmdbms\data_GBK\DAMENG\bak\TAB_SYSDBA_TAB_FOR_IDX_01_2023_04_24_17_51_16' device type disk;
管理工具表备份有相关ddl语句可以参考