Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the
steps I am thinking of taking:
1. create a new rbslmt tablespace
2. create new rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) in
rbslmt
Guang - Don't forget to update your init.ora!
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 23, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Hi:
I need to convert RBS tablespace (used for rollback segments)
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:convert RBS tablespace from DMT to LMT (Oracle 8173) steps?
Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 production
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:convert RBS tablespace from DMT to LMT (Oracle 8173)
steps?
Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 production machine (Solaris 2.8
Do I need to? I thought after all the steps I still have the same rollback
segment names (RBS01-06). The only difference is they will be in LMT now.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Guang - Don't
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online the
new segments, offline the old segments, then change the init.ora. Sometime
later I would drop the old segments and tablespace, maybe after a
I see. Thanks.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online
: convert RBS tablespace
from DMT to LMT (Oracle 8173) steps?
ml-errors
Oracle will not let you drop a rollback segment if there are active transactions using
it. However, it will allow you to offline the segment and no new transactions can use
it. I don't recall the exact status in v$rollstat, but I think it may say pending
offline.
As for the commit across
I just finished this conversion by using Ron's method: looping through
RBS00X (X from 1 to 6):
alter rollback segment RBS00X offline;
drop rollback segment RBS00X;
create rollback segment RBS00X storage(initial 2048K next 2048K minextents
2 ) tablespace RBSlmt;
alter rollback segment RBS00X
:
Sent by: Subject: Re: convert RBS tablespace
from DMT to LMT (Oracle 8173) steps?
ml-errors
Hi, guang:
I have two questions:
1. Why create rbs on lmt tablespace and later drop it again? Just do
step 1-7 and it is ok. Or maybe you need to update your init file, but you
can also offline old rbs01 and create new rbs01 on lmt, and so on.
2. If you have dmt rollback segment in
Hi!
Great you got everything working fine.
Just a note, that in truly high available systems, it's reasonable to wait
until all long-running queries, which were started before offlining rollback
segments, have ended before you actually drop the offlined rollback
segments. Oracle is able to read
On Wed, 23 Jul 2003, zhu chao wrote:
Hi, guang:
I have two questions:
1. Why create rbs on lmt tablespace and later drop it again? Just do
step 1-7 and it is ok. Or maybe you need to update your init file, but you
can also offline old rbs01 and create new rbs01 on lmt, and so on.
14 matches
Mail list logo
