Re: shutdown immediate or abort for cold-backup?

Both Oracle advices are correct and not contradictory.

IE: you should use an shutdown abort *ONLY* when your shutdown immediate fails, as shutdown abort crashes the database. So the second advice is also correct:
You should not trust in a backup after a shutdown abort.

However your solution 1) actually recovers the database before going down. So if you can't do it properly (shutdown immediate only) you should probably use the first solution.

Hth,

Sybrand Bakker, Senior Oracle DBA

"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 - 13:32:13 CDT