Error:
During the execution of the cleanup job, we are seeing this error in the logs (LogsArchiveAndCleanUp.log)
> 2016-04-05 09:55:42,691 ERROR [main] Log clean up
> db.DatabaseUtil.executeDeleteQuery(Unknown Source) - Unable to perform
> clean-up for table "AU_TRANSACTIONLOG"
>
> java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo
> tablespace 'UNDOTBS1'
How much space should be reserved for the undo tablespace to avoid this error?
Cause:
The "undo Tablespace"size is completely occupied or the size for "AU_TransactionLog" is very large
Solution:
Set the size of "undo tablespace" to auto-extend in the Database. Here's more information
- https://community.oracle.com/thread/664211?start=0&tstart=0
- http://docs.oracle.com/cd/E24693_01/server.11203/e17120/undo004.htm
Comments
0 comments
Article is closed for comments.