RE: to undo or not to undo
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2004 11:27:36 -0600
Barbara - Another thought for you. Avoid migration. Unless the database is
incredibly large and your downtime window is impossibly small. Create a
fresh 9i instance, and export/import the data. That is my preference. Either
way, be sure to test your process beforehand.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: Barbara Baker [mailto:barbarabbaker@xxxxxxxxx]
Sent: Wednesday, February 25, 2004 10:27 AM
To: oracle-l@xxxxxxxxxxxxx
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:
