Best Way to Shutdown?

I'm wondering about the best way to do an automated shutdown of an Oracle 7.3 database -- for doing cold backups, etc.

I've seen scripts that just do a plain SHUTDOWN, and move on to the backup. That can't be right. I figure that's got to at least be changed to a SHUTDOWN IMMEDIATE.

But then I wonder about how good it is to do a SHUTDOWN IMMEDIATE before a backup. I wonder if it's important to have a clean normal shutdown. So I figure I should do a SHUTDOWN IMMEDIATE, then a STARTUP RESTRICTED OPEN, then a SHUTDOWN NORMAL, then do the backup.

Or would it be adviseable to do a SHUTDOWN ABORT, then a STARTUP RESTRICTED OPEN, then a SHUTDOWN NORMAL, then the backup?

Comments, please? Received on Sun Nov 23 1997 - 00:00:00 CST