DM7数据库备份与还原

1、dm7数据库备份与还原 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 数据库关闭 rootlocalhost bin# cd /etc/rc.d/init.d/ rootloca

2、lhost init.d# ./dmservicedmserver stop stopping dmservicedmserver: ok 2.3 数据库还原 rootlocalhost init.d# cd /opt/dmdbms/bin rootlocalhost 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

3、 default license! global parameter value of rs_bdta_buf_size is illegal, use max value! 4 / 6 backup sig: ba backup tool version: 12595 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

4、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

5、.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

6、_path |$mirror_path 1 |d:721dmdbmsdatadamengsystem.dbf| 2 |d:721dmdbmsdatadamengroll.dbf| 5 / 6 |1425408 |$size(kb) 3 |d:721dmdbmsdatadamengmain.dbf| 4 |d:721dmdbmsdatadamengsysawr.dbf| continue?y/n:y warning: backup file may has been modified ! continue?y/n:y restore bak_file: /root/721/sjk-2014-11

7、-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) s

8、tart 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