cancel
Showing results for 
Search instead for 
Did you mean: 

Warning messages in MirrlogA & MirrlogB

Former Member
0 Kudos

Hi,

I am getting the following warning message in backup log(DB12). I tried to check the at mirrlogA & mirrlogB. There are no files inside this folder. Need someone's interventions to solve this warning messages in DB12 backup logs.

BR0335W Status of online redo log file /oracle/UQ1/mirrlogA/log_g11m2.dbf is INVALID

BR0274W File '/oracle/UQ1/mirrlogA/log_g11m2.dbf' not found

BR0335W Status of online redo log file /oracle/UQ1/mirrlogB/log_g12m2.dbf is INVALID

BR0274W File '/oracle/UQ1/mirrlogB/log_g12m2.dbf' not found

BR0335W Status of online redo log file /oracle/UQ1/mirrlogA/log_g13m2.dbf is INVALID

BR0274W File '/oracle/UQ1/mirrlogA/log_g13m2.dbf' not found

BR0335W Status of online redo log file /oracle/UQ1/mirrlogB/log_g14m2.dbf is INVALID

BR0274W File '/oracle/UQ1/mirrlogB/log_g14m2.dbf' not found

regards,

Kaspar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

Seems as if only the online Mirrorlogs are missing and the original logfiles must be there,,otherwise your database would have crashed.

Check the original log directories('/oracle/UQ1/origlogA/ & '/oracle/UQ1/origlogB/' and you must be having files there and proceed as following.

1. If the database is shut down

just copy the member that is still available to the locatation & name of the missing member

2. If the database is open

drop the member out of the group and recreate it sqlplus '/ as sysdba'

SQL> ALTER DATABASE DROP LOGFILE MEMBER '<path/filename>';

SQL> ALTER DATABASE ADD LOGFILE MEMBER '<path/filename>' to group X;

If the disk, on which the member was created on, does not exist anymore, you can specify a different location in the add logfile member command

This should help.

Regards

Amit

Former Member
0 Kudos

The issue is resolved. Thanks a lot Amit.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi SAP friends,

please, can you help me with this issue on our Oracle 12.0.1.2 Production database?

If I run the query

     SQL> SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE;

     The result is:

   

   

GROUP# STATUS       MEMBER

     4           INVALID      I:\ORACLE\ITP\ORIGLOGB\LOG_G14M1.DBF

     4                             K:\ORACLE\ITP\MIRRLOGB\LOG_G14M2.DBF

     3           INVALID      I:\ORACLE\ITP\ORIGLOGA\LOG_G13M1.DBF

     3                             K:\ORACLE\ITP\MIRRLOGA\LOG_G13M2.DBF

     2           INVALID      I:\ORACLE\ITP\ORIGLOGB\LOG_G12M1.DBF

     2                             K:\ORACLE\ITP\MIRRLOGB\LOG_G12M2.DBF

     1           INVALID      I:\ORACLE\ITP\ORIGLOGA\LOG_G11M1.DBF

     1                             K:\ORACLE\ITP\MIRRLOGA\LOG_G11M2.DBF

Our database is UP&Running.

Please can you explain me how to use the query showed in the correct answer with my real data?

          2. If the database is open

                     drop the member out of the group and recreate it sqlplus '/ as sysdba'

                     SQL> ALTER DATABASE DROP LOGFILE MEMBER '<path/filename>';

                     SQL> ALTER DATABASE ADD LOGFILE MEMBER '<path/filename>' to group X;

Is this operation dangerous for our production database?

Please help me. Thanks in advance,

Alessandro

Former Member
0 Kudos

Hello Alessandro,

If you still have the problem/question, please open a new thread with this. Resurrecting old threads doesn't go down to well.

KR,

A.

former_member204746
Active Contributor
0 Kudos

raj2009,

is your name Raj or Kaspar ?

Former Member
0 Kudos

I am sorry If i have confused my Name. My Full name is Kaspar raj. Both names are correct.

stefan_koehler
Active Contributor
0 Kudos

Hello Kaspar,

please execute the following query and post the output.


shell> sqlplus / as sysdba
SQL> set linesize 900
SQL> SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE;

Regards

Stefan