 | | | Antwort: RE: Recover from lost log volume | Antwort: RE: Recover from lost log volume 2007-01-30 - By ulrich.lickert@(protected)
Back
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 ulrich.lickert@(protected)
WWW: http://www.uniklinik-freiburg.de/
"David Lane" <David.Lane@(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:uwe.hahn@(protected)]
> > Sent: 29 January 2007 17:54
> > To: David Lane; maxdb@(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:David.Lane@(protected)]
> > Sent: Montag, 29. Januar 2007 15:43
> > To: maxdb@(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:David.Lane@(protected)]
> > > Sent: 29 January 2007 14:37
> > > To: maxdb@(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/maxdb?unsub=uwe.hahn@(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.
> lickert@(protected)
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
|