ORA-01555 on Active Data Guard Standby Database (Doc ID 1273808.1)

Last updated on APRIL 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
Primary and Standby databases at 11.2.0.2
***Checked for relevance on 25-JUN-2013***
***Checked for relevance on 22-JAN-2015***

Symptoms


After upgrading to 11.2.0.2 we see this ORA-1555 on the Standby Database. It is not possible to logon with system, dbsnmp or other db-users. Only sys as sysdba is working.
It's like we are running on system's undo Tablespace, - and not the one which has been restored..


Alert log file from Standby database

ORA-01555: snapshot too old: rollback segment number 71 with name "???" too
small
----- Current SQL Statement for this session (sql_id=96g93hntrzjtr) -----
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#,
sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1,
spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2



Also noticed high waits on library cache locks of this bug as seen in the following trace file.



As per the MUSIC1_dia0_14976_1.trc
===================================
Verified Hangs in the System
Root Chain Total Hang
Hang Hang Inst Root #hung #hung Hang Hang Resolution
ID Type Status Num Sess Sess Sess Conf Span Action
----- ---- -------- ---- ----- ----- ----- ------ ------
------------------
1 HANG VICSELTD 1 205 2 2 LOW LOCAL Terminate Process
.
inst# SessId Ser# OSPID Event
----- ------ ----- ----- -----
1 588 1 14998 library cache lock
1 205 61452 10646 not in wait
.
Victim Information
HangID Inst# Sessid Ser Num OSPID Fatal BG Previous Hang
------ ----- ------ ------- ------ -------- -------------
1 1 205 61452 10646 N New Hang
.




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms