sorry for the confusing!!!!

this is what happened,

I upgrade the server from 8.1.7.3 to 8.1.7.4 on nt this morning, I have 5 instance on this server. three of them ran great and everything is working fine except for this isntance. when I tried to run catalog.sql it's hang there and not doing anything so I shutdown the database and look into the log file I found

Beginning crash recovery of 1 threads
Sat Mar 29 11:44:59 2003
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2918 Reading mem 0
Mem# 0 errs 0: F:\ORADATA\PROD\LOG2PROD_A.RDO
Mem# 1 errs 0: F:\ORADATA\PROD\LOG2PROD_B.RDO
Sat Mar 29 11:45:00 2003
Thread recovery: finish rolling forward thread 1
Thread recovery: 36 data blocks read, 31 data blocks written, 800 redo blocks read
Crash recovery completed successfully
Sat Mar 29 11:45:02 2003
Thread 1 advanced to log sequence 2919
Thread 1 opened at log sequence 2919
Current log# 3 seq# 2919 mem# 0: F:\ORADATA\PROD\LOG3PROD_A.RDO
Current log# 3 seq# 2919 mem# 1: F:\ORADATA\PROD\LOG3PROD_B.RDO
Successful open of redo thread 1.
Sat Mar 29 11:45:03 2003
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Mar 29 11:45:05 2003
Completed: ALTER DATABASE OPEN
Sat Mar 29 11:45:30 2003
Thread 1 advanced to log sequence 2920
Current log# 1 seq# 2920 mem# 0: F:\ORADATA\PROD\LOG1PROD_A.RDO
Current log# 1 seq# 2920 mem# 1: F:\ORADATA\PROD\LOG1PROD_B.RDO
Thread 1 advanced to log sequence 2921
Current log# 2 seq# 2921 mem# 0: F:\ORADATA\PROD\LOG2PROD_A.RDO
Current log# 2 seq# 2921 mem# 1: F:\ORADATA\PROD\LOG2PROD_B.RDO
Sat Mar 29 11:45:57 2003



AND THE ERROR ON THE TRACE AS EARLIER POST,

CAN YOU GIVE ME SOME ADVISE???

THANKS