{"id":1953,"date":"2021-01-05T02:07:31","date_gmt":"2021-01-05T02:07:31","guid":{"rendered":"https:\/\/swiv.com.br\/changing-the-oracle-database-archiving-mode\/"},"modified":"2026-05-27T20:02:53","modified_gmt":"2026-05-27T19:02:53","slug":"changing-the-oracle-database-archiving-mode","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/01\/05\/changing-the-oracle-database-archiving-mode\/","title":{"rendered":"Changing the Oracle Database Archiving mode"},"content":{"rendered":"\n<p>Consultando modo atual no Oracle (neste caso, o recurso est\u00e1 em archivelog mode):<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel7 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 4 22:45:53 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL&gt; ARCHIVE LOG LIST;\nDatabase log mode              Archive Mode\nAutomatic archival             Enabled\nArchive destination            +DG_RECO\nOldest online log sequence     17\nNext log sequence to archive   19\nCurrent log sequence           19\nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Para desabilitar o log mode do banco, \u00e9 necess\u00e1rio que o mesmo esteja no status MOUNTED.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; shu immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL&gt; startup mount;\nORACLE instance started.\n \nTotal System Global Area 2583690520 bytes\nFixed Size                  8899864 bytes\nVariable Size             553648128 bytes\nDatabase Buffers         2013265920 bytes\nRedo Buffers                7876608 bytes\nDatabase mounted.\nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Para definir o NOARCHIVELOG mode, basta rodar o seguinte comando:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; ALTER DATABASE NOARCHIVELOG;\n \nDatabase altered.\n<\/pre><\/div>\n\n\n<p>Abrindo o banco e verificando o seu novo modo:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; ALTER DATABASE OPEN;\n \nDatabase altered.\n \nSQL&gt; ARCHIVE LOG LIST;\nDatabase log mode              No Archive Mode\nAutomatic archival             Disabled\nArchive destination            +DG_RECO\nOldest online log sequence     17\nCurrent log sequence           19\nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Para habilitar o archive log mode, basta fazer o processo inverso, como abaixo:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; shu immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL&gt; STARTUP MOUNT;\nORACLE instance started.\n \nTotal System Global Area 2583690520 bytes\nFixed Size                  8899864 bytes\nVariable Size             553648128 bytes\nDatabase Buffers         2013265920 bytes\nRedo Buffers                7876608 bytes\nDatabase mounted.\nSQL&gt; ALTER DATABASE ARCHIVELOG;\n \nDatabase altered.\n \nSQL&gt; ALTER DATABASE OPEN;\n \nDatabase altered.\n \nSQL&gt; ARCHIVE LOG LIST;\nDatabase log mode              Archive Mode\nAutomatic archival             Enabled\nArchive destination            +DG_RECO\nOldest online log sequence     17\nNext log sequence to archive   19\nCurrent log sequence           19\nSQL&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Consultando modo atual no Oracle (neste caso, o recurso est\u00e1 em archivelog mode): Para desabilitar o log mode do banco, \u00e9 necess\u00e1rio que o mesmo esteja no status MOUNTED. Para definir o NOARCHIVELOG mode, basta rodar o seguinte comando: Abrindo o banco e verificando o seu novo modo: Para habilitar o archive log mode, basta [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[19],"class_list":["post-1953","post","type-post","status-publish","format-standard","hentry","category-administration","category-backup-recovery","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1953","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1953"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1953\/revisions"}],"predecessor-version":[{"id":9282,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1953\/revisions\/9282"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}