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 数据库关闭

[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 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

$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