| 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: Taking your time when a crisis occurs
I had this situation last year, when I recognised the voice of my boss at 4am I knew something was going wrong (24x7 database).
The CEO held a quick meeting , ask us our advices ,
then let us work without asking us each 5 minutes how
things were.
I appreciated that a lot .
--- Rachel Carmichael <carmichr_at_hotmail.com> a écrit :
> want to tell me how you hold off the CEO who is
> breathing down your neck on
> the 24x7 database that's down?
>
>
> >From: "William Beilstein" <BeilstWH_at_obg.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> >Subject: Re: Taking your time when a crisis occurs
> >Date: Mon, 07 May 2001 05:30:57 -0800
> >
> >I agree, many serious problems have been created by
> DBA's that act before
> >they think things through. When I have a problem
> with the database, I get a
> >cup of coffee, put my feet up, and think about what
> happened and what to do
> >to solve the problem. Between corrupted data files,
> hardware crashed, bad
> >data in tables and other nasties, I have never
> failed to take care of the
> >problem, because I figured out what to do before
> starting the repair.
> >
> > >>> stephane_paquette_at_yahoo.com 05/07/01 04:30AM
> >>>
> >The golden rule when there is a big crash is :
> >1. Panic
> >2. Stop panic
> >3. Fix the problem
> >
> >
> >--- "Hallas, John" <HallasJ_at_logicae.com> a écrit :
> >
> >FOR YOUR INFORMATION
> > >
> > > ESIS and EPFAL are now part of Logica. The
> Internet
> > > email addresses of the staff has changed to the
> > > following - lastnameinitial_at_logica.com eg
> > > SMITHK_at_logica.com. Emails using the old format
> will
> > > continue to be delivered until 30th June 2001.
> > >
> > > David,
> > > I support what you say about taking your time
> > > entirely. In fact at any
> > > interviews I attend backup/recovery question(s)n
> are
> > > always asked. My
> > > standard answer is the at then first thing I
> will do
> > > is go for a cup of
> > > coffee. After their jaws have finished dropping
> I
> > > explain how thinking time
> > > is required etc.
> > >
> > > On a similar theme a few years ago I was
> > > interviewing for a contract DBA
> > > and he made the statement along the lines of
> 'you
> > > are paying me more because
> > > I have made mistakes before and I have learnt
> from
> > > them so you will be safe
> > > with me'. ( I am sure he phrased it more
> eloquently
> > > than that).
> > > After the interview the senior manager at the
> > > interview said that he would
> > > not have anyone as self-obsessed and
> over-confident
> > > as that on board. I
> > > disagreed and said that what the contractor was
> > > offering was exactly what we
> > > wanted. We took him on and he fitted in very
> well.
> > > This story fits in with
> > > the concept of getting a coffee and thinking
> about
> > > things first, which is
> > > all about using your experience well.
> > >
> > > John
> > >
> > > Logica/ESIS Tel 0115 945 6643
> > >
> > > -----Original Message-----
> > > From: David A. Barbour
> > > [mailto:dbarbour_at_nucentrix.net]
> > > Sent: 03 May 2001 18:46
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Fwd: please help
> > >
> > > Jared,
> > >
> > > I think you hit the nail on the head when you
> said
> > > "Best
> > > practice of
> > > course is to make a backup of your database in
> > > it's current
> > > condition
> > > prior to restoring it."
> > >
> > > Too many recoveries are failures because DBAs
> tend
> > > to forget
> > > basics when
> > > confronted with the pressures from management,
> > > users, and
> > > the
> > > constraints of time (primary key). I made
> this
> > > mistake once
> > > early on.
> > > Now if I have a possible recovery scenario,
> the
> > > first thing
> > > I do is take
> > > a deep breath, get a cup of coffee, and THINK
> > > about what I'm
> > > going to do
> > > before I ever touch the keyboard.
> > >
> > > Absent all that, I still make a copy of the
> redo
> > > logs
> > > whenever I do a
> > > backup. Yeah, you could mess up and apply
> them
> > > inadvertently, but
> > > hopefully you will have practiced recovery
> > > scenarios (see
> > > "Training a
> > > DBA" by Kimberly Smith) and be comfortable
> with
> > > your tapes,
> > > disks,
> > > commands, systems administrator, etc. At
> least if
> > > you've
> > > got them, and
> > > everything goes to h*%$ in a handbasket, you
> can
> > > always give
> > > 'them' back
> > > something.
> > >
> > > David A. Barbour
> > >
> > >
> > > Jared Still wrote:
> > > >
> > > > Dick,
> > > >
> > > > Backing up the redo logs can have some
> serious
> > > consequences.
> > > >
> > > > Let's say you are restoring the database
> files,
> > > and a
> > > number of
> > > > archived logs to roll forward through.
> > > >
> > > > Following that, you are going to roll
> forward
> > > through all
> > > archived logs
> > > > that are still online, and then through your
> > > current redo
> > > logs for a
> > > > complete recovery.
> > > >
> > > > Restoring old redo logs would render this
> > > strategy
> > > ineffective.
> > > >
> > > > Backing them up can be a good thing, but it
> > > would be very
> > > easy
> > > > to inadvertently wipe out the current ones
> when
> > > restoring
> > > from tape.
> > > >
> > > > Best practice of course is to make a backup
> of
> > > your
> > > database in
> > > > it's current condition prior to restoring
> it.
> > > >
> > > > It would also be prudent to make copies of
> the
> > > redo logs
> > > locally
> > > > so you don't have to restore them from tape.
>
=== message truncated ===
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: stephane_paquette_at_yahoo.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).Received on Mon May 07 2001 - 10:28:10 CDT
 |
 |