Re: 1 minutes: best downtime story
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: jeremy.schneider@xxxxxxxxxxxxxx
- Date: Wed, 27 Mar 2013 23:33:28 +0800
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@xxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l
Other related posts:
