DM7数据库备份与还原
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
DM7数据库备份与还原
1数据库备份
1.1新建备份
使用”DM管理工具”登陆到DM管理界面，打开”备份” ”库备份”，右击鼠标选择”新建备份”
1.2实行备份
1.3备份中
1.4备份完成
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!
<backup DAMENG_BAK_2014_11_11_10_17_33 info>
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 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
<bak_file_list>
$file_seq |$file_path |$size(KB) 1 |/root/721/sjk-2014-11-11.bak |1425408
<db_file_list>
$file_seq |$file_path |$mirror_path
1 |D:\721\dmdbms\data\DAMENG\SYSTEM.DBF|
2 |D:\721\dmdbms\data\DAMENG\ROLL.DBF|
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 ]。