We have a couple of dba's on this. Every time we try to open the database we get:

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

The alert log has the following entries:-
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup cont...
Wed Oct 13 05:01:28 2004
ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG'
Wed Oct 13 05:01:28 2004
Media Recovery Log E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG
Incomplete recovery applied all redo ever generated.
Recovery completed through change 14491308
Media Recovery Complete
Completed: ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADA
Wed Oct 13 05:02:38 2004
alter database open resetlogs
Wed Oct 13 05:02:38 2004
RESETLOGS after complete recovery through change 14491308
Resetting resetlogs activation ID 3724171580 (0xddfa593c)
Online log 1 of thread 1 was previously cleared
Wed Oct 13 05:02:48 2004
Online log 3 of thread 1 was previously cleared
Wed Oct 13 05:02:51 2004
Assigning activation ID 3724197347 (0xddfabde3)
Thread 1 opened at log sequence 1
Current log# 2 seq# 1 mem# 0: E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG
Successful open of redo thread 1.
Wed Oct 13 05:02:52 2004
SMON: enabling cache recovery
Wed Oct 13 05:02:52 2004
Errors in file c:\oracle\admin\train1\udump\train1_ora_2312.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists

Wed Oct 13 05:02:52 2004
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Wed Oct 13 05:02:52 2004
Errors in file c:\oracle\admin\train1\bdump\train1_pmon_2636.trc:
ORA-00704: bootstrap process failure