注册
DMDSC归档不连续-修复归档
技术分享/ 文章详情 /

DMDSC归档不连续-修复归档

lysrwhjy 2024/07/05 1219 2 0

执行备份时报错

SQL> backup archivelog all backupset ‘/opt/dmdbms/dmdsc/bak/1’;
backup archivelog all backupset ‘/opt/dmdbms/dmdsc/bak/1’;
[-718]:Archive log collected not consecutive.
used time: 00:00:04.150. Execute id is 0.
([-718]:收集的存档日志不连续。)

停止两节点的数据库服务执行修复归档操作命令

./dmrman dcr_ini=/opt/dmdbms/dmdsc/dmdcr.ini
RMAN> REPAIR ARCHIVELOG DATABASE ‘/opt/dmdbms/dmdsc/dsc10_config/dm.ini’;
REPAIR ARCHIVELOG DATABASE ‘/opt/dmdbms/dmdsc/dsc11_config/dm.ini’;
REPAIR ARCHIVELOG DATABASE ‘/opt/dmdbms/dmdsc/dsc12_config/dm.ini’;
REPAIR ARCHIVELOG DATABASE ‘/opt/dmdbms/dmdsc/dsc11_config/dm.ini’;
file dm.key not found, use default license!
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
begin redo pwr log collect, last ckpt lsn: 60668 …
redo pwr log collect finished
EP[1]'s cur_lsn[60668], file_lsn[60668]
begin redo pwr log collect, last ckpt lsn: 60940 …
redo pwr log collect finished
EP[0]'s cur_lsn[60940]
EP[2]'s cur_lsn[61170]
EP[1] adjust cur_lsn from [60668] to [61170]
repair archive log successfully.
repair time used: 7846.124(ms)
time used: 00:00:07.847
RMAN>
RMAN>
RMAN> exit
used time: 0.449(ms). Execute id is 0.
SQL> SELECT SF_ARCHIVELOG_DELETE_BEFORE_TIME(NOW);

LINEID SF_ARCHIVELOG_DELETE_BEFORE_TIME(NOW)


1 11

used time: 3.987(ms). Execute id is 402.

执行备份操作,备份成功报错解决

SQL> backup archivelog all backupset ‘/opt/dmdbms/dmdsc/bak/1’;
executed successfully
used time: 00:00:03.272. Execute id is 403.

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服