emergency log backup
Posted in 1999
Topics: Logging & Checkpoints
hi all, if I didn't LBU_PRESERVE to 1 and all the logical log have been filled up. what is the steps involved to perform the emergency backup ? regards, ===== __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com
K.Hong Lee <kwonghong@yahoo.com> wrote in message news:7u3ckr$10$1@news.xmission.com... > > hi all, > > if I didn't LBU_PRESERVE to 1 and all the logical log > have been filled up. what is the steps involved to > perform the emergency backup ? > > regards, Depends on your platform. On Unix you can use power of ONDATARTR or OnTape (if OnTape can backup logs). With NT - still OnTape. But sometimes this tool can't backup logs - in this situation I think you must set LTAPEDEV to NUL, restart your server (at this point all logical logs will be emptied), change LTAPEDEV back to not NUL, restart again and IMMEDIATLY made Level 0 backup. ------------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > > > > ===== > > __________________________________________________ > Do You Yahoo!? > Bid and sell for free at http://auctions.yahoo.com