In a couple days ago, I couldn't start the oracle database after imported. After check the log file located at $ORACLE_BASE/adminORCL/bdump/alert_ORCL.log, I got an error message:

ORA-01599: failed to acquire rollback segment (xx), cache space is full (currently has (xx) entries) Error 1599 happened during db open, shutting down database. (xx is certain number)

After check some reference, the root cause is the limitation of the parallel online rollback segments, the default size is 30. So, just add max_rollback_segments=50 or larger in the oracle database initial file, and then restart the database. Done.

After the database ready, you can query by select count(*) from dba_rollback_segs to get the precise amount of the rollback segments.

1 comment:

price per head said...

Hello, Such a wonderful blog i ever read. Please keep posting good blogs. Thank you very much...