Oracle ORA-19588 errors with Actifio

CDM产品综合讨论
回复
fire
帖子: 4
注册时间: 16 5月 2018 09:09
来自: 北京
联系:

Oracle ORA-19588 errors with Actifio

帖子 fire » 20 6月 2018 22:44

PROBLEM:
While executing rman backup, received below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t4 channel at 05/01/2017 03:18:01
ORA-19588: archived log RECID 143154 STAMP 942443843 is no longer valid

SOLUTION:
This error is usually encountered for 2 reasons.

1. Either 2 backups, like one full backup and one archive log backup, are running in parallel. If the archivelog backup job tried to take backup of the archives, which were backed up and deleted by the full back job running at the same time, then this warning will come.

So never schedule two backups at the same time

2. Another reason might be because of few invalid or deleted records in control file.

To clean up invalid records, crosscheck the archive log:

RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
It is recommended to use delete input option while backing up archivelog.
RMAN> backup archivelog until time 'sysdate-1' delete input;

回复