No great genius has ever existed without some touch of madness.

Thursday 27 November 2014

ORA-00313 ORA-00312 ORA-27037 Standby Database


PROBLEM :

 


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

ORA-00312: online log 1 thread 1: '/d02/oradata/XXXXXXXX/redog1m2.log'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-00312: online log 1 thread 1: '/d01/oradata/ XXXXXXXX/redog1m1.log'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 1 /d01/oradata/ XXXXXXXX/redog1m1.log

Clearing online log 1 of thread 1 sequence number 120028

Errors in file /oradba/app/oracle/diag/rdbms/ XXXXXXXX/ XXXXXXXX/trace/ XXXXXXXX_mrp0_64356518.trc:


 

 



SOLUTION :

 


SQL> alter database recover managed standby database cancel;

SQL>alter system set log_file_name_convert=’junk,junk’ scope=spfile;

System altered.

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.