| 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
I discuss this in my Oracle9i New Features book.... Bottom line is that you
create the undo tablespace, change the parameters, bounce the database (in
this case, I'd suggest *not* using a shutdown abort) and walah! You are
using automated undo. You do have to cycle the database to do this though,
its not dynamic. Once you are using automated undo, you should be able to
remove your other rollback segments.
HTH Robert
-----Original Message-----
From: Barbara Baker
To: oracle-l_at_freelists.org
Sent: 2/25/2004 10:27 AM
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
 |
 |