ORACLE - Standby Redo logfile corrupte

Issue: (  ORA-00261 and ORA-00313 ):

At standby database  dba found that standby logfile group 56 was corrupted.

RFS[11]: Assigned to RFS process 14642

RFS[11]: Identified database type as 'physical standby'

Wed Nov 07 15:31:34 2012

Errors in file /u02/oracle/jdb/logs/bdump/JDBdr3_arc2_12269.trc:

ORA-00313: open failed for members of log group 56 of thread 3

ORA-00312: online log 56 thread 3: '+JDB_DATA/JDBdr/onlinelog/group_56.268.720898269'

ORA-17503: ksfdopn:2 Failed to open file +JDB_DATA/JDBdr/onlinelog/group_56.268.720898269

ORA-15012: ASM file '+JDB_DATA/JDBdr/onlinelog/group_56.268.720898269' does not exist

Wed Nov 07 15:31:35 2012

Errors in file /u02/oracle/jdb/logs/bdump/JDBdr3_arc2_12269.trc:

ORA-00314: log 56 of thread 3, expected sequence# 56253 doesn't match 56242

ORA-00312: online log 56 thread 3: '+JDB_FLASH/JDBdr/onlinelog/group_56.3289.720898269'

Primary database is in MAXIMUM PERFORMANCE mode

Wed Nov 07 15:31:35 2012

or

Errors in file /u02/oracle/jdb/logs/udump/fipsldr1_rfs_12914.trc:

ORA-00261: log 34 of thread 3 is being archived or modified

ORA-00312: online log 34 thread 3: '+JDATA_DATA'

ORA-00312: online log 34 thread 3: '+JDATA1_FLASH'

Mon Aug  8 02:02:20 2011

Errors in file /u02/oracle/jdb/logs/udump/fipsldr1_rfs_12914.trc:

ORA-00261: log 34 of thread 3 is being archived or modified

ORA-00312: online log 34 thread 3: '+JATA1_DATA/fipsldr/onlinelog/group_34.297.758599339'

ORA-00312: online log 34 thread 3: '+JDATA1_FLASH'

Solution:

On Standby Database

SQL> alter system set standby_file_management = 'MANUAL';

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 SIZE 100m;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 SIZE 100m;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 SIZE 100m;

Database altered.

SQL> alter database drop standby logfile group 56;

alter database drop standby logfile group 56

*

ERROR at line 1:

ORA-00261: log 56 of thread 3 is being archived or modified

ORA-00312: online log 56 thread 3:

'+JDATA/mipsldr/onlinelog/group_56.268.720898269'

ORA-00312: online log 56 thread 3:

'+JFLASH/mipsldr/onlinelog/group_56.3289.720898269'

Note: alter system log switch at primary  

You can not drop a logfile group with status is
CLEARING_CURRENT

SQL>  alter database drop standby logfile group 56; 

Database altered.

SQL> alter system set standby_file_management = 'AUTO';

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE using current logfile disconnect from session;

Database altered.