{"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":"como-restaurar-una-base-de-datos-oracle-a-partir-de-una-copia-de-seguridad","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/how-to-restore-an-oracle-database-from-a-backup\/","title":{"rendered":"C\u00f3mo restaurar una base de datos Oracle a partir de una copia de seguridad"},"content":{"rendered":"<p>Estos son los pasos para restaurar y recuperar una base de datos Oracle a partir de una copia de seguridad.<\/p>\n\n\n\n<p>Restaurar\u00e1s a partir de una copia de seguridad completa.<\/p>\n\n\n\n<p>Tendr\u00e1s que restaurar los archivos de datos, los archivos de control y los archivos de registro.<\/p>\n\n\n\n<p>Dispone de una copia de seguridad RMAN v\u00e1lida.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Mis archivos de copia de seguridad se encuentran en la carpeta:<\/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>\u00cdndice<\/h2><nav><ul><li><a href=\"#1-restore-the-spfile-from-the-backup\">1. Restaurar el spfile desde la copia de seguridad<\/a><\/li><li><a href=\"#2-restore-the-control-file\">2. Restaurar el archivo de control<\/a><\/li><li><a href=\"#3-catalog-the-rman-backups\">3. Catalogar las copias de seguridad RMAN<\/a><\/li><li><a href=\"#4-restore-and-recover-the-oracle-database\">4. Restaurar y recuperar la base de datos Oracle<\/a><\/li><li><a href=\"#5-open-the-database-with-resetlogs\">5. Abra la base de datos con resetlogs<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<p>Debe ejecutar los comandos con el usuario oracle e instanciar su base de datos con . oraenv. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-restore-the-spfile-from-the-backup\">1. Restaurar el spfile desde la copia de seguridad<\/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>Deber\u00edas saber d\u00f3nde est\u00e1 el archivo spfile dentro de los archivos de copia de seguridad.<\/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. Restaurar el archivo de control<\/h2>\n\n\n\n<p>Con\u00e9ctese a sqlplus para comprobar d\u00f3nde se restaurar\u00e1n los archivos de control.<\/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>Normalmente la copia de seguridad del fichero de control se encuentra en el \u00faltimo fichero generado por RMAN al realizar la copia de seguridad.<\/p>\n\n\n\n<p>Restaura el fichero de control y monta la base de datos.<\/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. Catalogar las copias de seguridad 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. Restaurar y recuperar la base de datos Oracle<\/h2>\n\n\n\n<p>Ejecutar la restauraci\u00f3n y recuperaci\u00f3n dentro de un bloque 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>Es posible que aparezca este error, pero no deber\u00eda ser un problema<\/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. Abra la base de datos con resetlogs<\/h2>\n\n\n\n<p>Ejecute este comando para abrir la base de datos:<\/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>Y ahora deber\u00edas tener tu base de datos restaurada y recuperada.<\/p>\n\n\n\n<p>Espero que te haya sido \u00fatil.<\/p>","protected":false},"excerpt":{"rendered":"<p>Estos son los pasos para restaurar y recuperar una base de datos Oracle a partir de una copia de seguridad. Restaurar\u00e1s a partir de una copia de seguridad completa. Tendr\u00e1s que restaurar datafiles, controlfiles y archivelogs. Dispone de una copia de seguridad RMAN v\u00e1lida.<\/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\/es\/wp-json\/wp\/v2\/posts\/6251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=6251"}],"version-history":[{"count":18,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/6251\/revisions"}],"predecessor-version":[{"id":6270,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/6251\/revisions\/6270"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/6252"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=6251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=6251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=6251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}