RE: Update: Deferred Rollback Segments
- From: Pete Sharman <peter.sharman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 12 May 2004 09:28:38 +1000
My thoughts are you're 100% correct. Deleting from seg$ is not supported. =
:)
=
Pete
=
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
=
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] =
On Behalf Of Tracy Rahmlow
Sent: Wednesday, 12 May 2004 6:40 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Update: Deferred Rollback Segments
I traced the row entries back to the sys.seg$ table and successfully =
deleted all deferred rollback entries (type#=3D2) on a test database. Afte=
r =
this step we were able to convert the system tablespace from DM to LM. I =
doubt that this method is supported, but I am going back to Oracle to =
discuss it further. In addition, the segment names within dba_segments =
are named something like 1.24146. Is this a segment that we should be =
able to find somewhere in the database? I am wondering if the sys.seg$ =
table was corrupt in that it may be referring to segments that don't =
actually exist. Ok, I am going back in for some more. Please let me =
know your thoughts. Thanks
Tracy Rahmlow@AMEX
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
05/11/2004 10:05 AM
Please respond to oracle-l
=
To: oracle-l@xxxxxxxxxxxxx
cc: =
Subject: Deferred Rollback Segments - Help!
We have upgraded from 8.1.7.4 to 9.2.0.5 on AIX 5.1 and converted to
automated undo. All tablespaces are locally managed except for system.
During the conversion of the system tablespace from DMT to LMT we receive
an ORA-03113. We have filed a TAR and Oracle states that we have deferred
rollback segments that were never applied or never removed after
application. (specifically to the user_data tablespace). All of our
tablespaces are online including user_data. Their solution is to create a
new database and import all the data to the new database due to the
"corruption". I have researched several other databases and we have an
additional 20+ databases with deferred rollback segments within the system
tablespace. (these databases do not have any offline tablespaces either)
Here is the query I ran:
select * from dba_extents where segment_type =3D 'DEFERRED ROLLBACK';
Has anyone experienced something similar? Any ideas on why we would have
so many databases with this issue? I am not crazy about rebuilding 20+
databases. Is there a way to remove these segments? Here is Oracle's
explanation which was included in the tar:
A "Deferred Rollback" segment is created for a tablespace when a
tablespace is taken offline. Undo records are written to the deferred
rollback segment of a tablespace when undo is being applied to a
tablespace which is offline, hence, the undo cannot be applied.
The undo stored in the deferred rollback segment is applied when the
tablespace comes back online. The deferred rollback segment
is automatically removed after the undo has been applied.
Deferred rollback segments always reside in the system tablespace.
Please help! Thanks
American Express made the following
annotations on 05/11/2004 08:04:54 AM
---------------------------------------------------------------------------=
---
***************************************************************************=
***
"This message and any attachments are solely for the intended recipient =
and may contain confidential or privileged information. If you are not the =
=
intended recipient, any disclosure, copying, use, or distribution of the =
information included in this message and any attachments is prohibited. If =
=
you have received this communication in error, please notify us by reply =
e-mail and immediately and permanently delete this message and any =
attachments. Thank you."
***************************************************************************=
***
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
----------------------------------------------------------------
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
-----------------------------------------------------------------
American Express made the following
annotations on 05/11/2004 01:40:28 PM
---------------------------------------------------------------------------=
---
***************************************************************************=
***
"This message and any attachments are solely for the intended recipien=
t and may contain confidential or privileged information. If you are not th=
e intended recipient, any disclosure, copying, use, or distribution of the =
information included in this message and any attachments is prohibited. If=
you have received this communication in error, please notify us by reply e=
-mail and immediately and permanently delete this message and any attachmen=
ts. Thank you."
***************************************************************************=
***
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
----------------------------------------------------------------
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:
