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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
