Skip to content

Instantly share code, notes, and snippets.

@neilkod

neilkod/last_backup.sql

Created January 19, 2011 18:51
Show Gist options
  • Save neilkod/786628 to your computer and use it in GitHub Desktop.
Save neilkod/786628 to your computer and use it in GitHub Desktop.
Download ZIP
completion time and scn for last successful full backup
Raw
last_backup.sql
select max(end_time) completion_time
, timestamp_to_scn(max(end_time)) scn
from v$rman_backup_job_details
where input_type = 'DB FULL'
and status='COMPLETED';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment