Aw: Re: log apply failure on standby fails with "ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK'"
From: <rogel_at_web.de>
Date: Mon, 26 Sep 2022 13:49:35 +0200
Message-ID: <trinity-82074d44-72d0-4daf-960a-85e2e10baa91-1664192975118_at_3c-app-webde-bs46>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 26 2022 - 13:49:35 CEST
Date: Mon, 26 Sep 2022 13:49:35 +0200
Message-ID: <trinity-82074d44-72d0-4daf-960a-85e2e10baa91-1664192975118_at_3c-app-webde-bs46>
Thanks Abdellah for the reference. Following this note we could solve the issue.
Regards, Matthias
Gesendet: Mittwoch, 21. September 2022 um 15:38 Uhr
Von: "Abdellah DANY" <abd.dany_at_gmail.com>
An: rogel_at_web.de
Betreff: Re: log apply failure on standby fails with "ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK'"
Von: "Abdellah DANY" <abd.dany_at_gmail.com>
An: rogel_at_web.de
Betreff: Re: log apply failure on standby fails with "ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK'"
Did you check this note: Resolving ORA-00752 or ORA-600 [3020] During Standby Recovery (Doc ID 1265884.1)
On Wed, Sep 21, 2022, 14:30 <rogel@web.de> wrote:
-- http://www.freelists.org/webpage/oracle-lDear listers,log apply on standby fails withErrors in file ..._pr06_130570.trc:
ORA-10562: Error occurred while applying redo to data block (file# 10, block# 310628162)
ORA-10564: tablespace DP
ORA-01110: Datendatei 10: '+DATA/vesuv/datafile/dp.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 1959639
ORA-00600: Interner Fehlercode, Argumente: [ktbair2: illegal inheritance], [], [], [], [], [], [], [], [], [], [], []...Version is 12.1.0.2.0, OS is Oracle Linux 6.6Support does not react for > 24 h on a Severity 2 SR.Any idea what we could do trying to repair that ?Thanks for any input,Matthias