Posts tagged: ORA-01595: error freeing extent (3) of rollback segment (1))

Feb 04 2010

ORA-01595: error freeing extent (3) of rollback segment (1))

Error Message:
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (1))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [6179], [6757], [], [], [], [], []

Suggested Fix:
Recreate Undo Tablespace

1. Create the new undo tablespace.

create UNDO tablespace UNDO2 datafile ‘/UNDO201.dbf’ size 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 500M;

2. Assign New Undo Tablespace to Everyone

alter system set undo_tablespace = ‘UNDO2′ ;

3. drop old undo table space (might have to wait for all sessions holding space in old undo to leave)

drop tablespace including contents cascade constraints;

before Recreating please check whether any data files is in recovery mode and the data files using DBV (DB Verify)

Alibi3col theme by Themocracy