So I recently had some corruption, that forced a rebuild. At that time i upgraded to my current release of 9.2.4 (stable in production for a time and I know it's not the latest greatest).
So reloaded data, started loading more, things were good, several reboots etc no issues.
This morning the system crashed again (so there may be some hardware issues). But for now I need again ask if there is something in code I can do vs a complete rebuild again.
014-02-26 07:09:16 PST LOG: database system was interrupted while in recovery at 2014-02-26 07:05:09 PST
2014-02-26 07:09:16 PST HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2014-02-26 07:09:16 PST LOG: database system was not properly shut down; automatic recovery in progress
2014-02-26 07:09:16 PST LOG: redo starts at 9A/89505268
2014-02-26 07:09:16 PST WARNING: specified item offset is too large