I have an Oracle 10g database which has had a torrid time of late. Originally a filesystem error caused a corruption of the redo log files which I seem to have worked my way around. After some further recovery of datafiles etc I am now experiencing the following error when attempting to open the database:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
In the alert log I see the following:
Tue Jul 10 09:42:23 2007
alter database open
Tue Jul 10 09:42:23 2007
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Tue Jul 10 09:42:24 2007
Started redo scan
Tue Jul 10 09:42:24 2007
Completed redo scan
58 redo blocks read, 9 data blocks need recovery
Tue Jul 10 09:42:24 2007
Started redo application at
Thread 1: logseq 6, block 3
Tue Jul 10 09:42:24 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 6 Reading mem 0
Mem# 0 errs 0: /data2/oracle/psldev/redo02.log
Tue Jul 10 09:42:24 2007
Completed redo application
Tue Jul 10 09:42:24 2007
Completed crash recovery at
Thread 1: logseq 6, block 61, scn 847522
9 data blocks read, 9 data blocks written, 58 redo blocks read
Tue Jul 10 09:42:25 2007
Thread 1 advanced to log sequence 7
Thread 1 opened at log sequence 7
Current log# 3 seq# 7 mem# 0: /data2/oracle/psldev/redo03.log
Successful open of redo thread 1
Tue Jul 10 09:42:25 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jul 10 09:42:25 2007
SMON: enabling cache recovery
Tue Jul 10 09:42:26 2007
Successfully onlined Undo Tablespace 1.
Tue Jul 10 09:42:26 2007
SMON: enabling tx recovery
Tue Jul 10 09:42:26 2007
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is WE8ISO8859P1
Threshold validation cannot be done before catproc is loaded.
Tue Jul 10 09:42:28 2007
Errors in file /opt/oracle/admin/psldev/bdump/psldev_smon_12836.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4193] [421] [437]
Tue Jul 10 09:42:28 2007
Errors in file /opt/oracle/admin/psldev/udump/psldev_ora_12850.trc:
ORA-00600: internal error code, arguments: [4194], [3], [10], [], [], [], [], []
DEBUG: Replaying xcb 0x2b132080, pmd 0x2b2c9458 for failed op 8
Doing block recovery for file 2 block 269
No block recovery was needed
Tue Jul 10 09:42:29 2007
Errors in file /opt/oracle/admin/psldev/udump/psldev_ora_12850.trc:
ORA-00600: internal error code, arguments: [4194], [3], [10], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [3], [10], [], [], [], [], []
Tue Jul 10 09:42:29 2007
Doing block recovery for file 2 block 251
Block recovery from logseq 7, block 55 to scn 847581
Tue Jul 10 09:42:29 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 7 Reading mem 0
Mem# 0 errs 0: /data2/oracle/psldev/redo03.log
Block recovery stopped at EOT rba 7.56.16
Block recovery completed at rba 7.56.16, scn 0.847578
Doing block recovery for file 2 block 89
Block recovery from logseq 7, block 55 to scn 847577
Tue Jul 10 09:42:29 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 7 Reading mem 0
Mem# 0 errs 0: /data2/oracle/psldev/redo03.log
Block recovery completed at rba 7.56.16, scn 0.847578
Tue Jul 10 09:42:29 2007
Errors in file /opt/oracle/admin/psldev/bdump/psldev_smon_12836.trc:
ORA-00604: Message 604 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-00607: Message 607 not found; No message file for product=RDBMS, facility=ORA
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4193] [421] [437]
Tue Jul 10 09:42:30 2007
Errors in file /opt/oracle/admin/psldev/udump/psldev_ora_12850.trc:
ORA-00600: internal error code, arguments: [4194], [3], [10], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [3], [10], [], [], [], [], []
Tue Jul 10 09:42:31 2007
Errors in file /opt/oracle/admin/psldev/bdump/psldev_smon_12836.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [10] [14]
Doing block recovery for file 2 block 1663
Block recovery from logseq 7, block 56 to scn 847584
Tue Jul 10 09:42:31 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 7 Reading mem 0
Mem# 0 errs 0: /data2/oracle/psldev/redo03.log
Block recovery stopped at EOT rba 7.57.16
Block recovery completed at rba 7.57.16, scn 0.847583
Doing block recovery for file 2 block 9
Block recovery from logseq 7, block 56 to scn 847582
Tue Jul 10 09:42:31 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 7 Reading mem 0
Mem# 0 errs 0: /data2/oracle/psldev/redo03.log
Block recovery completed at rba 7.57.16, scn 0.847583
Tue Jul 10 09:42:31 2007
Errors in file /opt/oracle/admin/psldev/bdump/psldev_smon_12836.trc:
ORA-01595: Message 1595 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1]
ORA-00607: Message 607 not found; No message file for product=RDBMS, facility=ORA
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arg
uments: [4194] [10] [14]
Tue Jul 10 09:43:30 2007
DEBUG: Replaying xcb 0x2b132080, pmd 0x2b2c9458 for failed op 8
Doing block recovery for file 2 block 269
No block recovery was needed
Tue Jul 10 09:43:30 2007
Errors in file /opt/oracle/admin/psldev/bdump/psldev_pmon_12824.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [3] [10]
Tue Jul 10 09:43:30 2007
Errors in file /opt/oracle/admin/psldev/bdump/psldev_pmon_12824.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [3] [10]
PMON: terminating instance due to error 472
Instance terminated by PMON, pid = 12824
Despite extensive searching of this forum and the wider Internet I have not been able to identify a solution to this problem.
Can anyone help?