{"id":1150,"date":"2018-02-16T10:05:23","date_gmt":"2018-02-16T09:05:23","guid":{"rendered":"https:\/\/dbafox.com\/?p=1150"},"modified":"2018-02-16T10:05:23","modified_gmt":"2018-02-16T09:05:23","slug":"oracle-rman-display-rman-backups","status":"publish","type":"post","link":"https:\/\/dbafox.com\/?p=1150","title":{"rendered":"Oracle – RMAN – Display RMAN Backups"},"content":{"rendered":"

RMAN -Display RMAN Backups<\/h2>\n
-- display rman backups\r\nselect\r\n  j.session_recid, j.session_stamp,\r\n  to_char(j.start_time, 'dd.mm.yyyy hh24:mi:ss') start_time,\r\n  to_char(j.end_time, 'dd.mm.yyyy hh24:mi:ss') end_time,\r\n  (j.output_bytes\/1024\/1024) output_mbytes, j.status, j.input_type,\r\n  decode(to_char(j.start_time, 'd'), 1, 'Sunday', 2, 'Monday',\r\n                                     3, 'Tuesday', 4, 'Wednesday',\r\n                                     5, 'Thursday', 6, 'Friday',\r\n                                     7, 'Saturday') dow,\r\n  j.elapsed_seconds, j.time_taken_display,\r\n  x.cf, x.df, x.i0, x.i1, x.l,\r\n  ro.inst_id output_instance\r\nfrom V$RMAN_BACKUP_JOB_DETAILS j\r\n  left outer join\r\n  (select\r\n     d.session_recid, d.session_stamp,\r\n     sum(case when d.controlfile_included = 'YES' then d.pieces else 0 end) CF,\r\n     sum(case when d.controlfile_included = 'NO'\r\n               and d.backup_type||d.incremental_level = 'D' then d.pieces else 0 end) DF,\r\n     sum(case when d.backup_type||d.incremental_level = 'D0' then d.pieces else 0 end) I0,\r\n     sum(case when d.backup_type||d.incremental_level = 'I1' then d.pieces else 0 end) I1,\r\n     sum(case when d.backup_type = 'L' then d.pieces else 0 end) L\r\n    from\r\n     V$BACKUP_SET_DETAILS d\r\n     join V$BACKUP_SET s on s.set_stamp = d.set_stamp and s.set_count = d.set_count\r\n    where s.input_file_scan_only = 'NO'\r\n    group by d.session_recid, d.session_stamp) x\r\n    on x.session_recid = j.session_recid and x.session_stamp = j.session_stamp\r\n  left outer join (select o.session_recid, o.session_stamp, min(inst_id) inst_id\r\n                   from GV$RMAN_OUTPUT o\r\n                   group by o.session_recid, o.session_stamp)\r\n    ro on ro.session_recid = j.session_recid and ro.session_stamp = j.session_stamp\r\nwhere j.start_time > trunc(sysdate)-2\r\norder by j.start_time desc;<\/pre>\n","protected":false},"excerpt":{"rendered":"
RMAN -Display RMAN Backups — display rman backups select j.session_recid, j.session_stamp, to_char(j.start_time, ‘dd.mm.yyyy hh24:mi:ss’) start_time, to_char(j.end_time, ‘dd.mm.yyyy hh24:mi:ss’) end_time, (j.output_bytes\/1024\/1024) output_mbytes, j.status, j.input_type, decode(to_char(j.start_time, ‘d’), 1, ‘Sunday’, 2, ‘Monday’, 3, ‘Tuesday’, 4, ‘Wednesday’, 5, ‘Thursday’, 6, ‘Friday’, 7, ‘Saturday’) dow, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pgc_sgb_lightbox_settings":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[28],"tags":[],"class_list":["post-1150","post","type-post","status-publish","format-standard","hentry","category-oracle-technical"],"yoast_head":"\nOracle - RMAN - Display RMAN Backups - dbafox<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbafox.com\/?p=1150\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle - RMAN - Display RMAN Backups - dbafox\" \/>\n<meta property=\"og:description\" content=\"RMAN -Display RMAN Backups -- display rman backups select j.session_recid, j.session_stamp, to_char(j.start_time, 'dd.mm.yyyy hh24:mi:ss') start_time, to_char(j.end_time, 'dd.mm.yyyy hh24:mi:ss') end_time, (j.output_bytes\/1024\/1024) output_mbytes, j.status, j.input_type, decode(to_char(j.start_time, 'd'), 1, 'Sunday', 2, 'Monday', 3, 'Tuesday', 4, 'Wednesday', 5, 'Thursday', 6, 'Friday', 7, 'Saturday') dow, … Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbafox.com\/?p=1150\" \/>\n<meta property=\"og:site_name\" content=\"dbafox\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-16T09:05:23+00:00\" \/>\n<meta name=\"author\" content=\"Ray Fox\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ray Fox\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbafox.com\/?p=1150\",\"url\":\"https:\/\/dbafox.com\/?p=1150\",\"name\":\"Oracle - RMAN - Display RMAN Backups - dbafox\",\"isPartOf\":{\"@id\":\"https:\/\/dbafox.com\/#website\"},\"datePublished\":\"2018-02-16T09:05:23+00:00\",\"author\":{\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\"},\"breadcrumb\":{\"@id\":\"https:\/\/dbafox.com\/?p=1150#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbafox.com\/?p=1150\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbafox.com\/?p=1150#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbafox.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle – RMAN – Display RMAN Backups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbafox.com\/#website\",\"url\":\"https:\/\/dbafox.com\/\",\"name\":\"dbafox\",\"description\":\"DBA Technical Information\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbafox.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\",\"name\":\"Ray Fox\",\"sameAs\":[\"http:\/\/www.dbafox.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle - RMAN - Display RMAN Backups - dbafox","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbafox.com\/?p=1150","og_locale":"en_GB","og_type":"article","og_title":"Oracle - RMAN - Display RMAN Backups - dbafox","og_description":"RMAN -Display RMAN Backups -- display rman backups select j.session_recid, j.session_stamp, to_char(j.start_time, 'dd.mm.yyyy hh24:mi:ss') start_time, to_char(j.end_time, 'dd.mm.yyyy hh24:mi:ss') end_time, (j.output_bytes\/1024\/1024) output_mbytes, j.status, j.input_type, decode(to_char(j.start_time, 'd'), 1, 'Sunday', 2, 'Monday', 3, 'Tuesday', 4, 'Wednesday', 5, 'Thursday', 6, 'Friday', 7, 'Saturday') dow, … Continue reading →","og_url":"https:\/\/dbafox.com\/?p=1150","og_site_name":"dbafox","article_published_time":"2018-02-16T09:05:23+00:00","author":"Ray Fox","twitter_misc":{"Written by":"Ray Fox","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dbafox.com\/?p=1150","url":"https:\/\/dbafox.com\/?p=1150","name":"Oracle - RMAN - Display RMAN Backups - dbafox","isPartOf":{"@id":"https:\/\/dbafox.com\/#website"},"datePublished":"2018-02-16T09:05:23+00:00","author":{"@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb"},"breadcrumb":{"@id":"https:\/\/dbafox.com\/?p=1150#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbafox.com\/?p=1150"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbafox.com\/?p=1150#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbafox.com\/"},{"@type":"ListItem","position":2,"name":"Oracle – RMAN – Display RMAN Backups"}]},{"@type":"WebSite","@id":"https:\/\/dbafox.com\/#website","url":"https:\/\/dbafox.com\/","name":"dbafox","description":"DBA Technical Information","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbafox.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb","name":"Ray Fox","sameAs":["http:\/\/www.dbafox.com"]}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ecMb-iy","_links":{"self":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1150"}],"version-history":[{"count":1,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1150\/revisions"}],"predecessor-version":[{"id":1151,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1150\/revisions\/1151"}],"wp:attachment":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}