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).