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

[Former Member]

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

[Former Member]

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

[Former Member]

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:

[former_member185954]

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:

Regards,

Siddhesh