John,
First things first, if you offline a RBS while it's in use you won't cancel
those transactions. The RBS will support current transactions until they
commit, then when it's not in use it'll go offline.
Assuming you're pre-9i you should :
- create the new TS.
- create the new rollbacks.
- online the new rollbacks.
- offline the old rollbacks.
- once any deferred 'offlines' are completed drop the old rollback
segments and drop the old tablespace.
- remove the OS datafile for the old rollbacks.
- alter your init.ora to reflect the new rollback names.
If you're using 9i you might like to investigate system-managed undo.
HTH,
Mike Hately
-----Original Message-----
From: John DeUnger [mailto:[Email Address Removed] Thursday, October 31, 2002 12:33 PM
To: LazyDBA.com Discussion
Subject: resizing rollbacks - order of things
I am a little puzzled. I need to resize my rollbacks. I was thinking
of creating a new table space with the new rollback sizes, How do
you take the old rollbacks off line 1) while users are still on the system
and might be using them ? 2) My init.ora states what the rollback names
are
I thought at first, I could create the new tablespace and segments, and then
put them on line, by doing this, then Oracle knows about the table space
by the alter database command. so ideally Oracle now has 2 table spaces
RBS and BIG_RBS and the associated rollbacks, would you just start taking
off the rollbacks in RBS until they were all off line, and then take the
tablespace
off line ? leaving only the new BIG_RBS ?
I thought I read, by taking a rollback segment off line, while users were
still
connected to it, that you killed that process is this true ? How could you
prevent this ? This is a production system and when I show transactions
they change constantly as to what rollback is being used.
Thanks for the clarification.
John DeUnger.
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page