Re: shutdown immediate or abort for cold-backup?

The idea that a backup after a shutdown abort is dangerous is crap. It can only be true if there is some bug in the mechanisms oracle uses to cope with e.g. power outage.

In my experience, shutdown immediate stopped being reliable round about version 6 - it's forever hanging.

Your best bet is to switch to a hot backup so that the database is not shut down at all. Failing that you should revert to your earlier approach of shutdown abort, startup restrict, shutdown immediate.

Remember: the dba's job is to support YOU.

Sack him and get someone who knows what they're talking about and understands what customer service is.

"Heinz-Georg Bergerhausen" <boardersau_at_yahoo.com> wrote in message news:3B7CE511.70C9AF4A_at_yahoo.com...
> Hello,
>
> what are your experiences for the shutdown-strategy of an ORACLE
> database for cold backup?
>
> our dba has changed the strategy from
>
> 1.) shutdown abort - startup restricted - shutdown immediate
>
> to
>
> 2.) shutdown immediate
>
> we have now the problem with a longrunning batch-application causing the
> shutdown immediate never take effect, so that the database is not
> available in the morning for the online-users.
>
> I searched already on metalink, but the answers of the oracle
> consultants are contradictory :
> One says "if the shutdown immediate hangs use shutdown abort". Another
> one says "do not trust in a backup after shutdown abort" - but what if
> you restart - cleanup by that and "shutdown immediate" afterwards?
>
> The DBA tells it depends on the version and is most probably solved in
> 8.1.7.
>
> But that's what they always say ;-)
> and to switch to 8.1.7 would be again a major testing issue i wanted to
> avoid and switch directly to 9i (say, in about a year, if it is uable
> for production ;-))
>
> The database is ORACLE 8.1.6.3.1 on HP-UX11.
>
> Do we need to change this longrunning application (efforts!) or is it
> recommended for the DBA to switch to the shutdown-strategy of before? -
> Of course, we don't want to have unusable backups either.
>
> Any practical experiences?
>
> Thanks a lot.
>
> Greetings
> Henry
Received on Fri Aug 17 2001 - 04:54:06 CDT