From: Raimund Jacob (Raimund.Jacobpinuts.de)
Date: Tue Jan 25 2005 - 07:59:19 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Heinrich, Tilo wrote:

hallo!

>>>may i ask what's so dangerous about going online in the standby
>>>instance? is it that logs are being written? but the 'clear
>>>log' should
>>>help then?
>
> Log is created during going online and a new Savepoint is written to the
> data volumes at the end of it. So if you start into mode ONLINE between
> restoring data and restoring the first log a 'clear log' does not help.
> If you do start into mode ONLINE only before you restore data and not
> between data and log restores a 'clear log' is a viable solution.

i see. i'll play around with that. i assume starting online after a
log-import makes it impossible to import a log again due to the
savepoint written at startup.

thank you very much for the answer. it helps :)

        Raimund

--
7. RedDot Anwendertagung der RedDot Usergroup e.V. am 31.1.2005
Pinuts präsentiert neue Entwicklung, http://www.pinuts.de/news

Pinuts media+science GmbH http://www.pinuts.de
Dipl.-Inform. Raimund Jacob Raimund.Jacobpinuts.de
Krausenstr. 9-10 voice : +49 30 59 00 90 322
10117 Berlin fax : +49 30 59 00 90 390
Germany

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]