Recovery Catalog View rc_archived_log does not match with controlfile v$archived_log (Doc ID 1501742.1)

Last updated on NOVEMBER 05, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

o After unregister and re-register the target database from the recovery catalog, it is observed that the values for
   V$ARCHIVED_LOG (in the target db controlfile) and RC_ARCHIVED_LOG (view in the catalog) are different!


To show this see below sample

If Unregister database, then count(*) for RC_ARCHIVED_LOG related to this Database becomes zero:

RMAN> connect catalog rmanzfs/***@p_rman
connected to recovery catalog database

RMAN> connect target /
connected to target database: PBT10 (DBID=709580706)

RMAN> unregister database;
database name is "PBT10" and DBID is 709580706

Do you really want to unregister the database (enter YES or NO)? YEs
database unregistered from the recovery catalog
RMAN> exit

Recovery Manager complete.

 

-- Use SQLplus and connect to rman Catalog Schema

(oracle@naep10x01) /home/oracle > sqlplus rmanzfs@p_rman
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 22 16:23:09 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Enter password:

SQL> select count(*) from RC_ARCHIVED_LOG where db_name='PBT10';

 COUNT(*)
----------
        0


# Reregister Target Database
# After reregistering it:
# (The resync leading me to believe all entries from v$archived_log are resynced to catalog, but it 'looks like' it did not)

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete

RMAN> exit
Recovery Manager complete.

 

-- Use SQLplus and connect to rman Catalog Schema

(oracle@naep10x01) /home/oracle > sqlplus rmanzfs@p_rman
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 22 16:47:41 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Enter password:
...

SQL> select count(*) from RC_ARCHIVED_LOG where db_name='PBT10';

 COUNT(*)
----------
       70        <<---

p_rman RMANZFS> exit

 

-- Use SQLplus and connect to Target Database

(oracle@naep10x01) /home/oracle > sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 22 16:48:05 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.


SQL>  select count(*) from V$ARCHIVED_LOG ;

 COUNT(*)
----------
     2954        <<--- this is different


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