ORA-01545 rollback segment ' string ' specified not available
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01545 from Oracle 10g ?
Either: 1) An attempt was made to bring a rollback segment online that is unavailable during startup; for example, the rollback segment is in an offline tablespace. 2) An attempt was made to bring a rollback segment online that is already online. This is because the rollback segment is specified twice in the ROLLBACK_SEGMENTS parameter in the initialization parameter file or the rollback segment is already online by another instance. 3) An attempt was made to drop a rollback segment that is currently online. 4) An attempt was made to alter a rollback segment that is currently online to use unlimited extents. 5) An attempt was made to online a rollback segment that is corrupted. This is because the rollback is specified in _corrupted_rollback_segments parameter in initialization parameter file.
How to deal with ORA-01545 from Oracle 10g ?
Either: 1) Make the rollback segment available; for example, bring an offline tablespace online. 2) Remove the name from the ROLLBACK_SEGMENTS parameter if the name is a duplicate or if another instance has already acquired the rollback segment. 3) Bring the rollback segment offline first. This may involve waiting for the active transactions to finish, or, if the rollback segment needs recovery, discover which errors are holding up the rolling back of the transactions and take appropriate actions. 4) Same as 3). 5) Remove the name from the _corrupted_rollback_segments parameter.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01537 cannot add data file ' string ' - file already part of database
- ORA-01538 failed to acquire any rollback segment
- ORA-01539 tablespace ' string ' is not online
- ORA-01540 tablespace ' string ' is not offline
- ORA-01541 system tablespace cannot be brought offline; shut down if necessary
- ORA-01542 tablespace ' string ' is offline, cannot allocate space in it
- ORA-01543 tablespace ' string ' already exists
- ORA-01544 cannot drop system rollback segment
- ORA-01546 tablespace contains active rollback segment ' string '
- ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below
- ORA-01548 active rollback segment ' string ' found, terminate dropping tablespace
- ORA-01549 tablespace not empty, use INCLUDING CONTENTS option
- ORA-01550 cannot drop system tablespace
- ORA-01551 extended rollback segment, pinned blocks released
- ORA-01552 cannot use system rollback segment for non-system tablespace ' string '
- ORA-01553 MAXEXTENTS must be no smaller than the string extents currently allocated