Urgently need help on: "Cannot Open Oracle DB when startup"

From: Pearapon S. <pearapon_at_ksc.th.com>
Date: Thu, 21 Jun 2001 00:44:41 +0700
Message-ID: <9gqntt$p48$1@taliesin.netcom.net.uk>

Hi All,

    I need help on recovery Data from Oracle DB on SUN Solaris. Recently,there are some problems with our Oracle DB. Here is the situation:

    While we were batch inserting Data into Oracle DB, there was a core dump on the system that force to Oracle DB down. When I shutdowned the system and up again. The Oracle can be startup and can mount DB. But It cannot OPEN DB and got out of the script to Unix prompt. After that I checked the "alert.log" file and found out that there was "core dump" while the Oracle was trying to recover "redo log" file. Please help us. We need to bring up Oracle back to normal as soon as possible. Please......  Thank you very much in advance

Best Regards,
Pearapon Saerekul
pearapon_at_ksc.th.com

Here are some lines I got from the "alert.log" file:

---

Wed Jun 20 12:45:39 2001
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 1 Seq 9301 Reading mem 0   Mem# 0 errs 0: /usr3/rd41/dbs/log1rd41.dbf Wed Jun 20 12:45:52 2001
Errors in file
/usr1/oracle74/app/oracle/product/7.3.4/rdbms/log/rd41_ora_4248.trc:
ORA-00600: internal error code, arguments: [4555], [], [], [], [], [], [], []
Wed Jun 20 12:45:54 2001
Errors in file
/usr1/oracle74/app/oracle/product/7.3.4/rdbms/log/rd41_ora_4248.trc:
ORA-07445: exception encountered: core dump [] [SIGBUS] [Invalid address alignment] [2803944365] [] []
ORA-00600: internal error code, arguments: [4555], [], [], [], [], [], [], []
Wed Jun 20 12:51:22 2001
Starting ORACLE instance (normal)
Wed Jun 20 12:51:48 2001
Shutting down instance (immediate)
License high water mark = 2
Wed Jun 20 12:51:48 2001
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... Wed Jun 20 12:51:48 2001
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT

---

Received on Wed Jun 20 2001 - 12:44:41 CDT