DM7数据库备份与还原
1 数据库备份
1.1 新建备份
使用”DM管理工具”登陆到DM管理界面，打开”备份”?”库备份”，右击鼠标选择”新建备份”
1 / 6
1.2 实行备份
2 / 6
1.3 备份中
1.4 备份完成
3 / 6
2 数据库还原
2.1 删除旧数据
使用”DM管理工具”登陆到DM管理界面，打开”SYSDBA”?”表”，选中所有表（除##HISTOGRAMS_TABLE、##PLAN_TABLE以外），在选中区域右击鼠标，选择”删除”。
2.2 数据库关闭
[root@localhost bin]# cd /etc/rc.d/init.d/
[root@localhost init.d]# ./DmServiceDMSERVER stop Stopping DmServiceDMSERVER: [ OK ]
2.3 数据库还原
[root@localhost init.d]# cd /opt/dmdbms/bin [root@localhost bin]# ./dmrestore INI_PATH=/opt/dmdbms/data/DAMENG/dm.ini file=/root/721/sjk-2014-11-11.bak
restore V7.1.3.142-Build(2014.09.10-48344trunc) file dm.key not found, use default license!
Global parameter value of RS_BDTA_BUF_SIZE is illegal, use max value!
4 / 6
backup db name: DAMENG backup db magic: 1414999730
backup name: DAMENG_BAK_2014_11_11_10_17_33 backup type: full backup level: online backup range: database backup description: compressed level: 0 encrypt_type: 0 encrypt_id: 2052 rac node: 0 page check: 0 rlog encrypt: 0 length in char: 0 use new hash: 1
backup time: 2014-11-11 10:18:11 page size: 32 KB extent size: 32 case sensitive: 1 log page size: 512 B unicode flag: 0
data version: 0x70009
sys version: V7.1.3.146-Build(2014.09.16-48620trunc) enable policy: 0
mpp_timestamp: 1415672290 parallel type: 0 parallel info len: 0 backup db fil num: 5 archive flag: 1 backup with log: Yes
before backup LSN: 1962258 after backup LSN: 1962258
$file_seq |$file_path 1 |/root/721/sjk-2014-11-11.bak
$file_seq |$file_path |$mirror_path 1 |D:\\721\\dmdbms\\data\\DAMENG\\SYSTEM.DBF| 2 |D:\\721\\dmdbms\\data\\DAMENG\\ROLL.DBF| 5 / 6
|1425408 |$size(KB)
3 |D:\\721\\dmdbms\\data\\DAMENG\\MAIN.DBF| 4 |D:\\721\\dmdbms\\data\\DAMENG\\SYSAWR.DBF|
Continue?[Y/N]:Y
Warning: Backup file may has been modified !
Continue?[Y/N]:y
restore bak_file: /root/721/sjk-2014-11-11.bak ... start restore database...
start restore file: /opt/dmdbms/data/DAMENG/SYSTEM.DBF(SYSTEM), pages: 309 end restore file: /opt/dmdbms/data/DAMENG/SYSTEM.DBF(SYSTEM)
start restore file: /opt/dmdbms/data/DAMENG/ROLL.DBF(ROLL), pages: 2596 end restore file: /opt/dmdbms/data/DAMENG/ROLL.DBF(ROLL)
start restore file: /opt/dmdbms/data/DAMENG/MAIN.DBF(MAIN), pages: 41106 end restore file: /opt/dmdbms/data/DAMENG/MAIN.DBF(MAIN)
start restore file: /opt/dmdbms/data/DAMENG/SYSAWR.DBF(SYSAUX), pages: 46 end restore file: /opt/dmdbms/data/DAMENG/SYSAWR.DBF(SYSAUX) end restore database data files.
restore finished, code = 0!
restore successfully!
restore time used: 40419.866(ms)
2.4 数据库启动
[root@localhost bin]# cd /etc/rc.d/init.d/
[root@localhost init.d]# ./DmServiceDMSERVER start Starting DmServiceDMSERVER: [ OK ]
6 / 6