Andrew Fraser DBA

Rman list most recent backups

List most recent rman database backups on target database sqlplus with:

set pages 9999 lines 132
ALTER SESSION SET nls_date_format = 'Dy DD-Mon-YYYY HH24:MI:SS'
;
SELECT b.checkpoint_time , b.incremental_level , COUNT(*)
  FROM v$backup_datafile b
  JOIN v$datafile f
    ON f.file# = b.file#
  JOIN v$tablespace ts
    ON f.ts# = ts.ts#
 WHERE ts.included_in_database_backup = 'YES'
   AND b.checkpoint_time > SYSDATE - 10
 GROUP BY b.checkpoint_time , b.incremental_level
 ORDER BY 1 DESC
;

H/t Lisa T.