Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to replace missing redo log group members after media failure

user2303362Aug 5 2015 — edited Aug 7 2015

Hi,

I'm testing a disk failure scenario.  I had the redo logs multiplexed over three locations (Windows drive letters); one of the three locations also contained the data files.  I blanked out the Windows drive that contained the data files and went through a recovery using RMAN.   All is well except that the redo log members that were located on the blanked Windows drive are of course still missing; the database opens and so forth but puts messages like this in the ALERT.log:

ORA-00321: log 2 of thread 1, cannot update log file header
ORA-00312: online log 2 thread 1: 'F:\APP\NGORA12CR2SRV\ORADATA\ORATEST5\ONLINELOG\O1_MF_2_BW4B5MY0_.LOG'


What is the "right" way to replace the missing members?  Do I simply create all new redo log groups with new members on all three disks?  Do I carefully copy the LOG files representing the missing members from one of the other locations?  Do I add new members in that location and drop the existing (missing) members? 


Does it matter?


thanks!


Martin

This post has been answered by Hemant K Chitale on Aug 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2015
Added on Aug 5 2015
7 comments
2,729 views