{"id":1370,"date":"2017-07-11T15:40:58","date_gmt":"2017-07-11T18:40:58","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=1370"},"modified":"2018-02-01T16:55:27","modified_gmt":"2018-02-01T19:55:27","slug":"ora-08104-problema-ao-cancelar-criacao-de-um-index-online","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/ora-08104-problema-ao-cancelar-criacao-de-um-index-online\/","title":{"rendered":"ORA-08104 Problema ao cancelar a Cria\u00e7\u00e3o de um index online"},"content":{"rendered":"<p><span style=\"font-family: 'times new roman', times, serif;\">E ai galera!<\/span><br \/>\n<span style=\"font-family: 'times new roman', times, serif;\"> Alguns dias atr\u00e1s passei por esse problema ao parar a cria\u00e7\u00e3o de um \u00edndex Online que foi o erro <strong>ORA-08104<\/strong>\u00a0, pode ser visto no alert.log com a mensagem<\/span><\/p>\n<p><span style=\"font-family: 'times new roman', times, serif;\"><strong>online index (re)build cleanup: objn=24584040 maxretry=2000 forever=0<\/strong><\/span><br \/>\n<span style=\"font-family: 'times new roman', times, serif;\"> A solu\u00e7\u00e3o e simples,vamos executar um bloco com uma rotina que agilizara a limpeza do objeto. O erro \u00e9 causado por um bug : <strong>BUG:3805539<\/strong> e pode ser solucionado executando a rotina abaixo:<\/span><br \/>\n<span style=\"font-family: 'times new roman', times, serif;\"> <strong>1- Verificando o objeto com problemas<\/strong><\/span><\/p>\n<pre class=\"lang:default decode:true \">select obj#,flags from ind$ where obj#=24584040;\r\n---------------------------------------------------------------------\r\nOBJ# FLAGS\r\n---------- ----------\r\n24584040 256\r\n-------------------------------------------------------------------------------------<\/pre>\n<p>&nbsp;<br \/>\n<span style=\"font-family: 'times new roman', times, serif;\"> <strong>2- Executando a rotina de limpeza com SYS<\/strong><\/span><\/p>\n<pre class=\"lang:default decode:true \">declare\r\nisclean boolean;\r\nbegin\r\nisclean :=false;\r\nwhile isclean=false\r\nloop\r\nisclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN(dbms_repair.all_index_id,dbms_repair.lock_wait);\r\ndbms_lock.sleep(10);\r\nend loop;\r\nend;\r\n\/\r\n\r\nSQL&gt;\r\nSQL&gt;\r\nSQL&gt; declare\r\nisclean boolean;\r\nbegin\r\nisclean :=false;\r\nwhile isclean=false\r\nloop\r\nisclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN(dbms_repair.all_index_id,dbms_repair.lock_wait);\r\ndbms_lock.sleep(10);\r\nend loop;\r\nend;\r\n\/ 2 3 4 5 6 7 8 9 10 11\r\n\r\nPL\/SQL procedure successfully completed.<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: 'times new roman', times, serif;\"><strong>3- Verificando novamente o objeto com problemas<\/strong><\/span><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; select obj#,flags from ind$ where obj#=24584040;\r\n\r\nno rows selected<\/pre>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: 'times new roman', times, serif;\"><strong>Referencia<\/strong><\/span><br \/>\n<span style=\"font-family: 'times new roman', times, serif;\"> <strong> Oracle Support Doc ID 375856.1 &amp; 1378173.1<\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>E ai galera! Alguns dias atr\u00e1s passei por esse problema ao parar a cria\u00e7\u00e3o de um \u00edndex Online que foi o erro ORA-08104\u00a0, pode ser visto no alert.log com a mensagem online index (re)build cleanup: objn=24584040 maxretry=2000 forever=0 A solu\u00e7\u00e3o e simples,vamos executar um bloco com uma rotina que agilizara a limpeza do objeto. O erro \u00e9 causado por um bug : BUG:3805539 e pode ser solucionado executando a rotina abaixo: 1- Verificando o objeto[&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1370"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=1370"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1370\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=1370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=1370"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=1370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}