We have Oracle 11g in our production environment on Red Hat Enterprise Linux. Our backup policy is taking incremental level 0 backups on Sunday & Wednesday and incremental level 1 backups on other days. The incremental level 0 backup failed on Sunday (15th March ’15) which happened first time in more than a year. The partition into which this backup goes touched 90% on 14th Mar '15 but there is anyway enough space to store the backups. In OEM, there are 3 stages which have statuses as:
Prebackup - Succeeded
Backup - Failed
Post Backup – Succeeded
2 error messages are showing in OEM as:
ORA-19502: write error on file "/orabackup/rman/snlprod/control_files/c-225853591-20150315-01", block number 320 (block size=16384)
ORA-27072: File I/O error
There is a retry operation showing in OEM as “The Retry operation will run immediately and may skip steps that have already completed successfully.” Should I retry the operation? If the job can run successfully after the retry. Also in case of a restore required due to unforeseen circumstances till the next incremental level 0 backup is taken on 18th Mar ‘15, would the restore happen by considering the last successful level 0 backup on 11th Mar ’15 and applying incremental level 1 backups thereafter?
I hope my question is clear of how to handle this failed backup.
Requesting a reply to my post.
Regards