Home » RDBMS Server » Server Administration » Roolback Segment (Oracle 9i Windows 2003)
Roolback Segment [message #351081] Mon, 29 September 2008 04:13 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

My undo segement goes offline automatically however my Undo management is auto & i am getting the following error.

======================================================
ORA-01552: cannot use system rollback segment for non-system
tablespace Inventory
==========================================================

Can you guide why it is so if my undo managment is auto

kindly suggest

Thanks
Re: Roolback Segment [message #351099 is a reply to message #351081] Mon, 29 September 2008 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01552: cannot use system rollback segment for non-system tablespace '%s'
 *Cause: Tried to use the system rollback segment for operations involving
          non-system tablespace. If this is a clone database then this will
        happen when attempting any data modification outside of the system
        tablespace. Only the system rollback segment can be online in a
        clone database.
 *Action: Create one or more private/public segment(s), shutdown and then
           startup again. May need to modify the INIT.ORA parameter
           rollback_segments to acquire private rollback segment. If this is
         a clone database being used for tablspace point in time recovery
         then this operation is not allowed.  If the non-system tablespace
         has AUTO segment space management, then create an undo tablespace.

Regards
Michel
Re: Roolback Segment [message #351105 is a reply to message #351099] Mon, 29 September 2008 05:12 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi

This is not a clone database even i have already created the undo tablespace with auto mamagement.

Even my problem is solved after restarting the server.

But still i am confuse why it was happened if undo management auto


kindly suggest
Re: Roolback Segment [message #351116 is a reply to message #351105] Mon, 29 September 2008 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you did not restart after setting the undo parameters.

Regards
Michel
Re: Roolback Segment [message #351119 is a reply to message #351116] Mon, 29 September 2008 06:37 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
I have not created the new database. It was running fine from last 6month today i got the same problem which is solved after restatring the database.

Actualy i want know is there any scenario in which rollback segment can be offline if undo management in auto?




Kindly Suggest


Re: Roolback Segment [message #351120 is a reply to message #351119] Mon, 29 September 2008 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, there is none if YOU don't change anything.

Regards
Michel

[Updated on: Mon, 29 September 2008 06:41]

Report message to a moderator

Re: Roolback Segment [message #351121 is a reply to message #351120] Mon, 29 September 2008 06:43 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi

Actually this is creating the confusion why the rollback segment got offline automaticaly


kindly suggest
Re: Roolback Segment [message #351146 is a reply to message #351121] Mon, 29 September 2008 09:20 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are not (I think you're talking about old rollback segments and not undo ones).

Regards
Michel
Previous Topic: dropping index tablespace
Next Topic: Copy ASM Files
Goto Forum:
  


Current Time: Tue Dec 06 16:26:22 CST 2016

Total time taken to generate the page: 0.08346 seconds