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
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