| 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: to undo or not to undo
Barb:
We moved our SAP system to 9i last year, and are just now evaluating the movement of Rollback segments to UNDO segments. SAP has a very nice note titled "Oracle 9i: Automatic UNDO Management", and it describes a method of switching over while on-line. Yikes!
I did not try that, but I did use this doc as a guide for implementing Automatic UNDO.
I will send you a copy outside of the list. It's 13 printed pages long.
Cheers,
Mike
-----Original Message-----
From: Barbara Baker [mailto:barbarabbaker_at_yahoo.com]
Sent: Wednesday, February 25, 2004 8:27 AM
To: oracle-l_at_freelists.org
Subject: to undo or not to undo
Howdy, list.
For those of you who migrated a database from 8i to
9i, did you move convert to undo tablespace
immediately? Did you run for awhile still using
rollback segments then convert later? Any gotcha's?
I cannot find a concise doc on how to change over. (I'm using notes from Kirti's excellent RMOUG presentation on "Understanding Automatic Undo.." but I've already forgotten stuff.)
Here are the steps I know. What I do not know is when to remove my rollback segments. If I add the undo params to init then bounce the db, can I then offline the rbs segs and tablespace after I come back up? Or do I offline them before I bounce the db?
Anyone know of a doc that outlines this stuff?
Thanks for any help.
Solaris 9 Oracle 9.2.0.4
Barb
(here's what I think I need to do)
Changing Rollback Segments to Undo
set compatible 9.0.0 in init (currently 8.1.7.4)
create undo tablespace
create undo tablespace undotbs1
datafile '/class17db/u01/undotbs1.dbf'
size 500m;
insert init parameters
undo_management=AUTO undo_retention=10800 undo_tablespace=UNDOTBS1 undo_suppress_errors=TRUE
shut down and restart database
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |