RMAN - Which tables and views store backup information? How do we access them?
We are trying to use Oracle queries found on Oracle support pages that return RMAN backup information.
Where are:
rman.rc_backup_set rman.rc_backup_piece rman.rc_database_incarnation
We found this query on SUPPORT.ORACLE.COM
RMAN: Querying and Listing Backup Informations (Doc ID 106427.1)
select to_char(s.completion_time, 'Mon DD YYYY HH24:MI:SS') BACKUP_DATE_TIME, s.bs_key, s.pieces, s.status, s.db_id, p.piece#, p.bp_key from rman.rc_backup_set s, rman.rc_backup_piece p, rman.rc_database_incarnation i where s.bs_key = p.bs_key and i.current_incarnation = 'YES' and s.completion_time = p.completion_time
Tagged:
0