RE: STARTUP Force

So, if you are recovering you would use it? I feel my reply was quite a reasonable one then, if you are shuting down normally, don't use it..

I only told her to use it as a last resort, and a recovery situation is pretty much a last resort.. In my book anyway..

And I did actually only learn about forcing the checkpoint before a shutdown abort a couple of days ago believe it or not! Thanks for the tip though.. I learn every single day :^)

-----Original Message-----
Patrick
Sent: Thursday, February 08, 2001 10:51
To: Multiple recipients of list ORACLE-L

Yeah right! I have six years of experience and I use shutdown abort all the time. Just force a checkpoint first to speed up hot recovery on the startup. The other forms of shutdown take too long, and may never complete if you have long running transactions that don't do frequent commits. Check out the following paper if you think I am wrong... http://www.wolfenet.com/~jeremiah/241.pdf

Startup force, on the other hand, I would never use this unless I had a high level oracle support engineer holding my hand.

> -----Original Message-----
> From: Mark Leith [SMTP:mark_at_cool-tools.co.uk]
> Sent: Wednesday, February 07, 2001 8:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: STARTUP Force
>
> One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST
> resort!!
>
> If you are shuting down the database normally, on 8, first do a SHUTDOWN
> TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN
> IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue
> a
> SHUTDOWN ABORT!!
>
> SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the
> arse (as a list memeber found out recently).. You don't seem to have a lot
> of experience with Oracle, as Joe mentioned. Now I have around 3 years
> experience and STILL have NO experience with Backup and Recovery (fair
> enough it is not an issue for me).
>
> Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start
> reading away.
>
> Regards
>
> Mark
>
> -----Original Message-----
> Testa
> Sent: Wednesday, February 07, 2001 12:30
> To: Multiple recipients of list ORACLE-L
>
>
> Neena, after looking at your last 3 messages, you need to sit down and
> read the administrators guide, 90% of your questions are answered in
> that book and nowadays there is no excuse for not reading docs(unlike
> back in version 6 days when people used to hoard the books).
>
> joe
> TIL-TEC wrote:
> >
> > When do a DBA prefers to use STARTUP FORCE than SHUTDOWN
> > ABORT+STARTUP NORMAL ?
> >
> > --Neena
>
> --
> Joe Testa http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.com
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Elliott, Patrick
  INET: Patrick.Elliott_at_bestbuy.com

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

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).