RE: 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'

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 25 Aug 2016 20:45:05 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9015033993C_at_exmbx05.thus.corp>

Could you do an rman recovery to SCN prior to the lost write ?

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Andrew Kerber [andrew.kerber_at_gmail.com] 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.'

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 25 2016 - 22:45:05 CEST