OraFAQ Forum: Data Guard » Failed to query v$archived_log to find archive gap exists on standby db (ORA-00235)

Home » Server Options » Data Guard » Failed to query v$archived_log to find archive gap exists on standby db (ORA-00235) (Oracle 9.2.0.3, Sun Solaris 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Failed to query v$archived_log to find archive gap exists on standby db (ORA-00235) [message #385653]

Tue, 10 February 2009 07:22

shardul
Messages: 1
Registered: February 2009

Junior Member

Hi,

I am using Oracle 9.2.0.3 version with Solaris 9 OS. We had set up of primary and physical standby db.

Every one minute we check standby db status and find any archive logs pending to apply on standby db or not.

If any archive gap exists then we find gap and we apply archive logs on standby db.

We use following query to find gap but it throws below error.

select 'MAX_GAP='||max((SYSDATE - NEXT_TIME)*86400) from V$ARCHIVED_LOG where APPLIED = 'NO' and NEXT_TIME > (se
lect STARTUP_TIME from V$INSTANCE) and SEQUENCE# not in (select SEQUENCE# from V$ARCHIVED_LOG where APPLIED = 'YES')
*
ERROR at line 1:
ORA-00235: controlfile fixed table inconsistent due to concurrent update

This errors were observed multiple times. Due to this archived redo log are not applied and failed.

Could you please provide more inputs about this error? When and why this error can occur?

Is there any way we can prevent this error?

Thanks for inputs.

Regards,
Shardul.

Report message to a moderator

Re: Failed to query v$archived_log to find archive gap exists on standby db (ORA-00235) [message #385662 is a reply to message #385653]

Tue, 10 February 2009 07:51

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.orafaq.com/forum/?SQ=365eb8433a2289d7b8f4ef6b994583b4&t=search&srch=controlfile+fixed+table+inconsistent+due+to+co ncurrent+update&btn_submit=Search&field=all&forum_limiter=&search_logic=AND&sort_order=DESC&author=

ora-00235: control file fixed table inconsistent due to concurrent update
 *Cause:  concurrent update activity on a control file caused a query on a
           control file fixed table to read inconsistent information.
 *Action: Retry the operation.

Regards
Michel

Report message to a moderator

Previous Topic:	Switch over
Next Topic:	Heartbeat failed to connect to standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:04:30 CST 2025