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)
Failed to query v$archived_log to find archive gap exists on standby db (ORA-00235) [message #385653] Tue, 10 February 2009 07:22 Go to next message
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.
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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Switch over
Next Topic: Heartbeat failed to connect to standby
Goto Forum:
  


Current Time: Thu Mar 28 09:38:44 CDT 2024