Re:How can I get my DB back if I lost one of my rollback seg

From: <dgoulet_at_vicr.com>
Date: Tue, 14 Aug 2001 08:37:25 -0700
Message-ID: <F001.00369AC8.20010814065539@fatcity.com>

Hermanto,

    That depends on whether your using public or private rollback segments. Personally I prefer private just for this reason. So, assuming your using private rollback segments:

1. shutdown your DB.
2. comment our the ROLLBACK_SEGS parameter in INIT.ora
3. startup mount the DB
4. alter database datafile 'rbs02.dbf' offline drop;
5. alter database open;
6. drop tablespace rbs including contents;
7. create tablespace rbs datafile 'rbs01.dbf' size <>;
8. create rollback segment <>;
9. repeat step 8 as often as desired.
10. shutdown db
11. uncomment ROLLBACK_SEGS parameter in init.ora, edit the values as required.
12. restart DB
13. coffee time.

DickG.

____________________Reply Separator____________________
Author: Hermanto P <hermanto_p_at_aprilasia.com>
Date:       8/14/2001 12:35 AM

Hi gurus,
Recently, I have forgotten to backup one of rollback segment file (rbs02.dbf).
When I want to restore..the db can not startup normally. Anyone can give me advise..
Thanks in advance.

Warm regards,
Hermanto
--

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

Author: Hermanto P
  INET: hermanto_p_at_aprilasia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author:
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Tue Aug 14 2001 - 10:37:25 CDT