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