{"id":6228,"date":"2024-09-12T20:56:18","date_gmt":"2024-09-12T18:56:18","guid":{"rendered":"http:\/\/rootfan.com\/?p=6228"},"modified":"2026-03-10T13:04:51","modified_gmt":"2026-03-10T12:04:51","slug":"oracle-rman-duplicar-base-de-datos-desde-copia-de-seguridad","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/oracle-rman-duplicate-database-from-backup\/","title":{"rendered":"Oracle 19c RMAN Duplica Base de Datos desde Copia de Seguridad"},"content":{"rendered":"<p>Para duplicar una base de datos Oracle con las copias de seguridad que has realizado con RMAN hay varias formas de hacerlo.<\/p>\n\n\n\n<p>Aseg\u00farese de tener una copia de seguridad completa de la base de datos de origen.<\/p>\n\n\n\n<p>Las copias de seguridad se encuentran en: \/home\/oracle\/backup<\/p>\n\n\n\n<p>El primer m\u00e9todo que te mostrar\u00e9 es con un pfile m\u00ednimo, s\u00f3lo el db_name.<\/p>\n\n\n\n<p>El segundo m\u00e9todo ser\u00e1 con m\u00e1s informaci\u00f3n en el pfile.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Para ambos casos, supongamos que el ORACLE_SID es oradb2 y el db_unique_name es oradb21, c\u00e1mbielos en consecuencia.<\/p>\n\n\n\n<p>Aseg\u00farese de que existen las carpetas DB_CREATE_FILE_DEST, DB_RECOVERY_FILE_DEST y AUDIT_FILE_DEST.<\/p>\n\n\n\n<p>Si utiliza ASM, sustit\u00fayalo en consecuencia.<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>\u00cdndice<\/h2><nav><ul><li><a href=\"#1-duplicate-database-with-minimal-pfile\">1. Base de datos duplicada RMAN con pfile m\u00ednimo<\/a><\/li><li><a href=\"#2-duplicate-database-with-more-info-in-pfile\">2. Base de datos duplicada de RMAN con m\u00e1s informaci\u00f3n en el archivo p<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-duplicate-database-with-minimal-pfile\">1. Base de datos duplicada RMAN con pfile m\u00ednimo<\/h2>\n\n\n\n<p>En el fichero p s\u00f3lo se a\u00f1ade el nombre_db.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ncat $ORACLE_HOME\/dbs\/initoradb2.ora\n\n*.db_name=&#039;ORADB2&#039;\n<\/pre><\/div>\n\n\n<p>Iniciar la base de datos en modo nomount<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nstartup nomount\n<\/pre><\/div>\n\n\n<p>Se conecta a RMAN con<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nrman auxiliary \/\n<\/pre><\/div>\n\n\n<p>Este comando se ejecuta 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=\"\">\nrun\n{\nduplicate database to oradb2\nspfile\nset db_unique_name &#039;oradb21&#039;\nset control_files &#039;\/u01\/app\/oracle\/oradata\/ORADB21\/datafile\/control1.ctl&#039;\nset db_create_file_dest &#039;\/u01\/app\/oracle\/oradata&#039;\nset db_recovery_file_dest &#039;\/u01\/app\/oracle\/fra\/&#039;\nset db_recovery_file_dest_size &#039;22g&#039;\nset audit_file_dest &#039;\/u01\/app\/oracle\/audit&#039;\nset pga_aggregate_target &#039;210m&#039;\nset sga_target &#039;900m&#039;\nbackup location &#039;\/home\/oracle\/backup&#039;;\n}\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"2-duplicate-database-with-more-info-in-pfile\">2. Base de datos duplicada de RMAN con m\u00e1s informaci\u00f3n en el archivo p<\/h2>\n\n\n\n<p>La segunda opci\u00f3n es con m\u00e1s informaci\u00f3n dentro del pfile<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ncat $ORACLE_HOME\/dbs\/initoradb2.ora\n\n*.audit_file_dest=&#039;\/u01\/app\/oracle\/audit&#039;\n*.audit_trail=&#039;db&#039;\n*.compatible=&#039;19.0.0&#039;\n*.control_files=&#039;\/u01\/app\/oracle\/oradata\/ORADB21\/datafile\/control1.ctl&#039;\n*.db_block_size=8192\n*.db_create_file_dest=&#039;\/u01\/app\/oracle\/oradata&#039;\n*.db_domain=&#039;localdomain&#039;\n*.db_name=&#039;ORADB2&#039;\n*.db_unique_name=&#039;ORADB21&#039;\n*.db_recovery_file_dest=&#039;\/u01\/app\/oracle\/fra&#039;\n*.db_recovery_file_dest_size=22G\n*.diagnostic_dest=&#039;\/u01\/app\/oracle&#039;\n*.dispatchers=&#039;(PROTOCOL=TCP) (SERVICE=oradbXDB)&#039;\n*.enable_pluggable_database=true\n*.local_listener=&#039;(ADDRESS = (PROTOCOL=TCP)(HOST=srv2.localdomain)(PORT=1521))&#039;\n*.log_archive_dest_1=&#039;LOCATION=USE_DB_RECOVERY_FILE_DEST&#039;\n*.nls_language=&#039;AMERICAN&#039;\n*.nls_territory=&#039;AMERICA&#039;\n*.open_cursors=300\n*.pga_aggregate_target=200M\n*.processes=500\n*.remote_login_passwordfile=&#039;EXCLUSIVE&#039;\n*.sga_target=900M\n*.undo_tablespace=&#039;UNDOTBS1&#039;\n<\/pre><\/div>\n\n\n<p>Tienes que iniciar la base de datos en nomount<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nstartup nomount\n<\/pre><\/div>\n\n\n<p>Ahora con\u00e9ctese a RMAN<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nrman auxiliary \/\n<\/pre><\/div>\n\n\n<p>A continuaci\u00f3n, ejecute el comando duplicado.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nrun\n{\nduplicate database to oradb2\nbackup location &#039;\/home\/oracle\/backup&#039;;\n}\n<\/pre><\/div>\n\n\n<p>Espero que te haya sido \u00fatil.<\/p>","protected":false},"excerpt":{"rendered":"<p>Para duplicar una base de datos Oracle con copias de seguridad que ha tomado con RMAN hay varias formas de hacerlo. Aseg\u00farese de tener una copia de seguridad completa de la base de datos de origen. Las copias de seguridad se encuentran en: \/home\/oracle\/backup El primer m\u00e9todo que os mostrar\u00e9 es con un pfile m\u00ednimo, s\u00f3lo el db_name. El segundo m\u00e9todo ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/oracle-rman-duplicate-database-from-backup\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"Oracle 19c RMAN Duplica Base de Datos desde Copia de Seguridad\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":6229,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"rman duplicate database from backup","rank_math_title":"","rank_math_description":"Learn how to perform an Oracle 19c RMAN duplicate database from backup. Master the process of duplicating a database using RMAN.","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":[78,92],"class_list":["post-6228","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-backup","tag-rman"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-1054218-1.jpeg?fit=1880%2C1253&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/6228","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=6228"}],"version-history":[{"count":19,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/6228\/revisions"}],"predecessor-version":[{"id":6593,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/6228\/revisions\/6593"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/6229"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=6228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=6228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=6228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}