Re: shutdown immeditae waiting, grep ora, got process

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3f90f533$0$24515$afc38c87_at_news.optusnet.com.au>...
> yls177 wrote:
>
> > hi, below are my steps
> >
> > 1) shutdown immediate;
> > 2) but oracle still hanging, as in can do a ps -ef | grep ora and
> > still the set of family oracle processes are alive
> > 3) so i do a select * from v$instance;
> > 4) and when it says that " oracle not available"
> > 5) then i safely do a shutdown abort
> > 6) finally, the family set of oracle processes are gone.
> >
> > but is it absolutely safe to do this?
> >
> > please confirm
>
> It's never *absolutely* safe to do a shutdown abort. There is a miniscule,
> but real, risk that you lose your current redo log seconds after doing the
> shutdown abort. *All* shutdown aborts require instance recovery on
> subsequent startup. All instance recoveries require the contents of the
> current redo log to be available. Therefore, after a shutdown abort, if you
> lost your current redo log, you would not be able to do instance recovery
> and you would be faced at best with the prospect of performing an
> incomplete media recovery... meaning transactions would be lost.
>
> A lot of people do shutdown abort - startup -shutdown immediate to get
> around this problem.
>
> Me? I would shutdown the intelligent agent, and then do a shutdown
> immediate. The agent has a session on the database, and it's one that seems
> not to respond very well to the shutdown immediate command. So kill the
> agent first, and you tend to find immediate shutdowns become a lot faster.
>
> Regards
> HJR
hi, thanks for your sharing... from what i could understand from your post, basically 2 areas

1. if there is ever a need to do a shutdown abort. we need to follow up by a startup and then shutdown immediate. this is because we want to avoid lost transactions?
2. when we stop this intelligent agent by "Before 9i, it was lsnrctl dbsnmp_stop. In 9i,it's agentctl stop." this will bring shutdown immediate a lot faster?

please kindly confirm.

thanks Received on Sun Oct 19 2003 - 05:15:37 CDT