Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RAC - ORA-1172 on startup after a crash

RAC - ORA-1172 on startup after a crash

From: Shivaswamy Raghunath <shivaswamykr_at_gmail.com>
Date: Wed, 1 Nov 2006 15:59:55 -0500
Message-ID: <1e52ad820611011259k52de2f7dy86a79fc996ad9711@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 01 2006 - 14:59:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US