Could you do an rman recovery to SCN prior to the lost write ?
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Andrew Kerber [andrew.kerber@xxxxxxxxx]
Sent: 25 August 2016 21:46
To: ORACLE-L
Subject: ORA-00742: Log read detects lost write in thread 1 sequence 409 block
128535 ORA-00312: online log 1 thread 1:
'+RECO/OEM13C/ONLINELOG/group_1.261.916169151' ORA-00312: online log 1 thread
1: '+DATA/OEM13C/ONLINELOG/group_1.263.916169099'
This is on a system running in a vm on my desktop, thoroughly non-critical.
But its a little annoying that my desktop rebooted when I lost power, and
corrupted these redo log files. I can always rebuild the database, but I am
curious if anyone can think of a way to recover from the error below on the
current redo log. I tried to clear it, but no joy, and alter database open
resetlogs doesnt work either.
Any other thoughts before I give up and start over?
ORA-00742: Log read detects lost write in thread 1 sequence 409 block 128535
ORA-00312: online log 1 thread 1:
'+RECO/OEM13C/ONLINELOG/group_1.261.916169151'
ORA-00312: online log 1 thread 1:
'+DATA/OEM13C/ONLINELOG/group_1.263.916169099'
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'