Component : Database Administration with Oracle -

Solution : https://service.sap.com/sap/support/notes/4190 (SAP Service marketplace login required)

Summary :
The SAP Note identifies issues with rollback segments (Rbs) showing "NEEDS RECOVERY", corrupted data blocks (ORA1578), and unavailable Rbs (ORA1545). Causes include offline data files or defects in rollback segments. Solutions entail verifying files in V$DATAFILE, setting affected files ONLINE, and handling Rbs via SQL commands or adjustments in init.ora. Procedures are outlined for different symptoms, focusing on ensuring Rbs' ONLINE status, or removal and re-creation if defects persist. Recommendations include maintaining data consistency, even when Rbs are temporarily offline through parameters in init.ora.

Key words :
reset n1 additional key words, restart db                    -> end   - error      -> step 4, oracle data block corrupted, start db- successful -> delete, ora -> end- error      -> step 3, rollback segment affects data, online -> end- error, reset init<sid>, rollback segment '%s', onlineorthe rollback segment

Related Notes :

365481	Block corruptions
328785	ORA-00376: File cannot be read at this time
43490	Collective note: SAPDBA - Restore/recovery