Script to handle hanging shutdowns

Some of our databases hang on shutdown and this prevents our backup script from getting a good backup. Does anyone have a script that:

1. attempts a shutdown
2. checks to make sure the shutdown worked AND
3. If the shutdown failed, does a shutdown abort, startup, and clean shutdown???

I have these specific questions about the above process:

1. How do you detect if your database did not shut down cleanly. Is the existance of the 'sgadef' file the key?
2. Can a unix script fork off another process that sleeps for a few minutes and then does the shutdown abort if the "sgadef" still exists?

Thanks in advance. Received on Mon Jul 22 1996 - 00:00:00 CEST