Re: Is it really necessary to mirror the physical log?

Art S. Kagel wrote: -- SNIP (Original question) -- > Truth be told the result of Logical Recovery without Physical Recovery > is the same if all logical log records are available. This is > mathematically provable. HOWEVER, having said this, the engine WILL > NOT come up if it cannot perform Physical Recovery and while Tech > Support can bypass Physical Recovery and force the engine to go > online, this will also skip Physical Recovery. Physical Recovery is > REQUIRED for Buffered Logging when an entire log file of partial > transaction log records may be lost and even for Unbuffered Logging > when the log records in the LOGBUF is still at risk during a crash and > cannot be rolled back. > So, the final answer is YES you need to mirror your Physical Log > space. The general consensus was yes. Art's reply was IMO the most convincing, mainly the point about the physical recovery. Very logical and (in retrospect.. hee hee..) obvious. Thanks. -- -- Jake (Retrospectively realizes there is no future in hindsight) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+