I have been handed an Oracle DB server in the following miserable state of neglect :
Version: v. 220.127.116.11.0
It will not start up due the following:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 2, block # 784)
ORA-01110: data file 2: '/u02/oradata/(dbinstance)/rbs01.dbf'
- The Db was in noarchivelog mode
- There is no valid backup for the rbs01.dbf datafile
- The only redo log is a single 512 K log, no archived logs.
The goal requested of me is to restore this DB to running order without loss of application data files which are all intact.
Of course I have poured over all Oracle manuals, sites,etc - but in every case they seem to bail on fixes just shy of this near "worst case scenario."
I'd rather tell them to use their server for a boat anchor, but as we all know, we can rarely do that in the real world...
Before feed some fish with your piece of hardware, try This Appoach .
It might help you to get back your database. And before you even decide to do it, make backup of the database and store it away from the files on which will try any recovery. This way you will not loose whatever is left from the database.