RAC - ORA-1172 on startup after a crash

Hello.

On my 2 node home RAC on 32 bit CentOS Linux, I had a crash on one of the
nodes. Afterwards, I am not able to start my database from either of the
nodes. In alert log, I find that, it is not able to do instance crash
recovery because of a corrupt block in redo log. (ORA-1172). Is there
something you can suggest to get the DB back up?I don't have a back up of
the database.
Here is the alert log snippet.

Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Tue Oct 31 18:53:47 2006
Completed: ALTER DATABASE   MOUNT
Tue Oct 31 18:53:58 2006
ALTER DATABASE OPEN
This instance was first to open
Tue Oct 31 18:53:59 2006
Beginning crash recovery of 2 threads
Tue Oct 31 18:53:59 2006
Started redo scan
Tue Oct 31 18:54:04 2006
Completed redo scan
47156 redo blocks read, 99 data blocks need recovery
Tue Oct 31 18:54:04 2006
Started redo application at
Thread 1: logseq 26, block 86954
Thread 2: logseq 24, block 2, scn 1143831
Tue Oct 31 18:54:04 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 26 Reading mem 0
 Mem# 0 errs 0: +ORCL_DATA1/orcl/onlinelog/group_1.281.602287213
 Mem# 1 errs 0: +FLASH_RECOVERY_AREA/orcl/onlinelog/group_1.263.602287225
Tue Oct 31 18:54:05 2006
Recovery of Online Redo Log: Thread 2 Group 4 Seq 24 Reading mem 0
 Mem# 0 errs 0: +ORCL_DATA1/orcl/onlinelog/group_4.287.602288425
 Mem# 1 errs 0: +FLASH_RECOVERY_AREA/orcl/onlinelog/group_4.266.602288435
RECOVERY OF THREAD 2 STUCK AT BLOCK 3729 OF FILE 3
Abort recovery for domain 0
Tue Oct 31 18:54:08 2006
Aborting crash recovery due to error 1172
Tue Oct 31 18:54:09 2006
Errors in file /u01/app/oracle/admin/orcl/udump/orcl2_ora_1053.trc:

Thanks,
Shiva

Other related posts:

  • » RAC - ORA-1172 on startup after a crash