Pages

Monday, 3 April 2017

ORA-19588: archived log RECID 2243694 STAMP 940208948 is no longer valid

ORA-19588: archived log recid 24909 stamp 740658206 is no longer valid

We got this error due to the mix up of the scheduled archive job with full backup job which incudes archive logs

The archive backup job ran for more than expected time which mix up with the scheduled full backup job and caused the failure of full backup job

This is not an error but a warning. The reason for this is archive logfile which this process is trying to take backup, is already been backed up by another process and file is deleted

So to avoid this we have two ways

1. If you want to run a manual backup, just check whether any other RMAN backups are in execution phase.

[oracle@hostname logs]$ ps -ef | grep rman

[instance1]:oracle@node1:/orabck/node1/log>ps -ef | grep rman
oracle   18741 18736  0 03:05 ?        00:00:00 /bin/bash /u01/app/scripts_rman/rman_backup.sh -s instance1 -t arl -l N -k 0
oracle   18809 18741  0 03:05 ?        00:00:10 rman app/oracle/product/11.2.0.4/dbhome_1/bin/rman target  rman/rman@Service_String catalog  rman/cat@tns_string_catalog



2. Don’t schedule archive backup job during full database backup (including archivelog). Always make sure you have only one RMAN backup in process

No comments:

Post a Comment