Re: shutdown mmediate gets hung

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 31 Jan 2005 13:06:09 -0800
Message-ID: <1107203098.561874.176260@z14g2000cwz.googlegroups.com>

Prem, my first advice is to think about taking an oracle course like database fundamentals 1.

Why do you shutdown your database every sunday? Is it for a cold backup?

Shutdown abort normally doesn't cause problems that oracle instance recovery cannot deal with but most oracle dba's reserve using it only when absolutely necessary.

When is it necessary? Usually only when a shutdown immediate is hanging for some reason.

No you should not change a startup to a startup restrict blindly either. Received on Mon Jan 31 2005 - 15:06:09 CST