Rachel, My first rule on recoveries is to go get the cup of coffee after a walk around the building to cool off. It helps to drag along your SA so that you have an idea of what is stored out there on tape. BTW, I have the same problem with the <enter> key too. I also have the same LOVE for checklists. Violated that rule once, my co-workers refuse to allow facilities to fix the dent I put in the wall, one second after pushing that <enter> key!
OH, your invite is probably in the mail too. Dick Goulet ____________________Reply Separator____________________ Author: Rachel Carmichael <[EMAIL PROTECTED]> Date: 11/1/2001 7:51 AM 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 --- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).