{"id":1618,"date":"2021-04-10T10:28:29","date_gmt":"2021-04-10T08:28:29","guid":{"rendered":"http:\/\/rootfan.com\/?p=1618"},"modified":"2022-04-04T00:17:58","modified_gmt":"2022-04-03T22:17:58","slug":"activar-el-modo-de-registro-de-archivo-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/enable-archive-log-mode-oracle\/","title":{"rendered":"C\u00f3mo Habilitar el Modo de Registro de Archivo en Oracle 19c"},"content":{"rendered":"<p>Si desea activar el modo de registro de archivo en su base de datos Oracle porque desea realizar una copia de seguridad de su base de datos mientras est\u00e1 abierta, debe seguir estos sencillos pasos.<\/p>\n\n\n\n<p>Ten en cuenta que tendr\u00e1s que reiniciar tu base de datos.<\/p>\n\n\n\n<p>As\u00ed que all\u00e1 vamos.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Primero con\u00e9ctate como sysdba y haz algunas comprobaciones<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 10 12:09:10 2021\nVersion 19.8.0.0.0\n\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.8.0.0.0\n\nSQL&gt; SELECT LOG_MODE FROM V$DATABASE;\n\nLOG_MODE\n------------\nNOARCHIVELOG\n\nSQL&gt; show parameter LOG_ARCHIVE_DEST_1\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_1                   string\nlog_archive_dest_10                  string\nlog_archive_dest_11                  string\nlog_archive_dest_12                  string\nlog_archive_dest_13                  string\nlog_archive_dest_14                  string\nlog_archive_dest_15                  string\nlog_archive_dest_16                  string\nlog_archive_dest_17                  string\nlog_archive_dest_18                  string\nlog_archive_dest_19                  string\n\nSQL&gt; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = &#039;LOCATION=USE_DB_RECOVERY_FILE_DEST&#039; scope=both;\n\nSystem altered.\n<\/pre><\/div>\n\n\n<p>Ahora debe detener la base de datos Oracle y montarla.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSQL&gt; SHUTDOWN IMMEDIATE\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n\nSQL&gt; STARTUP MOUNT\nORACLE instance started.\n\nTotal System Global Area 1073738888 bytes\nFixed Size                  9143432 bytes\nVariable Size             532676608 bytes\nDatabase Buffers          524288000 bytes\nRedo Buffers                7630848 bytes\nDatabase mounted.\n\nSQL&gt; ALTER DATABASE ARCHIVELOG;\n\nDatabase altered.\n\nSQL&gt; ALTER DATABASE OPEN;\n\nDatabase altered.\n\nSQL&gt; ALTER SYSTEM SWITCH LOGFILE;\n\nSystem altered.\n<\/pre><\/div>\n\n\n<p>Ahora puede comprobar que el modo de registro de archivo est\u00e1 activado en su base de datos Oracle.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSQL&gt; SELECT NAME FROM V$ARCHIVED_LOG;\n\nNAME\n--------------------------------------------------------------------------------\n\/u01\/app\/oracle\/fra\/ORADB\/archivelog\/2021_04_10\/o1_mf_1_19_j72qftrw_.arc\n\nSQL&gt; SELECT LOG_MODE FROM V$DATABASE;\n\nLOG_MODE\n------------\nARCHIVELOG\n\nSQL&gt; show parameter LOG_ARCHIVE_DEST_1\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_1                   string      LOCATION=USE_DB_RECOVERY_FILE_\n                                                 DEST\nlog_archive_dest_10                  string\nlog_archive_dest_11                  string\nlog_archive_dest_12                  string\nlog_archive_dest_13                  string\nlog_archive_dest_14                  string\nlog_archive_dest_15                  string\nlog_archive_dest_16                  string\nlog_archive_dest_17                  string\nlog_archive_dest_18                  string\nlog_archive_dest_19                  string\n<\/pre><\/div>\n\n\n<p>Espero que te haya sido \u00fatil.<\/p>","protected":false},"excerpt":{"rendered":"<p>Si desea activar el modo de registro de archivo en su base de datos Oracle porque desea realizar una copia de seguridad de su base de datos mientras est\u00e1 abierta, siga estos sencillos pasos. Ten en cuenta que tendr\u00e1s que reiniciar tu base de datos. As\u00ed que aqu\u00ed vamos.<\/p>","protected":false},"author":1,"featured_media":2927,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"enable archive log mode in oracle 19c","rank_math_title":"","rank_math_description":"Enable archive log mode in Oracle 19c effortlessly. Follow this step-by-step tutorial to activate archive log mode in Oracle 19c.","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":[77,78],"class_list":["post-1618","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-archive","tag-backup"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-688660.jpeg?fit=1733%2C1300&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1618","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=1618"}],"version-history":[{"count":8,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1618\/revisions"}],"predecessor-version":[{"id":1626,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1618\/revisions\/1626"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2927"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=1618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=1618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=1618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}