hm..... might be the fall 2002 meeting.....
- Henry Poras <Henry.Poras_at_ctp.com> wrote:
> Next time you're invited I'll be happy to show you the Necco factory.
> Henry
>
> -----Original Message-----
> Sent: Thursday, November 01, 2001 10:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dick,
>
> thank you -- how come I don't get invited to speak at NOUG anymore?
> :(
>
> Actually, I've decided that there should be a corollary to my Rule 0
> --
> while that backup is being made, go and have a cup of coffee and take
> a
> pad and paper with you and start to plan what to do.
>
> This presumes that you haven't already sat down and at least thought
> out what would happen in any given circumstance and planned for it :)
>
> I've found that whenever I just "rush in where angels fear to tread"
> I
> screw it up. Because I realize (as Barb did) that I should have done
> (or should not have done) something one second AFTER I hit the enter
> key.
>
> I like checklists. Hell, I LOVE checklists.
>
> I've submitted a presentation to IOUG - I hope they take it, as it
> may
> well be the last time I present, I'm thinking of hanging up my
> presenting shoes :)
>
> Rachel
>
> --- dgoulet_at_vicr.com wrote:
> > Barbara,
> >
> > Like Rachel I've been in the same place you are too, a couple
> of
> > times. In
> > every instance where I've been faced with recovering a database
> > and/or datafile
> > the worst part of the process is getting started. Namely figuring
> > out 1) what's
> > broke, 2) what do I have to fix it with, 3) where do I want to be
> in
> > the end.
> >
> > In a case similar to yours (the disk farm blew), we recovered
> the
> > previous
> > cold backup to a replacement system of the same type. The problem
> I
> > had was
> > that the cold backup was from the previous weekend and it was
> > Thursday with
> > somewhere around 100 archived redo logs to play with and the online
> > redo was
> > lost with the disk farm. The answer was simply to restore
> > everything, then
> > before starting the DB I copied the one remaining control file from
> > the old
> > system onto the new system, replacing all of the existing files
> with
> > this one.
> > Now the control files were all in sync with each other, but not
> with
> > the DB
> > files. When the DB was started it of course complained that it
> > needed recovery.
> > Recovered the DB with the 'until <datetime>' option so that I
> > consumed all of
> > the archived redo, but stopped short of the online redo, and reset
> > the logs. In
> > the end the DB opened normally with no problems, although it's
> uptime
> > was VERY
> > short, as I shut it down almost immediately and put a new backup of
> > what I had
> > in the safe.
> >
> > Once your over the initial sinking feeling in your stomach and
> > adrenaline
> > rush, it's a piece of cake. OH BTW, something we all should
> practice
> > every once
> > in a while. I know I do.
> >
> > Dick Goulet
> >
> > PS: if you get a chance, attend one of Rachel's presentations.
> It's
> > more than
> > well worth it. Actually change that to "make a chance".
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: dgoulet_at_vicr.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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Henry Poras
> INET: Henry.Poras_at_ctp.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).
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_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 Thu Nov 01 2001 - 14:37:57 CST