达梦数据库全备报错[-718]处理方法

转载已于 2022-05-25 19:25:43 修改 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://mp.weixin.qq.com/s/OC8efSbx_EBHa6NEfPHmIA

文章标签：

#操作系统 #虚拟机 #dba

于 2022-03-29 13:15:30 首次发布

达梦数据库专栏收录该内容

6 篇文章

订阅专栏

本文介绍了解决达梦数据库全备过程中出现的两种常见错误：archivelogcollectednotconsecutive 和 DMserverisrunningorexistotherprocesswhichisoperatingthesamedatabase。通过关闭数据库服务并使用 RMAN 命令进行归档日志修复。

文章目录

- 全备报错
- 处理办法

学习过程参考了：参考文章，这篇文章

全备报错

[-718]: archive log collected not consecutive (需要恢复归档)
[-137]:DM server is running or exist other process which is operating the same database（需要关闭数据库服务）

备份报错

处理办法

--报错信息archive log collected not consecutive
RMAN> backup database '/home/dmdba/dmdata/DAMENG/dm.ini' full backupset '/dmbak/db_full_bak_01';
file dm.key not found, use default license!
[-137]:DM server is running or exist other process which is operating the same database
--修复数据库归档日志
RMAN> repair archivelog database '/home/dmdba/dmdata/DAMENG/dm.ini' ;
repair archive log failed.error code: -137
[-137]:DM server is running or exist other process which is operating the same database
--关闭服务才可以使用dmrman
[dmdba@dmdb03 DAMENG]$ pwd
/home/dmdba/dmdata/DAMENG
[dmdba@dmdb03 DAMENG]$ cd /home/dmdba/dmdbms/bin
[dmdba@dmdb03 bin]$ ./DmServiceDMSERVER stop
Stopping DmServiceDMSERVER:                                [ OK ]
--修复成功
RMAN> repair archivelog database '/home/dmdba/dmdata/DAMENG/dm.ini' ;
repair archivelog database '/home/dmdba/dmdata/DAMENG/dm.ini';
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[40584], file_lsn[40584]
repair archive log successfully.
repair time used: 276.717(ms)
time used: 280.266(ms)