备份报错

• [718] archive log collected not consecutive

处理办法

--报错信息archive log collected not consecutive
SQL> backup database full backupset '/dmdata/dmbak/db_full_bak_01';
file dm.key not found, use default license!
- [718] archive log collected not consecutive
--修复数据库归档日志（脱机才能执行RMAN相关命令）
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)
--再启动服务进行数据库备份即可