Markus, Sorry, I should have said. I'm using Solaris 10, and the database version is 7.6.00.12.
I'm trying the dd trick when the backup fails, but in this case the database kernel has started writing to both pipes, then gets 'broken pipe' from both pipes. So reading the pipes won't help in that case, I think. If I look now (several failed backups later), neither pipe exists. Unlike Legato, I'm letting the database create and delete the pipes. Thanks for the input. David -----Original Message----- From: "Döhr, Markus ICC-H" [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:54 To: David Lane Cc: '[email protected]' Subject: RE: Can't backup database after previous backup fails > The crucial question is whether I can do anything about this. > Failures of the failure1 type are inevitable, if for example > our backup system can't load a tape, or can't load a > follow-on tape - there will always be cases where we fail to > completely read the two pipes on a backup. Is there anything > I can do to recover from there, so that I don't have to > restart the database? I assume you're running Linux, right? What Version of MaxDB are you using? I think the problem is, that the second pipe never got its "data out" so the OS still has the buffers filled and the filedescriptor is still "busy" in the database. What happens of you do "dd if=/tmp/maxdb/datapipe2 of=/dev/null" after the first failed backup and then start the backup again? We're having the same scenario although we are using Legato Networker to backup. In this case the Legato-Client creates the pipe and not the database. If the backup fails, the pipes are closed _and_deleted_ by the client so the next attempt will lead to another new pipe creation. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _____________________________________________________________________ BridgeHead Software is pleased to confirm this e-mail has been scanned for viruses by MessageLabs. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
