Re: convert RBS tablespace from DMT to LMT (Oracle 8173) steps?

Hi!

The reason might be performance when rollback segments grow and shrink if optimal is set. (Of course if your RB segments are tuned well enough, that they won't ever grow or shrink, then DMT isn't an issue)

If you do the change in two passes as you described, which leave the same names for RB segments, then no init.ora modification is needed, as long as you have all the rollback segments in database which you have defined in init.ora.

Tanel.
----- Original Message -----
From: <Jared.Still_at_radisys.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 23, 2003 8:54 PM
Subject: Re: convert RBS tablespace from DMT to LMT (Oracle 8173) steps?

> Why are you converting an RBS tablespace?
>
> If just an exercise, it's understandable.
>
> If for a production database, just create a new tablespace, new rollback
> segments, and then drop the old ones.
>
>
> Jared
>
>
>
>
>
>
> "Guang Mei" <gmei_at_incyte.com>
> Sent by: ml-errors_at_fatcity.com
> 07/23/2003 10:24 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: convert RBS tablespace from DMT to LMT (Oracle
8173) steps?
>
>
> Hi:
>
> I need to convert RBS tablespace (used for rollback segments) from DMT to
> LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the
> steps I am thinking of taking:
>
> 1. create a new rbslmt tablespace
>
> 2. create new rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) in
> rbslmt ts , set them online
>
> 3. alter all old rollback segments (RBS01, ... RBS06) offline;
>
> 4. Drop all old rollback segments;
>
> 5. alter old RBS tablespace offline
>
> 6. Drop old RBS tablespace
>
> 7. Remove old RBS tablespace's datafiles from OS
>
> 8. Create new RBS tablespace as LMT
>
> 9. Create new rollback segments (RBS01, ... RBS06) in RBS, set them
> online;
>
> 10. alter rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) offline,
> then drop them;
>
> 11. alter tablespace rbslmt offline
>
> 12. drop tablespace rbslmt
>
> 13. Remove tablespace rbslmt's datafiles from OS.
>
> Anything I am missing?
>
> TIA.
>
> Guang
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Guang Mei
> INET: gmei_at_incyte.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:
> INET: Jared.Still_at_radisys.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
Received on Wed Jul 23 2003 - 12:22:35 CDT