Home » RDBMS Server » Backup & Recovery » ORA-01595: error freeing extent (2) of rollback segment (6)) (Oracle, 9.2.0, HP-UX)
icon14.gif  ORA-01595: error freeing extent (2) of rollback segment (6)) [message #331949] Sun, 06 July 2008 22:02 Go to next message
youngb912
Messages: 47
Registered: October 2007
Location: New York
Member
Hello All,

I have an alert that I need help with. I have tried several recommendation but couldn't resolve it -
Sun Jul 6 13:02:57 2008
Errors in file /oracle/admin/prod/bdump/prod_smon_20893.trc:
ORA-01595: error freeing extent (2) of rollback segment (6))
ORA-01594: attempt to wrap into rollback segment (6) extent (2) which is being freed

I beleive there was no query running when this alert came. The database was just being brought online. Per Oracle documentation this can be safely ignore. I tried to ignore it but the error keep coming. No query is being ran. I need your help/recommendation. I don't have access to Metalink but was able to review the attached doc..

Oracle version---9.2
Undo Retention --900---increased this to 36000 but didn't help
Platform - ----HP-UX

Re: ORA-01595: error freeing extent (2) of rollback segment (6)) [message #331950 is a reply to message #331949] Sun, 06 July 2008 22:10 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

01594, 00000, "attempt to wrap into rollback segment (%s) extent (%s) which is being freed"
// *Cause:  Undo generated to free a rollback segment extent is attempting
//          to write into the same extent due to small extents and/or too
//          many extents to free
// *Action: The rollback segment shrinking will be rollbacked by the system;
//          increase the optimal size of the rollback segment.

01595, 00000, "error freeing extent (%s) of rollback segment (%s))"
// *Cause:  Some error occurred while freeing inactive rollback segment extents.
// *Action: Investigate the accompanying error.
Re: ORA-01595: error freeing extent (2) of rollback segment (6)) [message #332066 is a reply to message #331950] Mon, 07 July 2008 07:20 Go to previous messageGo to next message
youngb912
Messages: 47
Registered: October 2007
Location: New York
Member
I still can't get what is wrong with my posting. Please point it out for me. Thanks
Re: ORA-01595: error freeing extent (2) of rollback segment (6)) [message #332089 is a reply to message #331949] Mon, 07 July 2008 08:43 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
I suggest using UNDO to replace ROLLBACK & most likely this problem will no longer occur.
Previous Topic: privileges in using RMAN
Next Topic: how to recover data after it is deleted
Goto Forum:
  


Current Time: Fri Dec 02 20:33:04 CST 2016

Total time taken to generate the page: 0.08214 seconds