Snippet Name: RMAN: List the most recent Level 0 backups
Description: The RMAN report and list commands aren't very user-friendly if you are looking for something specific. For example, if you want a list of the most recent Level 0 backups in a database, you can devise a more specific query if you go into the database and use the v$backup_datafile view, as shown in this example.
Thanks to Lisa T. for sharing this code.
Also see: » RMAN: List the most recent Level 0 bac...
» RMAN: Format Directives
» RMAN: Command Summary
» RMAN: Data Dictionary Objects
» RMAN (Oracle Recovery Manager)
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 13th, 2009
|
SELECT DISTINCT TO_CHAR((b.CHECKPOINT_TIME), 'YYYY-MM-DD HH:MI.SS') t<br>
FROM v$backup_datafile b, v$tablespace ts, v$datafile f<br>
WHERE b.incremental_level = 0<br>
AND INCLUDED_IN_DATABASE_BACKUP='YES'<br>
AND f.file#=b.file#<br>
AND f.ts#=ts.ts#<br>
GROUP BY b.checkpoint_time<br>
ORDER BY 1;<br>
|