While executing rman backup, received below error.
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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
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;
1 帖子 • 分页： 1 / 1