{"id":6251,"date":"2024-09-15T15:06:18","date_gmt":"2024-09-15T13:06:18","guid":{"rendered":"http:\/\/rootfan.com\/?p=6251"},"modified":"2024-09-15T18:06:49","modified_gmt":"2024-09-15T16:06:49","slug":"comment-restaurer-une-base-de-donnees-oracle-a-partir-dune-sauvegarde","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/how-to-restore-an-oracle-database-from-a-backup\/","title":{"rendered":"Comment restaurer une base de donn\u00e9es Oracle \u00e0 partir d'une sauvegarde ?"},"content":{"rendered":"<p>Voici les \u00e9tapes \u00e0 suivre pour restaurer et r\u00e9cup\u00e9rer une base de donn\u00e9es Oracle \u00e0 partir d'une sauvegarde.<\/p>\n\n\n\n<p>Vous restaurerez \u00e0 partir d'une sauvegarde compl\u00e8te.<\/p>\n\n\n\n<p>Vous devrez restaurer les fichiers de donn\u00e9es, les fichiers de contr\u00f4le et les journaux d'archives.<\/p>\n\n\n\n<p>Vous disposez d'une sauvegarde RMAN valide.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Mes fichiers de sauvegarde se trouvent dans le dossier :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\/home\/oracle\/backup\n<\/pre><\/div>\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table des mati\u00e8res<\/h2><nav><ul><li><a href=\"#1-restore-the-spfile-from-the-backup\">1. Restaurer le fichier spf \u00e0 partir de la sauvegarde<\/a><\/li><li><a href=\"#2-restore-the-control-file\">2. Restaurer le fichier de contr\u00f4le<\/a><\/li><li><a href=\"#3-catalog-the-rman-backups\">3. Cataloguer les sauvegardes RMAN<\/a><\/li><li><a href=\"#4-restore-and-recover-the-oracle-database\">4. Restaurer et r\u00e9cup\u00e9rer la base de donn\u00e9es Oracle<\/a><\/li><li><a href=\"#5-open-the-database-with-resetlogs\">5. Ouvrez la base de donn\u00e9es avec resetlogs<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<p>Vous devez ex\u00e9cuter les commandes avec l'utilisateur oracle et instancier votre base de donn\u00e9es avec . oraenv. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-restore-the-spfile-from-the-backup\">1. Restaurer le fichier spf \u00e0 partir de la sauvegarde<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nrman target \/\n\nRMAN&gt; startup nomount force;\n<\/pre><\/div>\n\n\n<p>Vous devez savoir o\u00f9 se trouve le fichier spfile dans les fichiers de sauvegarde.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; restore spfile from &#039;\/home\/oracle\/backup\/ORADBSPFILE.bck&#039;;\n\nRMAN&gt; shutdown immediate;\n\nRMAN&gt; startup nomount;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"2-restore-the-control-file\">2. Restaurer le fichier de contr\u00f4le<\/h2>\n\n\n\n<p>Connectez-vous \u00e0 sqlplus pour v\u00e9rifier o\u00f9 les fichiers de contr\u00f4le seront restaur\u00e9s.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSQL&gt; show parameter control_files\n<\/pre><\/div>\n\n\n<p>Normalement, la sauvegarde du fichier de contr\u00f4le se trouve dans le dernier fichier g\u00e9n\u00e9r\u00e9 par RMAN lors de la sauvegarde.<\/p>\n\n\n\n<p>Restaurer le fichier de contr\u00f4le et monter la base de donn\u00e9es.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nrman target \/\n\nRMAN&gt; restore controlfile from &#039;\/home\/oracle\/backup\/ORADBCTL.bck&#039;;\n\nRMAN&gt; alter database mount;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"3-catalog-the-rman-backups\">3. Cataloguer les sauvegardes RMAN<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; catalog start with &#039;\/home\/oracle\/backup\/&#039;;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"4-restore-and-recover-the-oracle-database\">4. Restaurer et r\u00e9cup\u00e9rer la base de donn\u00e9es Oracle<\/h2>\n\n\n\n<p>Ex\u00e9cuter la restauration et la r\u00e9cup\u00e9ration \u00e0 l'int\u00e9rieur d'un bloc RMAN<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nrman target \/\n\nRMAN &gt; run\n{\nrestore database;\nrecover database;\n}\n<\/pre><\/div>\n\n\n<p>Il se peut que vous obteniez cette erreur, mais cela ne devrait pas poser de probl\u00e8me.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of recover command at 09\/12\/2024 22:20:13\nRMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 119 and starting SCN of 5208264\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"5-open-the-database-with-resetlogs\">5. Ouvrez la base de donn\u00e9es avec resetlogs<\/h2>\n\n\n\n<p>Ex\u00e9cutez cette commande pour ouvrir la base de donn\u00e9es :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; alter database open resetlogs;\n<\/pre><\/div>\n\n\n<p>Vous devriez maintenant avoir restaur\u00e9 et r\u00e9cup\u00e9r\u00e9 votre base de donn\u00e9es.<\/p>\n\n\n\n<p>J'esp\u00e8re que cela vous a \u00e9t\u00e9 utile.<\/p>","protected":false},"excerpt":{"rendered":"<p>Voici les \u00e9tapes \u00e0 suivre pour restaurer et r\u00e9cup\u00e9rer une base de donn\u00e9es Oracle \u00e0 partir d'une sauvegarde. Vous restaurerez \u00e0 partir d'une sauvegarde compl\u00e8te. Vous devrez restaurer les fichiers de donn\u00e9es, les fichiers de contr\u00f4le et les journaux d'archives. Vous disposez d'une sauvegarde RMAN valide.<\/p>","protected":false},"author":1,"featured_media":6252,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"restore an oracle database from a backup","rank_math_title":"How to Restore an Oracle Database From a Backup","rank_math_description":"Learn how to restore an Oracle database from an RMAN backup with our step-by-step guide. Safeguard your data and ensure business continuity.","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":[111,92],"class_list":["post-6251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-recover","tag-rman"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-440731.jpeg?fit=1880%2C992&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/6251","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=6251"}],"version-history":[{"count":18,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/6251\/revisions"}],"predecessor-version":[{"id":6270,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/6251\/revisions\/6270"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/6252"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=6251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=6251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=6251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}