{"id":1247,"date":"2021-08-31T13:36:03","date_gmt":"2021-08-31T16:36:03","guid":{"rendered":"https:\/\/rodrigosilvaesilva.com.br\/?p=1247"},"modified":"2021-08-31T13:37:05","modified_gmt":"2021-08-31T16:37:05","slug":"dropping-redo-log-migrate-rac-to-single","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2021\/08\/31\/dropping-redo-log-migrate-rac-to-single\/","title":{"rendered":"Dropping redo log group thread Migrate RAC to Single"},"content":{"rendered":"\n<p><strong>Causa<\/strong><\/p>\n\n\n\n<p>Erro ao dropar redo instance migrada de Rac para Single<\/p>\n\n\n\n<p>SYS@OLTP&gt; alter database drop logfile group 10;<br>alter database drop logfile group 10<br>*<br>ERROR at line 1:<br>ORA-01567: dropping log 10 would leave less than 2 log files for instance oltp2 (thread 2)<br>ORA-00312: online log 10 thread 2: &#8216;\/u01\/oracle\/oradata\/OLTP\/redo_10.log&#8217;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Consultando Group Redo \/ Threads<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \">SQL&gt; select thread#, group#, members,FIRST_CHANGE#, bytes\/1024\/1024, status from v$log;\n\nTHREAD#     GROUP#    MEMBERS FIRST_CHANGE# BYTES\/1024\/1024 STATUS\n------- ---------- ---------- ------------- --------------- --------\n      1          1          1    8.1348E+10             300 CURRENT\n      1          2          1    8.1348E+10             300 ACTIVE\n      1          3          1    8.1348E+10             300 ACTIVE\n      1          4          1    8.1348E+10             300 ACTIVE\n      1          5          1    8.1348E+10             300 ACTIVE\n      2          6          1    8.1153E+10             400 INACTIVE\n      1          7          1    8.1348E+10             300 ACTIVE\n      1          8          1    8.1348E+10             300 ACTIVE\n      1          9          1    8.1348E+10             300 ACTIVE\n      2         10          1             0             400 UNUSED<\/pre><\/div>\n\n\n\n<p><strong>Consultando as threads<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:default decode:true \">SYS@OLTP &gt; select thread#,status from v$thread;\n\n   THREAD# STATUS\n---------- ------\n         1 OPEN\n         2 CLOSED\n<\/pre><\/div>\n\n\n\n<p><strong>Nesse caso como a instance \u00e9 uma Single faz sentido a THREAD 2 status CLOSED<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Desativando a Thread 2<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \"> SYS@OLTP &gt; alter database disable thread 2;\n\nDatabase altered.\n<\/pre><\/div>\n\n\n\n<p><strong>Dropando os redos da Thred 2<\/strong><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:plsql decode:true \">13:17:19 SYS@OLTP  &gt; alter database drop logfile group 10;\n\nDatabase altered.\n\nElapsed: 00:00:00.04\n13:17:28 SYS@OLTP &gt; alter database drop logfile group 6;\n\nDatabase altered.\n<\/pre><\/div>\n\n\n\n<p><strong>Obs.: Lembrar de excluir o redo fisicamente no Filesystem\/ ASM<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Causa Erro ao dropar redo instance migrada de Rac para Single SYS@OLTP&gt; alter database drop logfile group 10;alter database drop logfile group 10*ERROR at line 1:ORA-01567: dropping log 10 would leave less than 2 log files for instance oltp2 (thread 2)ORA-00312: online log 10 thread 2: &#8216;\/u01\/oracle\/oradata\/OLTP\/redo_10.log&#8217; Consultando Group Redo \/ Threads Consultando as threads&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[8,1],"tags":[412,411],"class_list":["post-1247","post","type-post","status-publish","format-aside","hentry","category-oracle","category-sem-categoria","tag-ora-00312","tag-ora-01567","post_format-post-format-aside"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1247","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=1247"}],"version-history":[{"count":5,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1247\/revisions"}],"predecessor-version":[{"id":1252,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1247\/revisions\/1252"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}