My Oracle Support Banner

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

Last updated on NOVEMBER 26, 2019

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

 

 - After unregistering and re-registering the target database in the recovery catalog, it is observed that the values for
   V$ARCHIVED_LOG (in the target databae controlfile) and RC_ARCHIVED_LOG (view in the catalog) are different


Example:

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

RMAN> connect catalog <username>/<password>@<catalog_tns>
connected to recovery catalog database

RMAN> connect target /
connected to target database: <dbname> (DBID=<dbid>)

RMAN> unregister database;
database name is "<dbname>" and DBID is <dbid>

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

sqlplus <username>@<catalog_tns>
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;

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

# Re-register Target Database
# After re-registering the database in the catalog:
# The resync did not move all records from  v$archived_log  to recovery catalog.

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.

 

-- Connect to rman catalog schema using sqlplus.

sqlplus <username>@<catalog_tns>
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;

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

-- Connect to target database using sqlplus.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.