{"id":5259,"date":"2023-03-11T09:01:06","date_gmt":"2023-03-11T08:01:06","guid":{"rendered":"http:\/\/rootfan.com\/?p=5259"},"modified":"2023-09-17T11:37:55","modified_gmt":"2023-09-17T09:37:55","slug":"oracle-rman-recuperar-base-de-datos-hasta-tiempo","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/oracle-rman-recover-database-until-time\/","title":{"rendered":"Oracle RMAN Recuperar Base de Datos Hasta Tiempo"},"content":{"rendered":"<p>En muchos casos es necesario recuperar una base de datos Oracle hasta tiempo atr\u00e1s o un <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/bradv\/rman-performing-flashback-dbpitr.html#GUID-7D3EE2F7-77A2-4264-8875-CC0AEC64ABE0\" rel=\"nofollow noopener\" target=\"_blank\">recuperaci\u00f3n puntual<\/a> porque hubo alg\u00fan tipo de error o alguien se equivoc\u00f3.<\/p>\n\n\n\n<p>Primero hay que apagar la base de datos e iniciarla en estado de montaje.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshutdown immediate\nstartup mount\n<\/pre><\/div>\n\n\n<p>Entonces puede ejecutar este comando dentro de RMAN despu\u00e9s de conectarse con rman target \/ o con un cat\u00e1logo si tambi\u00e9n tiene uno.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nrun {\nset until time &quot;to_date(&#039;22-07-2019 16:30:00&#039;,&#039;DD-MM-YYYY HH24:MI:SS&#039;)&quot;;\nrestore database;\nrecover database;\nalter database open resetlogs;\n}\n<\/pre><\/div>\n\n\n<p>Despu\u00e9s de esto, se aconseja hacer una copia de seguridad completa de la base de datos.<\/p>","protected":false},"excerpt":{"rendered":"<p>En muchos casos se necesita recuperar una base de datos Oracle hasta un momento en el pasado o un punto en el tiempo de recuperaci\u00f3n porque hubo alg\u00fan tipo de error o alguien cometi\u00f3 un error. Primero necesitas apagar la base de datos e iniciarla en estado montado. A continuaci\u00f3n, puede ejecutar este comando dentro de RMAN ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/oracle-rman-recover-database-until-time\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"Oracle RMAN Recuperar Base de Datos Hasta Tiempo\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":5270,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"oracle rman recover database until time","rank_math_title":"","rank_math_description":"Learn how to recover an Oracle database until a specific time using RMAN for precise data restoration.","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":[92],"class_list":["post-5259","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-rman"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-709552-1.jpeg?fit=1880%2C1253&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/5259","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=5259"}],"version-history":[{"count":6,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/5259\/revisions"}],"predecessor-version":[{"id":5266,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/5259\/revisions\/5266"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/5270"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=5259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=5259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=5259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}