Skip to Content
avatar image
Former Member

Redo log missing....what can i do?

in DB13 i found this problem:

/oracle/LED/origlogB/log_g114m1.dbf INUSE 14 52429312

/oracle/LED/mirrlogB/log_g114m2.dbf INVALID 14 52429824

BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: /oracle/LED/mirrlogB/log_g114m2.dbf

BR0970W Database administration alert - level: ERROR, type: REDOLOG_FILE_MISSING, object: /oracle/LED/mirrlogB/log_g114m2.dbf

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 18, 2007 at 06:41 PM

    Hi,

    its easy to fix this,

    Mirrorlogs are copies of Orilogs.. so you need to shutdown database and copy over the orilogb to/as mirrorlogb and startup...

    check the following Forum Post:

    recovering-mirrloga-and-b

    Regards,

    Siddhesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2007 at 07:22 AM

    Copying the Origlog to Mirrlog at OS level could solve your problem.

    You are NOT required to drop and recreate the redo log files as mentioned in my reply in post: recovering-mirrloga-and-b

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2007 at 09:28 AM

    SQLPLUS /NOLOG;

    CONN /AS SYSDBA

    EXECUTE THE FOLLOWING QUERRY

    SELECT GROUP#,MEMBER FROM V$LOGFILE;

    SEE FROM IT TO WHICH GROUP THE SAID TO FILES BELONG I.E

    /oracle/LED/origlogB/log_g114m1.dbf INUSE 14 52429312

    /oracle/LED/mirrlogB/log_g114m2.dbf INVALID 14 52429824

    BOTH THE FILES WILL BE BELONGING TO THE SAME GROUP

    STOP SAP

    STOP ORACLE

    REMANE /oracle/LED/mirrlogB/log_g114m2.dbf TO log_g114m2.dbf.COPY

    COPY /oracle/LED/origlogB/log_g114m1.dbf TO LOCATION /oracle/LED/mirrlogB/ AND RENAME log_g114m1.dbf

    TO log_g114m2.dbf

    START ORACLE IN MOUNT MODE

    EXECUTE THE FOLLOWING:

    ALTERDATABASE ADD LOGFILE MEMBER

    '/oracle/LED/mirrlogB/log_g114m2.dbf' TO GROUP 4;

    *****PL CHECK THE GROUP IN v$LOGFILE ABOVE and indicate group accordingly in the above step.

    RESTART THE ORACLE DATABASE.

    HOPE THIS WILL WORK.

    REGARDS

    PL DONT FORGET TO AWARD POINTS IF USEFUL

    Add comment
    10|10000 characters needed characters exceeded