RE: To autostart database or not?
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <paul.baumgartel@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 May 2007 13:18:11 -0400
I agree with you. Makes no sense to me. So what if the server goes
down, up, down and then up. Oracle is built for restart.
--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity to
whom it is addressed. If you are not the intended recipient, you are hereby
notified that any disclosure, dissemination, copying or distribution of this
transmission or its attachments is strictly prohibited. In addition,
unauthorized access to this transmission may violate federal or State law,
including the Electronic Communications Privacy Act of 1985. If you have
received this transmission in error, please notify the sender immediately by
return e-mail and delete the transmission and its attachments.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul
Sent: Thursday, May 10, 2007 11:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: To autostart database or not?
I'm curious: Why not auto-start dev and test?
Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Steven K -
MSHA
Sent: Thursday, May 10, 2007 10:41 AM
To: GuangMei@xxxxxxx; dwaynec@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: To autostart database or not?
We are set up the same. Production auto starts. Dev and test do not.
SAs know to call if there is an issue on restart.
Works great. I love my sleep.
Steve Smith
Desk: 303-231-5499
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Guang Mei
Sent: Thursday, May 10, 2007 7:44 AM
To: dwaynec@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: To autostart database or not?
I have my production dbs auto-started, while the dev dbs not.
Usually the alert log file and trace/dump file would give you enough
clue(s) why the instance goes down. I am in Boston and I had one db in
California went down at 3am (Boston time) because of power outage. I did
not get the call and it auto-started.
Guang
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dwayne Cox
Sent: Thursday, May 10, 2007 8:38 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: To autostart database or not?
We are running a few Oracle9i and 10g databases on RHEL and I have
always opted NOT to have the databases automatically restart when the
server goes down due to something unexpected. My thinking was that if
the server crashed, then I want to be there to bring up the databases to
assess and repair any damage (yes, I am the only production DBA).
Am I being overly controlling? Looking for other opinions and thoughts
on the matter.
Thanks
--
Dwayne Cox, Corporate DBA
Info Tech, Inc.
dwayne.cox@xxxxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
========================================================================
======
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
========================================================================
======
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: