DM冷备与恢复方法及问题解决处理
1、windows和linux备份方式
dmrman冷备份方式
./DmServiceDM stop (linux执行)
任务管理器-服务-DmServiceDM停止（windows 执行）
./dmrman(linux执行) dmrman(windows执行)
backup database '/home/dmdba/dmdbms/seeyon/dm.ini' full backupset '/home/dmdba/20211017bak';
./DmServiceDM start （linux） 任务管理器中启动（windows）
2、还原及问题处理
D:dmdbmsbin>dmrman dmrman V8 核对 RMAN> check backupset '/home/dmdba/20211017bak'; check backupset '/home/dmdba/20211017bak'; os_pipe2_conn_server CreateFile failed,, errno:5 CMD END.CODE:[-8109],DESC:[创建dmap管道失败，请检查dmap是否已经启动] [-8109]:创建dmap管道失败，请检查dmap是否已经启动 解决办法： D:dmdbmsbin>dmrman use_ap=2 dmrman V8 RMAN> check backupset '/home/dmdba/20211017bak'; check backupset '/home/dmdba/20211017bak'; CMD END.CODE:[0] check backupset successfully. time used: 259.990(ms)
还原数据库
RMAN> restore database '/home/dmdba/dmdbms/seeyon/dm.ini' from backupset '/home/dmdba/20211017bak'; file dm.key not found, use default license! RESTORE DATAbase CHECK...... RESTORE DATAbase,data collect...... RESTORE DATAbase,database refresh ...... RESTORE BACKUPSET [/home/dmdba/20211017bak] START...... total 192 packages processed... total 196 packages processed... RESTORE DATAbase,UPDATe ctl file...... RESTORE DATAbase,REBUILD key file...... RESTORE DATAbase,CHECK db info...... RESTORE DATAbase,UPDATE db info...... total 196 packages processed... total 196 packages processed! CMD END.CODE:[0] restore successfully. time used: 00:00:23.090
恢复数据
RMAN> recover database '/home/dmdba/dmdbms/seeyon/dm.ini' from backupset '/home/dmdba/20211017bak'; Database mode = 0, oguid = 0 EP[0]'s cur_lsn[126085204] RESTORE RLOG CHECK...... RESTORE RLOG, gen tmp file...... RESTORE RLOG FROM BACKUPSET [/home/dmdba/20211017bak] START...... total 2 packages processed... total 2 packages processed... total 2 packages processed! CMD END.CODE:[0] EP:0 total 2 pkgs applied, percent: 15% EP:0 total 4 pkgs applied, percent: 30% EP:0 total 6 pkgs applied, percent: 46% EP:0 total 8 pkgs applied, percent: 61% EP:0 total 10 pkgs applied, percent: 76% EP:0 total 12 pkgs applied, percent: 92% EP:0 total 13 pkgs applied, percent: 100% Recover from archive log finished, time used:0.016s. recover successfully! time used: 483.527(ms)
更新
RMAN> recover database '/home/dmdba/dmdbms/seeyon/dm.ini' update db_magic; Database mode = 0, oguid = 0 EP[0]'s cur_lsn[126085363] EP[0]'s apply_lsn[126085363] >= end_lsn[126085363] recover successfully! time used: 00:00:01.133
执行操作完成后数据库无法启动提示:
ERROR] database P0000002640 T0000000000000018192 Please use the correct version of server or set the CHECK_SVR_VERSION=0 in dm.ini [FATAL] database P0000002640 T0000000000000018192 alter database open; nsvr_check_version failed [FATAL] database P0000002640 T0000000000000018192 code = -109, dm_sys_halt now!!!
修改配置文件
vi /home/dmdba/dmdbms/data/DAMENG/dm.ini CHECK_SVR_VERSION = 0 #Whether to check server version
启动成功
