Database Backup and Recovery (MOSC)

MOSC Banner

RMAN - Which tables and views store backup information? How do we access them?

edited Apr 10, 2024 4:09PM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center