| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: To Autostart or not to Autostart
I have.
If there are problems on the system and the sysadmin will be booting and rebooting the machine more than once in order to fix/diagnose/etc. the problem, its a lot nicer if the database does not have to come up , go down multiple times. Plus have the possibly of getting taken down without being shut down.
I have also come across systems that get stuck in a loop upon booting. Boot. Crash. Boot. Crash. ....etc. How much damage might you do to a DB that gets aborted time after time after time just because the DBA did not want to risk being woken up.
I would rather have to be called than risk a damaged database.
You could always create a simple script for the admin to run when the machine is up for good in order to bring all the databases back up.
-----Original Message-----
Sent: Thursday, August 22, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
I've never encountered a reason for not starting production databases when a system boots.
If the system is going to need media recovery, you're gonna get called.
No point it waking me up at 3:00 AM unless absolutely necessary. :)
Jared
"Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
Sent by: root_at_fatcity.com
08/22/2002 09:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: To Autostart or not to Autostart
Just an informal survey:
Would *you* automatically start a production Oracle instance on a boot of
a
Unix box?
Why or why not? Something version/OS specific (or maybe some crazy OPS reason)?
The only reason I can come up with for "no" is that I'm thinking an
autostart on boot could interfere with a recovery scenario, although I'm
at
a loss to come up with a specific case, thus the question.
Geez, only 34 and my memory is fading...
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WIUSA
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:
INET: Jared.Still_at_radisys.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).
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). Received on Thu Aug 22 2002 - 14:47:18 CDT
 |
 |