Antwort: disaster recovery questions

"Filip Sergeys" <filip.sergeys@xxxxxxxxxxxxxxxx> schrieb am 25.11.2004
16:10:28:

> I'am seeking the answer on three hypothetical situation where I need to
> recover a database (needed to write out a DRP)
>
> 1) suppose somebody updates a table with wrong values and that query is
> committed. After a few hours the error is spotted. Is it possible to
> recover that individual table without stopping the entire database? If
> it is not possible while the database is online, how do I recover the
> database without losing the latest transaction on other tables; because
> if I set back a backup until the time just before the disaster, I lose
> all information since then on the other tables
>
> Maybe two cases must be seen
>    a) no one changed that table after the update
>    b) other transactions where done on that table since the update

the only way I see:
install max-db on a second server. on this second server you recover your
database until the point, where
this table has been ok. then you can recover your table-data (for example
with the loader-tool) into
your original database. you don't have to stop your original database.


>
> 2) same situation, but one or more tables where dropped.

same thing


Greetings
Ulrich Lickert
____________________________________________________
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@xxxxxxxxxxxxxxxxxxxxx
WWW: http://www.uniklinik-freiburg.de/


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx