Re: Shutdown immediate hangs

Hi Marco,

Please check up whether any of Long running query was running during that time. I so , shutdown immediare will wait until the query finishes. The best method is to use the folowing sequence fro shutting the database for backup.

> shutdown abort;
> startup restrict;
>shutdown ; ( or shutdown immediate as you wish )

Hope this helps.
Regards,

S Jayakumar

"Rooy van, Marco" wrote:

> Hi,
>
> Our environment is Alpha OpenVMS, Oracle 7.3.4 and we don't have Intelligent
> Agent running.
> One of the first things we do in our backup-job is a shutdown immediate.
> When I arrived in the office this morning it was still doing an shutdown
> immediate, normally it would finish this action 8 hours earlier.
> Has any of you have had this problem before and is shutdown abort the best
> action ?
>
> Best regards,
>
> Marco
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rooy van, Marco
> INET: Rooy_M_at_sfs.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Oct 19 2000 - 02:11:36 CDT