OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Roolback Segment (Oracle 9i Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Roolback Segment [message #351081]

Mon, 29 September 2008 04:13

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

Report message to a moderator

Re: Roolback Segment [message #351099 is a reply to message #351081]

Mon, 29 September 2008 05:01

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: Roolback Segment [message #351105 is a reply to message #351099]

Mon, 29 September 2008 05:12

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

Report message to a moderator

Re: Roolback Segment [message #351116 is a reply to message #351105]

Mon, 29 September 2008 06:06

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Because you did not restart after setting the undo parameters.

Regards
Michel

Report message to a moderator

Re: Roolback Segment [message #351119 is a reply to message #351116]

Mon, 29 September 2008 06:37

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

Report message to a moderator

Re: Roolback Segment [message #351120 is a reply to message #351119]

Mon, 29 September 2008 06:41

Michel Cadot
Messages: 68666
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

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

Report message to a moderator

Re: Roolback Segment [message #351146 is a reply to message #351121]

Mon, 29 September 2008 09:20

Michel Cadot
Messages: 68666
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

Report message to a moderator

Previous Topic:	dropping index tablespace
Next Topic:	Copy ASM Files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 01:35:49 CDT 2024