{"id":2052,"date":"2019-03-21T20:25:59","date_gmt":"2019-03-21T19:25:59","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2052"},"modified":"2019-05-16T09:45:43","modified_gmt":"2019-05-16T07:45:43","slug":"dia-49803-purge-not-possible-due-to-incompatible-schema-version","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/dia-49803-purge-not-possible-due-to-incompatible-schema-version\/","title":{"rendered":"DIA-49803: Purge not possible due to incompatible schema version."},"content":{"rendered":"<p>Hoy vamos a ver una sencilla entrada que tiene que ver con el <b>adrci<\/b> ( Interprete de comandos ADR  ).<br \/>\nEl otro dia me encontre con que algunos de los automatismos de limpieza de logs fallaban con el eror <i>DIA-49803: Purge not possible due to incompatible schema version<\/i><\/p>\n<pre>\r\n[oracle@testserver ~]$ adrci\r\nADRCI: Release 12.1.0.2.0 - Production on Thu Mar 16 09:34:45 2019\r\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\r\nADR base = \"\/u01\/app\/oracle\/admin\"\r\nadrci> show homes\r\nADR Homes: \r\ndiag\/rdbms\/test1\/TEST1\r\ndiag\/rdbms\/test2\/TEST2\r\nadrci> purge -age 180 -type alert   \r\nDIA-49803: Purge not possible due to incompatible schema version.\r\n<\/pre>\n<p>A que puede deberse esto ?<br \/>\nSi miramos en la documentacion de soporte de Oracle nos encontramos con algunos poibles bugs , como el bug <i>Bug 27718599 <\/I> o  un efecto secundario del bug <i>28375106<\/i>.<br \/>\nPero, antes de meterse en berenjenales, lo mas sencillo es intentar migrar la version de  los logs.<\/p>\n<h1> Como lo hacemos?<\/h1>\n<p>Algo tan sencillo como <\/p>\n<pre>\r\nadrci> migrate schema\r\nSchema migrated.\r\n<\/pre>\n<p>Tras la ejecucion de este sencillo comando, veremos como nuestros comandos vuelven a funcionar correctamente <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver una sencilla entrada que tiene que ver con el adrci ( Interprete de comandos ADR ). El otro dia me encontre con que algunos de los automatismos de limpieza de logs fallaban con el eror DIA-49803: &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/dia-49803-purge-not-possible-due-to-incompatible-schema-version\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[565,567,921,9,66],"tags":[179,970],"class_list":["post-2052","post","type-post","status-publish","format-standard","hentry","category-11g-en","category-12c-en","category-18c","category-dummie","category-errores-ora","tag-adrci","tag-dia-49803"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2052"}],"version-history":[{"count":4,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2052\/revisions"}],"predecessor-version":[{"id":2056,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2052\/revisions\/2056"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2052"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}