This post is more than 5 years old
4 Posts
0
3244
June 8th, 2016 18:00
db2 database online backup failed to Avamar. SQL2428N.
Hi,
Recently we have moved our db2 databases to Avamar backups from TSM. Since then we are seeing a backup issue.
Our daily schedule online db2 database backups are failing to Avamar with
"SQL2428N The BACKUP did not complete because one or more of the
requested log files could not be retrieved."
We never had such problem with TSM. Can anyone assist me in resolving this issue.
No Events found!
gautamgp
226 Posts
1
June 13th, 2016 20:00
Hi,
The problem is "DB2 needs to include an old archivelog in the backup image but avdb2 only looks for archivelogs up to one hour ago"
Do the below steps to resolve it.
Set in the option/flagfile the following variable:
--fallback-mins-search=How_many_minutes_ago_avdb2_will_look_for_archivelogs
Note: if the archivelog DB2 needs was done 4 hours ago then the variable can be set to 5 hours ago
--fallback-mins-search=300
db2_avamar
4 Posts
0
September 26th, 2016 07:00
Gautam,
Thanks a ton to you. This parameter perfectly worked and resolved the unable to retrieve logs issue currently we are facing and now we have another issue araised which is our db2 online database backups are failing with the below error.
SQL2062N An error occurred while accessing media
"/usr/local/avamar/lib/libdb2_avamarloader.so". Reason code: "265".
smajeti
5 Posts
0
October 27th, 2016 07:00
Hello
Where do I set the option? I am facing the same issue and when entered that as free form in the GUI for backup it fails with invalid flag.
I am using Avamar 7.1.
Thanks
smajeti
5 Posts
0
October 27th, 2016 07:00
Hello
Where do I set the option? I am facing the same issue and when entered that as free form in the GUI for backup it fails with invalid flag.
I am using Avamar 7.1.
Thanks
db2_avamar
4 Posts
0
October 29th, 2016 20:00
try setting the value --[avdb2]fallback-mins-search=time in mins in the
attribute field of GUI and retry backup.
On Thu, Oct 27, 2016 at 10:09 AM, smajeti