{"id":125,"date":"2018-04-17T20:00:49","date_gmt":"2018-04-17T23:00:49","guid":{"rendered":"http:\/\/wordpress.rodrigosilvaesilva.com.br\/?p=125"},"modified":"2018-04-17T20:00:49","modified_gmt":"2018-04-17T23:00:49","slug":"habilitando-archivelog","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/17\/habilitando-archivelog\/","title":{"rendered":"Habilitando ARCHIVELOG"},"content":{"rendered":"<h6>Consulta view v$databases<\/h6>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL &gt; select log_mode from v$database;\n\nLOG_MODE\n------------\nNOARCHIVELOG\n<\/pre>\n<h6>Baixar o banco<\/h6>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL&gt; shut immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n<\/pre>\n<h6>Iniciar o banco modo Mount<\/h6>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL&gt; startup mount\nORACLE instance started.\n\nTotal System Global Area 4275781632 bytes\nFixed Size                  2260088 bytes\nVariable Size            1157628808 bytes\nDatabase Buffers         3103784960 bytes\nRedo Buffers               12107776 bytes\nDatabase mounted.\n<\/pre>\n<h6>Habilitar modo Archivelog<\/h6>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL&gt; alter database archivelog;\nalter database set archivelog<\/pre>\n<h6>Alterando status para Open<\/h6>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt; alter database open;\n\nDatabase altered.<\/pre>\n<h6>Verificando status<\/h6>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt; select status from v$instance;\n\nSTATUS\n------------\nOPEN\n<\/pre>\n<h6>Consulta view v$database<\/h6>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt; select log_mode from v$database;\n\nLOG_MODE\n------------\nARCHIVELOG<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Consulta view v$databases SYS@ORCL &gt; select log_mode from v$database; LOG_MODE &#8212;&#8212;&#8212;&#8212; NOARCHIVELOG Baixar o banco SYS@ORCL&gt; shut immediate Database closed. Database dismounted. ORACLE instance shut down. Iniciar o banco modo Mount SYS@ORCL&gt; startup mount ORACLE instance started. Total System Global Area 4275781632 bytes Fixed Size 2260088 bytes Variable Size 1157628808 bytes Database Buffers 3103784960 bytes&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[45,184,327,375],"class_list":["post-125","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-archivelog","tag-log_mode","tag-select-log_mode-from-vdatabase","tag-vdatabase"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=125"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/125\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}