Problem with Red Log

[neodavid]

I have a problem with the redo file because I can not open the bank ... it gives error in the 2 members of the redo that I own.

Select all

SQL> alter database open; 
alter database open 
* 
ERROR at line 1: 
ORA-00354: corrupt redo log block header 
ORA-00353: log corruption near block 14023 change 107558214 time 04/04/2008 09:30:14 
ORA-00312: online log 1 thread 1: 'E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TESTE3\ONLINELOG\O1_MF_1_3CFWMSBQ_.LOG' 
ORA-00312: online log 1 thread 1: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTE3\TESTE3\ONLINELOG\O1_MF_1_3CFWMQMJ_.LOG'

OV $ Logfile is thus

Select all

    GROUP# STATUS  TYPE    MEMBER                                                                                        
---------- ------- ------- --------------------------------------------------------------------------------------                         
         1         ONLINE  F:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTE3\TESTE3\ONLINELOG\O1_MF_1_3CFWMQMJ_.LOG                
         1         ONLINE  E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TESTE3\ONLINELOG\O1_MF_1_3CFWMSBQ_.LOG           
         2         ONLINE  F:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTE3\TESTE3\REDO2.LOG                                      
         2         ONLINE  E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TESTE3\ONLINELOG\REDO2B.LOG                      
         3         ONLINE  F:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTE3\TESTE3\REDO3.LOG                                      
         3         ONLINE  E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TESTE3\ONLINELOG\REDO3B.LOG

I created new sets of redo where the select of the V $ log is like this:

Select all

SQL> select * from v$log; 
 
    SQL> select * from v$log; 
 
GROUP# THREAD# SEQUENCE#    BYTES    MEMBERS ARC  STATUS        
---------- ----------   ----------       ---------- ----------    ---     --------- 
         1          1       1196           52428800           2     NO    CURRENT 
         3          1          0            104857600          2     YES   UNUSED        
         2          1          0            104857600          2     YES   UNUSED   

[99]]
But I need to do a switch to release for me the group 1 for me to change the file, but I can not, because the bank is not open.


Does anyone have an idea how can I fix this error?

grateful,

[/b]

[neodavid]

I forgot to add ... is that the redo that I am in trouble and just the redo that is active at the moment.

[ruevers]

Your redo is zoaded, tries an open resetlogs ...

[neodavid]

You can not do a resetlogs because the bank is not open

[neodavid]

Thanks for the help ... I managed to solve the problem here.

As the problem was in the redo that was active at the moment, so I could not change it, what I did was change the pfile by adding the following line _ALLOW_RESETLOGS_CORRUPTION=TRUE what is that. This makes the redo that are in trouble does not affect the bank startup, then it is only you to correct the damaged log file. Ready, solved the problem.
Remembering that at the time it is to set up the bank has to indicate the path of the pfile.

grateful,

David Nasciment
DBA Oracle Jr.

[ruevers]

I knew I was not open, what I asked was to do an "open resetlogs" understood?
This should solve, without having to change the parameter because it should remain corrupt.