达梦技术社区:https://eco.dameng.com
【报错现象】
# 使用前台启动DM服务
dmdba@dw1_01[pwd:~/dmdbms/bin]$ dmserver ../../dmdata/dm03/dm.ini
# 新开一个窗口练到disql执行备份
dmdba@dw1_01[pwd:~/dmdata/dm03/bak]$ !disql
SQL> BACKUP DATABASE BACKUPSET 'BACKUP_FILE';
BACKUP DATABASE BACKUPSET 'BACKUP_FILE';
[-718]:收集到的归档日志不连续. --备份失败
已用时间: 22.742(毫秒). 执行号:0.
# 查询当前的备份集
SQL> select * from v$archived_log;
行号 RECID STAMP NAME DEST_ID THREAD# SEQUENCE#
---------- ----------- ----------- --------------------------------------------------------------------------------- ----------- -------------------- -----------
RESETLOGS_CHANGE# RESETLOGS_TIME RESETLOGS_ID FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME BLOCKS
----------------- -------------- ------------ -------------------- -------------------------- -------------------- -------------------------- -----------
BLOCK_SIZE CREATOR REGISTRAR STANDBY_DEST ARCHIVED APPLIED DELETED STATUS COMPLETION_TIME DICTIONARY_BEGIN DICTIONARY_END END_OF_REDO BACKUP_COUNT
----------- ------- --------- ------------ -------- ------- ------- ------ --------------- ---------------- -------------- ----------- ------------
ARCHIVAL_THREAD# ACTIVATION# IS_RECOVERY_DEST_FILE COMPRESSED FAL END_OF_REDO_TYPE BACKED_BY_VSS ARCH_TYPE EP_SEQNO ARCH_SEQ NEXT_SEQ
---------------- ----------- --------------------- ---------- ---- ---------------- ------------- --------- ----------- -------------------- --------------------
VERSION
--------------------
1 NULL NULL home/dmdba/dmdata/dm03/arch/ARCHIVE_LOCAL1_0x4D86DEFF_EP0_2022-04-28_15-43-09.log NULL 0 1
NULL NULL NULL 35704 2022-04-28 15:43:09.791464 38218 2022-04-28 15:43:09.791464 NULL
NULL NULL NULL NULL YES NULL NO A NULL NULL NULL NULL NULL
NULL NULL NO NULL NULL NULL NULL LOCAL 0 4584 4655
458764
# 从查询结果来看,这里存在了一个备份集,到物理路径下找一找,未找到
dmdba@dw1_01[pwd:~/dmdata/dm03/bak]$ ll
total 0
【问题处理】
处理方法有以下几种:
- 备份前先执行归档
ALTER SYSTEM <修改系统语句>;
<修改系统语句>::= SWITCH LOGFILE | ARCHIVE LOG CURRENT
即:
sql> alter system switch logfile;
--或
sql> alter system archive log current;
- 手动执行检查点
sql> checkpoint(100);
- 重启数据库
$ DmServicexx restart
达梦技术社区:https://eco.dameng.com