Re: RMAN Catalog and Controlfile are out of sync for few backups

From the database:

select incarnation#, resetlogs_time, prior_resetlogs_time from v$database_incarnation
order by 2

From the backup catalog:

select name,current_incarnation, resetlogs_time, prior_resetlogs_time from rc_database_incarnation
where dbid = DBID
order by 3
/

You will need to edit the previous query for the correct DBID This can be found by this query on the target database:

  select DBID from v$database;

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Mon, Jan 26, 2009 at 7:21 AM, Raj Mareddi <raj.mareddi_at_gmail.com> wrote:

> I have restored my controlfile from yesterday's RMAN Backup and
> restored database. RMAN has automatically done full sync, when it
> first ran after restore. There are some tape backups which are made
> after the restore point (between yesterday's backup and now). This
> info is not available in v$backup_piece, however this is in catalog
> table(RC_BACKUP_PIECE). I have tried resync catalog but it hasn't
> fetched any records from Catalog to Controlfile.
>
> Is resync always from Controlfile to Catalog ? Can we sync in reverse
> direction too ?
>
> TIA,
> Raj Mareddi
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l