My db got corrupted, and I'm having the following issue when opening it:
ORA-01172: recovery of thread 1 stuck at block 31823 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed
I did the following... but am now stuck. I accidentally entered a newline when I was supposed to specify the log file (I guess?). Any help would be great. Thanks!
---
SQL> recover database until cancel;
ORA-00279: change 12390169168251 generated at 06/26/2012 09:41:48 needed for
thread 1
ORA-00289: suggestion :
C:\APP\GRExxxxxxx\FLASH_RECOVERY_AREA\MYDB\ARCHIVELOG\2012_06_27\O1_MF_1_1
27_%U_.ARC
ORA-00280: change 12390169168251 for thread 1 is in sequence #127
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'C:\APP\GRExxxxxxx\FLASH_RECOVERY_AREA\MYDB\ARCHIVELOG\2012_06_27\O1_MF_1_
127_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\GRExxxxxxx\ORADATA\MYDB\SYSTEM01.DBF'