{"id":5720,"date":"2025-09-16T13:48:40","date_gmt":"2025-09-16T11:48:40","guid":{"rendered":"http:\/\/rootfan.com\/?p=5720"},"modified":"2025-09-16T13:55:11","modified_gmt":"2025-09-16T11:55:11","slug":"requete-oracle-pour-verifier-letat-des-sauvegardes-de-rman","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/oracle-query-to-check-rman-backup-status\/","title":{"rendered":"Requ\u00eate Oracle pour v\u00e9rifier l'\u00e9tat des sauvegardes RMAN"},"content":{"rendered":"<p>Cette requ\u00eate Oracle vous donnera tous les d\u00e9tails sur les sauvegardes de niveau 0 et de niveau 1 avec RMAN.<\/p>\n\n\n\n<!--more-->\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter session set nls_date_format=&#039;dd\/mm\/yyyy hh24:mi:ss&#039;;\n\nSET LINESIZE 220\nSET PAGESIZE 40\n\nCOL input_bytes_display    FOR a10\nCOL output_bytes_display   FOR a10\nCOL output_device_type     FOR a15\nCOL operation               FOR a18\nCOL input_type              FOR a15\nCOL status                  FOR a15 \nCOL name                    FOR a60\nCOL value                   FOR a75\nCOL start_time               FOR a20\nCOL end_time                 FOR a20\nCOL incremental_level        FOR a10\nCOL level_back                FOR a15\n\nSELECT DISTINCT \n       i.instance_name,\n       r.session_key,\n       TO_CHAR(r.start_time, &#039;DD\/MM\/YYYY hh24:mi:ss&#039;) AS start_time,\n       TO_CHAR(r.end_time,   &#039;DD\/MM\/YYYY hh24:mi:ss&#039;) AS end_time, \n       DECODE(d.incremental_level,\n              0, &#039;BACKUP FULL&#039;,\n              1, &#039;INCR 1&#039;,\n              NULL, &#039;ARCH&#039;,\n              &#039;OTHER&#039;) AS level_back,\n       r.input_bytes_display,\n       r.output_bytes_display,\n       r.output_device_type,\n       r.input_type,\n       r.status\nFROM   v$rman_backup_job_details r,\n       v$backup_set_details d,\n       v$instance i\nWHERE  d.session_key   = r.session_key\n  AND  d.session_recid = r.session_recid\n  AND  d.incremental_level IN (0, 1)\n  AND  r.end_time &gt; SYSDATE - 60\nORDER BY 2;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Cette requ\u00eate Oracle vous donnera tous les d\u00e9tails sur les sauvegardes de niveau 0 et de niveau 1 avec RMAN.<\/p>","protected":false},"author":1,"featured_media":6541,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Easily check the status of your rman backup with a simple query. Ensure the integrity of your backups effortlessly.","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_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":[31],"tags":[70,92],"class_list":["post-5720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-query","tag-rman"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-1144176-1.jpeg?fit=1880%2C1056&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=5720"}],"version-history":[{"count":5,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5720\/revisions"}],"predecessor-version":[{"id":6558,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5720\/revisions\/6558"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/6541"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=5720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=5720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=5720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}