| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SOLVED: RBS datafile recovery
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 <Sujatha.Madan_at_cmc.optus.net.au> 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 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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com 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 Thu Feb 13 2003 - 14:04:25 CST
 |
 |