| 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
Suji,
Thanks -- I'm always interested in recovery "war stories"
Rachel
--- Sujatha Madan <Sujatha.Madan_at_cmc.optus.net.au> 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 <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).
> >
>
>
> __________________________________________________
> 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: 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).
>
-- 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).Received on Thu Feb 13 2003 - 14:55:25 CST
 |
 |