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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
