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.
