Hi,
We have recovery catalog in RMAN. Most of the databases are registered in catalog. But we are not taking the backup using the RMAN catalog.
What query I need to use to find out the databases which is not using the catalog for backup..?
Hi,
We have recovery catalog in RMAN. Most of the databases are registered in catalog. But we are not taking the backup using the RMAN catalog.
What query I need to use to find out the databases which is not using the catalog for backup..?
May be use can use a simple script to identify when was the last backup registered in the catalog for each database.
select NAME,max(START_TIME)
from RC_BACKUP_SET rset, RC_DATABASE rdat
where rset.DB_KEY=rdat.DB_KEY and rset.DB_ID=rdat.DBID
group by NAME;
Be careful if you have too many records in the RC_BACKUP_SET.
Thanks,