Re: RMAN Catalog and Controlfile are out of sync for few backups
- From: Jared Still <jkstill@xxxxxxxxx>
- To: raj.mareddi@xxxxxxxxx
- Date: Mon, 26 Jan 2009 10:15:59 -0800
What do these queries show?
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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
