RAC - ORA-1172 on startup after a crash
- From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 1 Nov 2006 15:59:55 -0500
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
