Using 'onbar -r -p' an Informix database physical files are sucessfully restored to an alternate Informix server.
However, while attempting to restore the corresponding logical logs using 'onbar -r -l', the restore fails to find the needed logs although present on tape.
The bar_act.log shows that logs needed for this restore do not exist.
Example:
------
XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager.
ON-Bar could not get logical log 270777 from the storage manager.
ON-Bar suspended the logical restore on log 270777 (expected to restore to 2147483647).
------
The tapes containing all data needed for the restore, full and incremental logical logs, are loaded and scanned in the library.
Informix uses the ixbar.ZZZ file to keep track of backups but also to determine which items are needed during restore requests.
Each backup item has a backup CopyID and a logical path which are also recorded in the backup indexes by NVBU.
Experienced DBAs can manually adjust this file to make restores simpler and remove entries they don't need, which was the case here.
During restore requests, the Plugin for Informix installed on the NVBU server, will search the backup indices to produce a match with the same informix object, logical path and backup CopyID requested by ON-BAR.
However since the ixbar.ZZZ was modified and the environment different, there was a mismatch between the information requested by ON-Bar and the items stored in NetVault.
As an example, while the backup CopyID were identical between NVBU and ixbar.ZZZ, the incremental backup logical path was backed up as:
/on491:/on491/1/78422
but requested by OnBar as:
/on491:/on491/99/78422.
Note that this is not neccessarily a filesystem pathname, but a pathname within an Informix space.
For scenarios where the ixbar.ZZZ was modified leading to a mismatch between the logical path requested by ON-Bar and the one stored in NVBU, there exist a Plugin for Informix version
that will ignore the logical path and only use the backup CopyID to match backups in NVBU.
Please contact Technical Support to request this patch produced for Bug 26401.
This new plugin only has to be installed on the NVBU server not the NVBU Client.
The plug-in on the NVBU Client, performs backup and restore operations and does not need upgrading in this case.
The plug-in on the NVBU Server, is the one used to look into the NVBU MediaDatabase, for the backup index matching a restore, and needs to be updated.
All Informix Plugin versions produced after 4.1.3 will include this fix in future releases.