Stay at Home!! Be Safe!! Take Care!!

Thanks all my viewers for your support, I am an Oracle Ace now. For Any queries, please mail us at support@funoracleapps.com

How to Find which Files Are Backed Up In RMAN Backup Set

No comments

How to Find which Files Are Backed Up In RMAN Backup Set 



Query to find the  Backed Up Logs.

SQL> select recid,set_stamp,sequence#,first_change#,next_change# 
     from  v$backup_redolog;

The V$BACKUP_REDOLOG view queries the Control File so this can be done with or 
without a Catalog.


Query to find sequence is kept in which backup piece

SQL> select r.sequence#, p.handle
 from v$backup_piece p, v$backup_redolog r
 where r.set_stamp = p.set_stamp
   and r.set_count = p.set_count
   and r.sequence# = 63 

Query to find datafiles  is kept  in which backup piece. 

 SQL> select d.file#, p.handle
from v$backup_piece p, v$backup_datafile d
where d.set_stamp = p.set_stamp
  and d.set_count = p.set_count
  and d.file# = 3

No comments :

Post a Comment