DMRMAN备份常见问题
1、DMRMAN备份相当于脱机备份,需要关闭dmserver服务
1.1 dmserver服务未关闭会显示:服务器正在运行或者存在其他进程正在操作同一个库
RMAN> RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/all/db_all_bak';
RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/all/db_all_bak';
file dm.key not found, use default license!
[-137]:服务器正在运行或者存在其他进程正在操作同一个库
1.2备份时出现故障“连接失败”是怎么回事,应该如何解决?遇到这种问题时的场景,一般是安装时在完成安装之前没有注册dmap服务,这样的情况下需要去注册并启动dmap服务;也有可能是dmap服务被意外关闭,这种情况下启动dmap服务即可。
RMAN> BACKUP DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FULL BACKUPSET '/opt/dmdbms/backup/db_all_bak';
BACKUP DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FULL BACKUPSET '/opt/dmdbms/backup/db_all_bak';
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[37403]
Processing backupset /opt/dmdbms/backup/db_all_bak
[Percent:0.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
[-7170]:bakres连接DMAP失败
1.2.1 bin目录下./dmap起前台启动
前台启动dmap,在安装路径下的bin目录下,用./dmap
即可启动dmap服务,但在前台启动的方式下,关闭启动的当前窗口,dmap即会被关闭。
1.2.2 注册服务
通过脚本注册dmap服务,用服务方式启动
利用脚本进行dmap服务注册并启动,在完整的软件安装过程中,在完成安装前原本应该以root身份运行脚本来注册启动dmap。脚本在dmdbms/script/root目录下。
/opt/dmdbms/script/root/root_installer.sh
cd /opt/dmdbms/bin/
./DmAPSservice start
全库备份
RMAN>BACKUP DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FULL BACKUPSET '/opt/dmdbms/backup/db_all_bak';
还原
RMAN> RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/backup/db_all_bakk';
RMAN> RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/backup/db_all_bak';
RMAN> RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC;