Re: Conversion from 8i Manual Undo Management to 10g Automatic Undo Management

bfogarty_at_gaports.com wrote:
> I am the DBA responsible for upgrading several databases from Oracle
> Server 8i to 10g on a UNIX AIX machine. In 8i the databases use the old
> configuration of a rollback segment tablespace and multiple user
> defined private rollback segments.
>
> I have read the 10g literature on automatic undo management and want to
> migrate from 8i rollback segments to 10g undo management. I do not
> understand the sequence of steps to accomplish the change.
>
> I plan to do a manual upgrade. My 8i rollback segment tablespace (RBS)
> is 1.5 GB. I have eight private rollback segments (RBS1, ...., RBS8)
> each of which is optimally 150 MB.
>
> I know I will eventually set init.ora parameter undo_management=auto
> and execute a "CREATE UNDO TABLESPACE undotbs1......." command. I
> understand function DBMS_UNDO_ADV.RBU_MIGRATION is a 10g tool that will
> help me size the new tablespace.
>
> Should I do my manual 8i to 10g upgrade and temporarily retain the old
> rollback segments, then create the new undo tablespace, drop the old
> rollback segments and tablespace, and cycle the database with
> undo_management=auto
> or ..... do I somehow make the change in the middle of the upgrade?
>
> Has anyone done this 8i to 10g undo change before? If so, what steps
> did you take?
>
> Does anyone know of an Oracle document that describes the steps to
> take?
>
> Thank you,
> Bill Fogarty
> DBA, Georgia Ports Authority
>

After you have migrated from 8i to 10g, create an undo tablespace:

CREATE UNDO TABLESPACE undotbs
DATAFILE '/dir/orcl/undotbs01.dbf' SIZE ....;

Then set your INIT params in your spfile:

ALTER SYSTEM SET undo_tablespace=undotbs SCOPE=SPFILE;
ALTER SYSTEM SET undo_rentention=900 SCOPE=SPFILE;
ALTER SYSTEM SET undo_management=AUTO SCOPE=SPFILE;

Bounce your instance...it will now be using Automated Undo Management. At this point, you can remove the ROLLBACK_SEGMENTS parameter from the parameter file. You can drop your old rollback segments and the tablespace they used to live in.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown