Re: Possible Data Guard Issue
From: Leng <lkaing_at_gmail.com>
Date: Tue, 21 Jun 2022 21:41:55 +1000
Message-Id: <68C5EFBC-88DB-4D20-A8AA-0437C0249B35_at_gmail.com>
>> On 6/20/22 13:05, Scott Canaan wrote:
>> We are running Oracle 19.15 on Red Hat 7.
>>
>> On Friday, one of my co-workers tried to convert the physical standby to a snapshot standby to use it to refresh another database. He got an error saying more standby was needed in order to convert. Looking into the alert log, there are messages saying that several files are “fuzzy”. He re-established the data guard, but now the standby database says that all of the files are “fuzzy”.
>>
>> DGMGRL> show configuration
>>
>> Configuration - CLAWPRDA
>>
>> Protection Mode: MaxPerformance
>> Members:
>> CLAWPRDB - Primary database
>> CLAWPRDA - Physical standby database
>>
>> Fast-Start Failover: Disabled
>>
>> Configuration Status:
>> SUCCESS (status updated 8 seconds ago)
>>
>> DGMGRL> convert database 'CLAWPRDA' to snapshot standby;
>> Converting database "CLAWPRDA" to a Snapshot Standby database, please wait...
>> Error: ORA-38788: More standby database recovery is needed
>>
>> Failed.
>> Failed to convert database "CLAWPRDA"
>> DGMGRL>
>>
Date: Tue, 21 Jun 2022 21:41:55 +1000
Message-Id: <68C5EFBC-88DB-4D20-A8AA-0437C0249B35_at_gmail.com>
Hi Scott,
How was the standby created in the first place? Was it accidentally placed in user managed backup mode? Look at v$Backup…
Or did the standby die and ended up fuzzy forever? I don’t remember exactly what error shows up in the alert.log but it was something along that line.
Did it apply a corrupted or perhaps shortened archivelog? Eg. When it’s transferred manually whilst the log will still being archived…
Datafiles that are fuzzy will always recover. You won’t get an error. It’s just that u won’t be able to open it until it gets out of fuzzy state.
I guess you could try and recreate the standby controlfile and see if it makes the situation any better.
Cheers,
Leng
> On 21 Jun 2022, at 8:51 am, Mladen Gogala <gogala.mladen_at_gmail.com> wrote: > >
>> On 6/20/22 13:05, Scott Canaan wrote:
>> We are running Oracle 19.15 on Red Hat 7.
>>
>> On Friday, one of my co-workers tried to convert the physical standby to a snapshot standby to use it to refresh another database. He got an error saying more standby was needed in order to convert. Looking into the alert log, there are messages saying that several files are “fuzzy”. He re-established the data guard, but now the standby database says that all of the files are “fuzzy”.
>>
>> DGMGRL> show configuration
>>
>> Configuration - CLAWPRDA
>>
>> Protection Mode: MaxPerformance
>> Members:
>> CLAWPRDB - Primary database
>> CLAWPRDA - Physical standby database
>>
>> Fast-Start Failover: Disabled
>>
>> Configuration Status:
>> SUCCESS (status updated 8 seconds ago)
>>
>> DGMGRL> convert database 'CLAWPRDA' to snapshot standby;
>> Converting database "CLAWPRDA" to a Snapshot Standby database, please wait...
>> Error: ORA-38788: More standby database recovery is needed
>>
>> Failed.
>> Failed to convert database "CLAWPRDA"
>> DGMGRL>
>>
> > Hi Scott, > > When in DGMGRL, what do "show database verbose CLAWPRDA" and "validate database CLAWPRDA" show? Any indications of the error in the alert.log on the standby side? > > -- > Mladen Gogala > Database Consultant > Tel: (347) 321-1217 > https://dbwhisperer.wordpress.com > -- http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 21 2022 - 13:41:55 CEST