Suji, Thanks -- I'm always interested in recovery "war stories"
Rachel --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Rachel, > > In the end it really didn't turn out to be much of a "solution" > because I > ended up losing data. My initial aim was to recover everything > without > losing data (isn't it always?)... Anyway, I am trying to recreate the > initial situation and then I am going to try and find a proper > solution for > it. > > I'll post it up when it works. Also, I found DOC ID: 1013221.6 > "Recovering > from a lost datafile in a rollback tablespace" extremely useful. > > Regards > Sujatha > > -----Original Message----- > Sent: Thursday, 13 February 2003 9:54 PM > To: Multiple recipients of list ORACLE-L > > > Suji, > > When you post a question and figure out the answer, please tell us as > well so we don't have to reinvent the wheel should it ever happen to > us! > > Rachel > --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > > I think I've figured it out and now I have more info (after > > researching a > > bit more) to solve it. > > > > Sorry for the bother > > > > Cheers > > Sujatha > > > > -----Original Message----- > > Sent: Thursday, 13 February 2003 10:49 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > Hi, > > > > I am doing some recovery testing and am testing the "corruption" of > > the rbs > > datafile. However, I am running into some problems. > > > > What I've done so far: > > > > 1) Shutdown db > > 2) Copied the backup datafile to proper location > > 3) Commented the rollback_segments parameter in the init.ora > > 4) startup mount > > 5) Took the rbs datafile offline. > > 6) Tried to open the database. > > > > When I open the database, I thought it is meant to open "cleanly" > > because I > > have taken the datafile offline. However, the db refuses to open > and > > says > > that the rbs datafile needs media recovery. When I query v$datafile > > it shows > > the status as "Recover". Is it meant to show a status of > "Offline"??? > > > > Now I can't get the db to open. I have done this kind of recovery > > before and > > I remember that the steps involved are: > > > > 1) to 5) as above > > 6) Open database > > 7) Create temporary rbs's > > 8) Recover RBS tablespace > > > > Could some one please help me with this problem? ... or am I doing > > something > > totally wrong ??? > > > > Oracle: 8.1.7 on W2K ... Test db and machine only. > > > > Cheers, > > Sujatha > > > > > > ------------------------------------------- > > Sujatha Madan > > Database Administrator > > Custom Management Centre > > Optus Business Operations > > 'yes' OPTUS > > PH # +61 2 9775 9868 > > Mobile # +61 402 354 347 > > FAX # +61 2 9775 9510 > > Email [EMAIL PROTECTED] > > WEB http://www.optusbusiness.com.au/ > > ------------------------------------------- > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Sujatha Madan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting > services > > > --------------------------------------------------------------------- > > 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.net > > -- > > Author: Sujatha Madan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting > services > > > --------------------------------------------------------------------- > > 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!? > Yahoo! Shopping - Send Flowers for Valentine's Day > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net > -- > Author: Sujatha Madan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
