Hi Uwe, I am running SAPDB 7.4.3.32-1 (Value of KERNELVERSION is KERNEL 7.4.3 BUILD 032-121-068-842) on Linux SuSE 8.2 (with all the latest patches). It is latest 7.4.3 build I guess. Also on recover_cancel the instance status becomes offline - is it supposed to be this way? Are there any prerequisites for this savepoint to work, or should I activate it somehow?
Regards. Alexei. --- "Hahn, Uwe" <[EMAIL PROTECTED]> wrote: > Hello Alexei, > > after recover_cancel (for log recovery) should a > savepoint be written. > This savepoint makes it possible to start log > recovery again at this point. > > But there was an error in some versions which > prevented such savepoint. > Could you give me your used release and build > please? > It seems to me that your using a version which > contains this error. > > regards, > Uwe > > >-----Original Message----- > >From: Alexei Novakov > [mailto:[EMAIL PROTECTED] > >Sent: Thursday, June 17, 2004 8:38 AM > >To: MaxDB mailing list. > >Subject: RE: SAPDB Standby database setup. > > > > > >Hi Tilo, > > > >Thanks for your response. > > > >> >1) Are there alternatives to load log backups on > >> >standby instance other then do > >> >recover_start-recover_replace in one utility > >> session? > >> > >> End your log recovery with a recover_cancel (DBM > >> Server should do that by default, when ending > with a > >> still open utility session.) And restore the next > >> needed log backup with recover_start. You can > >> determine the next needed log backup with the > dbmcli > >> command db_restartinfo on the standby database > and a > >> look into the backup history of your source > >> database. > > > >Yes I tried this, but it seems that next time I > have > >to start recovery starting from the first log > backup > >anyways even though it was recovered in previous > >session already. I think it kills the idea of > feeding > >standby instance with sequential log backups. Am I > >missing something? > > > >> >2) Can I extend one utility-backup-recover > session > >> >over multiple dbmcli calls? > >> > >> No yet. Most probably in the future. > > > >It would definitely be the solution for previous > >problem. > > > >> >3) Are there any other common solutions to setup > >> >standby instance? I read article of Dr. Yves > >> Trudeau > >> >on the topic, but that solution is not possible > in > >> our > >> >environment and since this article was written 3 > >> years > >> >passed, so I would expect that some developments > >> has > >> >been done in this field. > >> > >> You could buy expensive hardware and implement > our > >> new Hot Standby solution, where the kernel of the > >> standby databases share the same log volume as > the > >> master database and read the log entries, as they > >> are written. But most probably that solution will > be > >> too expensive. > >> > >> Best Regards, > >> Tilo Heinrich > >> SAP Labs Berlin > > > >Best regards. > >Alexei. > > > > > > > >__________________________________ > >Do you Yahoo!? > >Yahoo! Mail is new and improved - Check it out! > >http://promotions.yahoo.com/new_mail > > > >-- > >MaxDB Discussion Mailing List > >For list archives: http://lists.mysql.com/maxdb > >To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
