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