This note gives a brief overview of bug 4538727.

The content was last updated on: 01-APR-2008

Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Rdbms)

Range of versions believed to be affected Versions BELOW 11.2

Versions confirmed as being affected

9.2.0.8

9.2.0.6

Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

11.1.0.7 (Server Patch Set)

10.2.0.4 (Server Patch Set)

Symptoms:

Related To:

Wrong Results

RMAN (Recovery Manager)

Physical Standby Database / Dataguard

V$ARCHIVED_LOG

Description

The APPLIED column in v$archived_log is not updated properly.

v$archived_log shows the wrong value of APPLIED on some of

the archive logs so RMAN fails to delete them.

eg:

archive log filename=/arc2/1_0000000157.arc thread=1 sequence=157

WARNING: archive log not deleted, not yet applied by standby

Moreover, in primary database, the customer can not confirm

the latest archive log applied on the standby database.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

Bug:4538727 (This link will only work for PUBLISHED bugs)

Note:245840.1 Information on the sections in this article

Bug 4538727 Applied column is not updated in V$ARCHIVED_LOG