SOLVED: RBS datafile recovery

From: Sujatha Madan <Sujatha.Madan_at_cmc.optus.net.au>
Date: Wed, 12 Feb 2003 19:43:41 -0800
Message-ID: <F001.0054B5E6.20030212194341@fatcity.com>

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
2. Open database
3. Create temporary rbs's
4. 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 Sujatha.Madan_at_cmc.optus.net.au
WEB http://www.optusbusiness.com.au/

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sujatha Madan
  INET: Sujatha.Madan_at_cmc.optus.net.au

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: 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.net
--

Author: Sujatha Madan
  INET: Sujatha.Madan_at_cmc.optus.net.au

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: 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 Wed Feb 12 2003 - 21:43:41 CST