Re: standby instance, log recovery

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.Jacob@xxxxxxxxx
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
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx