Re: alter system v shutdown abort

This is an automated process which was implemented before I came. It makes a "business copy" of the DB as a backup in 6 minutes and a bunch of other stuff. It is an HP solution not an oracle solution. If I had my druthers I would use rman etc. and never shut the database down unless absolutely necessary. But it isn't my call. The SA wants to know if killing any session which should not be logged on will work as well as doing a shutdown abort etc. since the other says that is what she does (not the same boxes).

Ruth

On 9/13/06, Jay.Miller_at_tdameritrade.com <Jay.Miller_at_tdameritrade.com> wrote:
>
> Ah, if you have to shut down the database (though can't you just do a
> hot backup or RMAN?) then I'd go with abort, startup, immediate. KISS
> applies here I think. Shouldn't take any longer than running the kill
> script.
>
>
>
>
>
>
>
> Thanks,
>
> Jay Miller
>
> Sr. Oracle DBA
>
> x68355
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Queen Roo Roo
> *Sent:* Wednesday, September 13, 2006 2:57 PM
> *To:* Smith, Ronald [Contractor]
> *Cc:* oracle-l
> *Subject:* Re: alter system v shutdown abort
>
>
>
> The situation is that we have to have all users off so that the system can
> shut down for backup. It's an HP_UX HA solution that I am not familiar
> with. If all active users are not off, the process doesn't run and the
> stuff hits the fan. The process does a shutdown immediate as it's first
> action but that fails if a hung user is left on. I suggested that we use my
> program to see if there are any active users and kill them. The other
> option is the shutdown abort, startup, shutdown immediate but that might
> take longer than we have before system before the next step is excuted.
> Just killing any hung users seems to be less dangerous. Any other
> thoughts?
>
>
>
> Thanks again,
>
> Ruth
>
>
>
> On 9/13/06, *Smith, Ronald [Contractor]* <Ron.Smith_at_tronox.com> wrote:
>
> I have had to recover more than once after doing a shutdown abort. I only
> use it as a last resort.
>
> I kill the users, shutdown immediate, startup, shutdown (normal).
>
>
>
> Ron
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Queen Roo Roo
> *Sent:* Wednesday, September 13, 2006 1:40 PM
> *To:* oracle-l
> *Subject:* alter system v shutdown abort
>
> Hello everyone,
>
> Can someone tell me an alter system kill session 'sid,serial#'; will kill
> runaway processes or long running queries as efficiently as doing a shutdown
> abort, startup , shutdown immediate? I have always run a job which shutdown
> kills all users who shouldn't be on after a specific time but the
>
> SA at my new job is skepticle because another DBA told him to use a
> shutdown abort, startup, shutdown immediate sequence.
>
>
>
> Thanks in advance,
>
> Ruth
>
> --
> Ruth Gramolini
> ruth.gramolini_at_gmail.com
>
> *Please note my E-Mail Address has changed. Please
> update your contact list*
>
>
> ------------------------------
>
>
>
> *
> Anadarko Confidentiality Notice:
> This electronic transmission and any attached documents or other
> writings are intended only for the person or entity to which it is
> addressed and may contain information that is privileged,
> confidential or otherwise protected from disclosure. If you have
> received this communication in error, please immediately notify
> sender by return e-mail and destroy the communication. Any
> disclosure, copying, distribution or the taking of any action
> concerning the contents of this communication or any attachments by
> anyone other than the named recipient is strictly prohibited.*
>
>
> Important Notice!
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited.
> Please let me know immediately by return e-mail if you have received this
> message by mistake,
> then delete the e-mail message.
> Thank you.
>
>
>
>
> --
> Ruth Gramolini
> ruth.gramolini_at_gmail.com
>

-- 
Ruth Gramolini
ruth.gramolini_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l