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: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 25 Aug 2016 15:46:00 -0500
Message-ID: <CAJvnOJZcs03OOcT3wyZxq3_uFZD8m3wFDnc1G0u=YjXQXz5N4Q_at_mail.gmail.com>
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.
Date: Thu, 25 Aug 2016 15:46:00 -0500
Message-ID: <CAJvnOJZcs03OOcT3wyZxq3_uFZD8m3wFDnc1G0u=YjXQXz5N4Q_at_mail.gmail.com>
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-lReceived on Thu Aug 25 2016 - 22:46:00 CEST