Re: tbinit without logical recovery ??

Art S. Kagel wrote: > Michal Hajek wrote: > > We fall into problems with logical logs. I know it is a dirty > > action, but is it possible to initialize online with only > > physical recovery and without logical recovery ? > > > Why would you intentionally do this though? You will lose transactions > not committed before the crash including any committed between the > last checkpoint and the crash. > I know I will lose not commited transactions. As I wrote in other posting before, we are in troubles with logical logs. It seems in obscure case logical log with active transactions are freed.... when the transaction wants to do rollback, online aborts with errors "logread() failed" and we have to restore from level0 and level1. But because wrong freeing of logs can occure shortly before archiving, we can even have unusable level0 - that's really _BAD_ situation. In last crash we had last level1 unusable (it did not contain needed logs), and had to use level1 2 hours before last level1 -> that means 3 hours of lost data and 8 hours offline. After crash, online could not go to quiescent mode, because it can not find logical logs needed for rollback. But in very most cases only unsignificant amount of data would be pained with not rollbacked transaction. And this would be better for us than complications with restoring. Did I say it clearly ? MH -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic ICQ UIN: 14290832 --------------------------------------------------------------