Re: Stuck in Fast Recovery?

In article <Pine.OSF.3.95.980824103652.29082A-100000@sable.ox.ac.uk>, newc0571@sable.ox.ac.uk (Stephen Walmsley) wrote: > > Online 4.10.UD2 > SCO 3.2.4.2 > > At 17:49 on Saturday I started the build of a huge index. At around > 10:40 > on Sunday, around 17 hours later, the box suffered a loss of power. It's > essentially a read-only database; there were no other transactions in > progress at the time. > > Online promptly went into Fast (sic) Recovery and has been in every > since. > The logs show that physical recovery completed successfully. [cutting] If you are absolutely sure that the engine has stopped doing anything you make like try to stop and restart it. I have no idea why this sometimes clears it but it does work. But, and its a big but, only if the engine has stop doing anything. > > Is it worth me keeping the faith? This really is incredibly frustrating > not being able to do anything and having no indication whatsoever as to > how long it's going to take. It's the only thing about Online that I > really hate. Do the other "big boys" like Oracle and Sybase make people > sit around for hours waiting for their business-critical boxes to > "decide" to become usable again? Having just started a job where there is a considerable Oracle presence I find myself amazed just how poor Oracle (7) appears to be. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #