Re: 1 minutes: best downtime story

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Wed, 27 Mar 2013 23:33:28 +0800
Message-ID: <CAMNBsZsccaE4RxQrKrH1jUGWoVhHH=yXmvadyxe0vx=SV6pKBQ_at_mail.gmail.com>

An induced outage by me
Non-mission critical database running an enterprise portal. I am reorganising the online redo logs.
ALTER DATABASE CREATE LOGFILE
ALTER DATABASE DROP LOGFILE
rm redo01.dbf

running it in a cycle.

Oops. I did an rm redo04.dbf that was ACTIVE. (Fortunately, not CURRENT). Wasn't confident that a CLEAR LOGFILE would fix it so did a quick SHUTDOWN and STARTUP.
The shutdown/startup wasn't noticed but I did send an email to the Portal manager that I had restarted the database.

Hemant K Chitale

On Fri, Mar 15, 2013 at 5:07 AM, Jeremy Schneider < jeremy.schneider_at_ardentperf.com> wrote:

> Hey all -
>
> I'm writing a paper about top causes of downtime. As one component
> of research, I'd like to get some input from you!
>
> One minute, two sentences. First sentence: describe what went down.
> Second sentence: describe why. (I have to categorize all of these.)
> Everyone should have at least one downtime story so I'm hoping for a
> lot of feedback!
>
> Answer about any technology - database, operating system, etc.
>
> Thanks!
>
> -Jeremy
>
>
> --
> Jeremy Schneider
> Pythian Consulting Group
> Chicago
>
> +1 312-725-9249
> http://www.pythian.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 27 2013 - 16:33:28 CET