Hi David, I think the best is to create a new DB-Instance. In the creation dialog you have the option to generate the instance from backup: then the log-volume will be initialized a you have the possibility the recover the full/pages and the log also.
Greetings Uli ____________________________________________________ Ulrich Lickert, Universitaetsklinikum Freiburg Klinikrechenzentrum, Agnesenstr. 6-8, D-79106 Freiburg Tel +49-761-270-2265 Fax +49-761-270-2066 E-Mail [EMAIL PROTECTED] WWW: http://www.uniklinik-freiburg.de/ "David Lane" <[EMAIL PROTECTED]> schrieb am 30.01.2007 11:03:12: > Uwe, > > Thanks for your reply. I have tried that. > - Restore full - works ok > - Restore pages - works ok > - Restore log - fails. > > Dbmcli reports > -24920,ERR_BACKUPOP: backup operation was unsuccessful > The database was unable to fulfill a request (-902, I/O error). > > Database messages (verbose) shows: > 2007-01-30 09:51:47 IO 11597: Open > '/var/opt/sdb/data/MAXDB1/log/DISKL0001' successfull, fd: 17 > Thread 0x1A > 2007-01-30 09:51:47 ERR IO/READ 11987: read error: rc=0, > wanted=8192, 'NO ERROR(0)', try again > Then > Thread 0x14 Task 97 > 2007-01-30 09:51:49 vattach 11000: > '/var/opt/sdb/data/MAXDB1/log/DISKL0001' T97 failed > Thread 0x14 Task 97 > 2007-01-30 09:51:49 ERR IOMan 26: Attach error on Log volume > 1: Could not open volume > Thread 0x14 Task 97 > > The problem is that the log volume > /var/opt/sdb/data/MAXDB1/log/DISKL0001 was lost. > I have tried the log restore with /var/opt/sdb/data/MAXDB1/log/DISKL0001 > missing, and it fails. > I also tried creating an empty /var/opt/sdb/data/MAXDB1/log/DISKL0001 > file, but it still fails. > > I cannot find any way to recreate > /var/opt/sdb/data/MAXDB1/log/DISKL0001. > > Your help will be much appreciated. > > Thanks > > David Lane > > > -----Original Message----- > > From: Hahn, Uwe [mailto:[EMAIL PROTECTED] > > Sent: 29 January 2007 17:54 > > To: David Lane; maxdb@lists.mysql.com > > Subject: RE: Recover from lost log volume > > > > Hi David, > > > > you have to reinstall your database instance with your last > > data- and log-backups. > > > > Kind regards > > Uwe > > > > -----Original Message----- > > From: David Lane [mailto:[EMAIL PROTECTED] > > Sent: Montag, 29. Januar 2007 15:43 > > To: maxdb@lists.mysql.com > > Subject: RE: Recover from lost log volume > > > > I forgot to mention: I am running MaxDB 7.6 on solaris 9. > > > > > -----Original Message----- > > > From: David Lane [mailto:[EMAIL PROTECTED] > > > Sent: 29 January 2007 14:37 > > > To: maxdb@lists.mysql.com > > > Subject: Recover from lost log volume > > > > > > How do I recover from total loss of my log volume? I can restore > > > database backups ok, but when, after restoring the backups, > > I try to > > > change the database to online mode (from > > > dbmgui) I get > > > > > > -24988 sql error [db_online -f] -902,I/O error. > > > > > > In knldiag: > > > > > > 2007-01-29 14:23:20 0x14 11000 vattach > > > '/var/opt/sdb/data/MAXDB1/log/DISKL0001' T92 failed > > > 2007-01-29 14:23:20 0x14 ERR 26 IOMan Attach > > error on Log > > > volume 1: Could not open volume > > > > > > /var/opt/sdb/data/MAXDB1/log/DISKL0001 is the lost log > > volume. I have > > > tried creating the file (just an empty file) and that makes no > > > difference. I found something in the mailing archive about > > > 'util_execute clear log' to reinit the log, but that crashes the > > > database. > > > > > > What am I missing? > > > > > > Thanks > > > > > > David Lane > > > > > > > > > > > > > > _____________________________________________________________________ > > > BridgeHead Software is pleased to confirm this e-mail has > > been scanned > > > for viruses by MessageLabs. > > > > > > > _____________________________________________________________________ > > 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] > > > > > > _____________________________________________________________________ > 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/maxdb?unsub=ulrich. > [EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
