RE: Informix and Veritas Netbackup - HELP!

I once had problems attempting data restores using Veritas NetBackup (3.1.1) and onbar. The messages I received was that the dbspaces were not backed up. However, I don't have the output from the bar debug file. So I don't know if my problem relates to yours. My problem was as follows : All indications were that the dbspaces were being backed up. Example ... in the bar activity log and Informix messages file, the dbspaces were listed as backed up successfully. It wasn't evident until I attempted a restore, 1 week after the backup, that some of our dbspaces were not being backed up. The bar activity log and Veritas "all log entries" from the attempted restore stated that the object was never backed up. Check to see if indeed your dbspaces were backed up : When NB backups up images, it logs this information into files under the following directory on the Master Server : /usr/openv/netbackup/db/images/server/{encrypted date}/{job class}{encrypted date}_UBAK.f The unix time stamp on these files is when the dbspace was successfully backed up. grep for your dbspaces in the files. If grep doesn't return your dbspaces, chances are they weren't backed up. Also check the Netbackup "All log entries". This report will show 4 important things : (1) when the backup job for the dbspace was added for the client, (2) When the backup job for the dbspace was started (3) When the backup job for the dbspace was beginning to write to tape. (4) When the backup job for the dbspace was successfully written to tape. When the problem I mentioned above occurred, the missing dbspace for the backup showed as added, but never started/begun nor successfully written. The problem lasted through 2 or 3 days and disappeared. Veritas couldn't explain the cause. This occurred just after we installed 2 patches from Veritas. So be warned. After applying patches, monitor you backups as closely as possible. -----Original Message----- From: John Kimberly [mailto:jkimb@flash.net] Sent: Thursday, April 29, 1999 9:20 AM To: informix-list@iiug.org Subject: Informix and Veritas Netbackup - HELP! Every night we get a successful backup, or so it says, using Veritas netbackup to a Sun controlled tape library. I am trying to perform a "cold restore" and I can't get any of the restores to work. When I run a backup, weather from the server or the client, the robot moves the tapes into position and I get messages as each dbspace is saved. When I try to do a restore, I get NO activity on the library. The onbar program hangs for about 20 seconds and I get the below message in the log: -------------------------- 08:20:41 [1411] <4> BSAInit: INF - Application ObjectOwner = informix, BSA ObjectOwner = INFORMIX 08:20:41 [1411] <4> BSAInit: INF - Return status = 0: BSA_RC_SUCCESS 08:20:41 [1411] <4> BSABeginTxn: INF - Return status = 0: BSA_RC_SUCCESS 08:20:41 [1411] <4> BSAGetObject: INF - ObjName.objectSpaceName = /nfsprodtcp 08:20:41 [1411] <4> BSAGetObject: INF - ObjName.pathName = /nfsprodtcp/rootdbs/0 08:20:41 [1411] <4> BSAGetObject: INF - ObjectOwner.bsaObjectOwner = INFORMIX 08:20:41 [1411] <4> BSAGetObject: INF - ObjectOwner.appObjectOwner = informix 08:20:41 [1411] <4> BSAGetObject: INF - Copy_id.left = 0 08:20:41 [1411] <4> BSAGetObject: INF - Copy_id.right = 925258198 08:20:41 [1411] <4> BSAGetObject: INF - Start_time = 04/27/99 20:09:58 08:20:41 [1411] <4> BSAGetObject: INF - End_time = 04/27/99 20:09:58 08:20:41 [1411] <4> BSAGetObject: INF - Size.left = 0 08:20:41 [1411] <4> BSAGetObject: INF - Size.right = 0 08:20:41 [1411] <4> BSAGetObject: INF - Issue restore command: /usr/openv/netbackup/bin/bprestore -I -s 04/27/99 20:09:58 -e 04/27/99 20:09:58 -L /usr/openv/netbackup/ext/db_ext/informix/infx_db_comm/infxbsa.1411.0 -t 6 /nfsprodtcp/rootdbs/0 08:20:46 [1411] <4> BSAGetObject: INF - Read from progress file: 08:20:43 INF - Server status = 227 08:20:46 [1411] <4> BSAGetObject: INF - Server exited with status 227: no entity was found 08:20:46 [1411] <4> BSAGetObject: INF - Return status = 26: BSA_RC_OBJECT_NOT_FOUND 08:20:46 [1411] <4> BSAEndTxn: INF - BSAVote_ABORT sent. 08:20:46 [1411] <4> BSAEndTxn: INF - EXIT STATUS 5: the restore failed to recover the requested files 08:20:46 [1411] <4> BSAEndTxn: INF - Server status = 227: no entity was found 08:20:46 [1411] <4> BSAEndTxn: INF - Return status = 32: BSA_RC_TXN_ABORTED 08:20:46 [1411] <4> BSATerminate: INF - Return status = 32: BSA_RC_TXN_ABORTED # ------------------------ Does anybody have any suggestion??? Thanks in Advance, John