Skip to content

Instantly share code, notes, and snippets.

@dotmaik1

dotmaik1/rman: backups information.sql

Last active October 6, 2016 16:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dotmaik1/38d69743b2de1b03c6137524894d08e8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dotmaik1/38d69743b2de1b03c6137524894d08e8 to your computer and use it in GitHub Desktop.
Download ZIP
List all the backups information
Raw
rman: backups information.sql
set lines 200
select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
round((end_time-start_time)*1440,2) "Minutes"
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment