RE: to undo or not to undo
- From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
- To: 'Barbara Baker ' <barbarabbaker@xxxxxxxxx>,"'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2004 10:37:23 -0600
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@xxxxxxxxxxxxx
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
__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
