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]