1 故障现象

在DM8单机中，测试联机备份，需要切换到归档模式，达梦切归档有好几种方法，我们这里使用sql将达梦从非归档切换成归档模式。

DM7 达梦数据库 重做日志管理 及 归档模式切换
https://www.cndba.cn/dave/article/3575

http://www.cndba.cn/dave/article/116458

然后备份的时候报错：http://www.cndba.cn/dave/article/116458

[dmdba@www.cndba.cn ~]$ disql SYSDBA/SYSDBA@localhost:5237

Server[localhost:5237]:mode is normal, state is open
login used time : 1.592(ms)
disql V8
SQL> alter database mount;
executed successfully
used time: 344.176(ms). Execute id is 0.
SQL> alter database add archivelog 'DEST=/data/dm/dmarch,TYPE=local,FILE_SIZE=128,space_limit=0';
executed successfully
used time: 1.679(ms). Execute id is 0.
SQL> alter database archivelog;
executed successfully
used time: 5.272(ms). Execute id is 0.
SQL> alter database open;
executed successfully
used time: 315.264(ms). Execute id is 0.
SQL> select arch_mode from v$database;

LINEID     ARCH_MODE
---------- ---------
1          Y

used time: 1.483(ms). Execute id is 70600.
SQL> select arch_name,arch_type,arch_dest,arch_file_size from v$dm_arch_ini;

LINEID     ARCH_NAME      ARCH_TYPE ARCH_DEST       ARCH_FILE_SIZE
---------- -------------- --------- --------------- --------------
1          ARCHIVE_LOCAL1 LOCAL     /data/dm/dmarch 128

used time: 0.718(ms). Execute id is 70601.


SQL> backup database backupset '/data/dm/dmbak/full01';
backup database backupset '/data/dm/dmbak/full01';
[-718]:Archive log collected not consecusive.
used time: 844.244(ms). Execute id is 0.

2 解决方法

从错误现象看，是归档不联系，但我们这里是一个新建的实例，也是刚切换的归档模式，所以这个错误肯定不准确的。http://www.cndba.cn/dave/article/116458http://www.cndba.cn/dave/article/116458

[-718]:Archive log collected not consecusive.

http://www.cndba.cn/dave/article/116458

所以尝试重启了一下达梦实例，然后在备份就不报错了： http://www.cndba.cn/dave/article/116458

[root@www.cndba.cn ~]# systemctl restart DmServiceustc.service 
[root@www.cndba.cn ~]# 

[dmdba@www.cndba.cn ~]$ disql SYSDBA/SYSDBA@localhost:5237

Server[localhost:5237]:mode is normal, state is open
login used time : 1.834(ms)
disql V8
SQL> backup database backupset '/data/dm/dmbak/full01';
executed successfully
used time: 922.404(ms). Execute id is 300.
SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。