Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select the incremental level in rman catalog?

user600516May 20 2015 — edited May 21 2015

Hi,

I'm looking for a way to create a report that shows the rman backup status that includes the incremental level of a database backup.

I'm currently using (eg) this but it does not contain incremental level information 

select a.* from rman.RC_RMAN_BACKUP_JOB_DETAILS@dbl_rmand_rman.world a where


a.db_name=:dbname


and a.db_key in (select n.db_key from rman.dbinc@dbl_rmand_rman.world n where dbinc_status='CURRENT'


and n.reset_time=(select max(z.reset_time) from rman.dbinc@dbl_rmand_rman.world z where z.db_name=n.db_name  ))


and a.start_time>sysdate-30


order by a.start_time desc

Is there a way to join rman.RC_RMAN_BACKUP_JOB_DETAILS with another table in the catalog to get this additional info?

Thanks

Emmanuel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2015
Added on May 20 2015
#performance-availability, #recovery-manager-rman
7 comments
895 views