RE: Recover from lost log volume

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; [email protected]
> 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: [email protected]
> 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: [email protected]
> > 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/[email protected]