Archive Log Notes
Shutdown abort followed by server reboot
Database startup fails with the following errors:
ORA-01545: rollback segment ‘%s’ specified not available
ORA-01596: error freeing extent (%s) of rollback segment (%s))
ORA-00376: file %s cannot be read at this time
The database in archive log mode was shutdown abort before the server was rebooted.
The cause of this problem is still undetermined, but the following solution worked:
- Shutdown the database immediate.
- Edit the init.ora file and remove or comment out the problem rollback segment from the list of rollback segments in the ROLLBACK_SEGMENTS parameter.
- Startup the database.
startup mount;
- Find out which one of the files needs recovery by running the following statement:
select * from v$recover_file;
- Alternatively, you can also query v$datafile.
- Find out which rollback segments need recovery by running the following statement:
select usn, status from v$rollstat where status != ‘ONLINE’;
