RMAN Backup Error ORA-19588: Archived Log Recid Stamp Is No Longer Valid

12 Okt

betrifft:
Oracle Database – Enterprise Edition – Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Oracle Database – Enterprise Edition – Version 12.1.0.2 to 12.1.0.2 [Release 12.1]             – jede Plattform

Fehlerausgabe:
1. Invalid records in the controlfile
2. The rman backup job had been started TWICE.
3. Incorrect syntax

RMAN Backup of archived logs fails with following error:
channel dev_0: starting archive log backupset
released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_0 channel at 08/27/2010 07:22:55
ORA-19588: archived log recid 1485 stamp 727949642 is no longer valid

ORA-19588 may be seen with ‘datafile copy’ as well
like:
.
RMAN-03009: failure of backup command on ch01 channel at 02/01/2013 21:30:59
ORA-19588: datafile copy RECID 1019958 STAMP 806188828 is no longer valid

Lösungsansätze:
1. Fehlerhafte Einträge im Controlfile (invalid oder gelöscht)
2. Doppelter Aufruf des BackupJobs (resync unsauber – versucht identische Dateien (archivelogs) mehrfach zu löschen -inkl. der Controlfile Einträge)
3. Fehlerhafte syntax (backup archivelog all archivelog until time ‘sysdate -1’ delete input 😉 ersetzen durch (backup archivelog until time ‘sysdate -1’ delete input 😉

Zur Bereinigung einen Crosscheck laufen lassen und neu sichern:
RMAN> crosscheck archivelog all;
RMAN> backup archivelog all delete input ;

Diesen Artikel teilen :Share on Google+Share on LinkedInTweet about this on TwitterShare on Facebook