Oracle Database Discussions

Hello,

My operating system is windows7 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    SQL> alter database open;  
    alter database open  
    *  
    ERROR at line 1:  
    ORA-00354: corrupt redo log block header  
    ORA-00353: log corruption near block 75760 change 5605346 time 01/07/2012  
    11:41:31  
    ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\XE\REDO03.LOG'  

I followed 923669

What I did so far:

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

Database altered.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\XE\SYSTEM01.DBF'

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE 'C:/Oracle/oradata/XE/REDO03.log';
ALTER DATABASE CLEAR UNARCHIVED LOGFILE 'C:/Oracle/oradata/XE/REDO03.log'
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of instance xe (thread 1)
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\XE\REDO03.LOG'


SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE 'C:/Oracle/oradata/XE/REDO03.log';
ALTER DATABASE CLEAR UNARCHIVED LOGFILE 'C:/Oracle/oradata/XE/REDO03.log'
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of instance xe (thread 1)
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\XE\REDO03.LOG'


SQL> RECOVER DATABASE UNTIL CANCEL;
ORA-00279: change 5587909 generated at 01/06/2012 10:31:25 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2012_01_23\O1_MF_1_216_%U_.ARC
ORA-00280: change 5587909 for thread 1 is in sequence #216


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Cancel
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:\ORACLE\ORADATA\XE\SYSTEM01.DBF'

Please help me

Thanks in anticipation