{"id":1970,"date":"2018-10-24T21:37:59","date_gmt":"2018-10-24T19:37:59","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=1970"},"modified":"2018-10-26T10:48:46","modified_gmt":"2018-10-26T08:48:46","slug":"ora-38870-cannot-backup-a-control-file-that-may-have-incorrect-data-file-structure","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/ora-38870-cannot-backup-a-control-file-that-may-have-incorrect-data-file-structure\/","title":{"rendered":"ORA-38870: cannot backup a control file that may have incorrect data file structure."},"content":{"rendered":"<p>Hoy vamos a volver con una entrada rapida de un problema muy facil de solucionar.<\/p>\n<p>A veces, podemos encnontrarnos en el alert.log con el error <\/p>\n<pre>\r\nORA-38870:cannot backup a control file that may have incorrect data file structure\r\n<\/pre>\n<p>Si miramos las trazas asustan bastante <\/p>\n<pre>\r\n2018-10-23T16:08:43.542081+02:00\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/test_stby\/test\/trace\/test_m000_425.trc:\r\nORA-38870: cannot backup a control file that may have incorrect data file structure.\r\n2018-10-23T16:13:43.189251+02:00\r\nStarting control autobackup\r\n********************  WARNING ***************************\r\nThe errors during Server autobackup are not fatal, as it\r\nis attempted after sucessful completion of the command.\r\nHowever, it is recomended to take an RMAN control file\r\nbackup as soon as possible because the Autobackup failed\r\nwith the following error:\r\nORA-38870: cannot backup a control file that may have incorrect data file structure.\r\n********************  END OF WARNING *******************\r\n<\/pre>\n<p>Pero, buscando en la  documentacion de Oracle, nos contraremos que <\/p>\n<h1>Error code: ORA-38870<\/h1>\n<p><b>Description:<\/b> cannot backup a control file that may have incorrect data file structure.<br \/>\n<b<Cause:<\/b> This control file was created or converted based on a control file from a time different from the time of the database.<br \/>\n<b>Action:<\/b> Open database read-only to synchronize the control file with the database dictionary to fix the control file<\/p>\n<p>Cualquier cosa relaccionada con una estructura invalida de un controlfile puede asustar bastante, pero , este alarmante problema se soluciona de manera muy rapida y sencilla, simplemente haciendo eso, abriendo la base de datos en modo lectura.<br \/>\nY ya no volveremos a ver mas el problema <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a volver con una entrada rapida de un problema muy facil de solucionar. A veces, podemos encnontrarnos en el alert.log con el error ORA-38870:cannot backup a control file that may have incorrect data file structure Si miramos las &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/ora-38870-cannot-backup-a-control-file-that-may-have-incorrect-data-file-structure\/\">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":[11,60,52,66],"tags":[249,254,58,873,945],"class_list":["post-1970","post","type-post","status-publish","format-standard","hentry","category-11g","category-12c","category-dataguard","category-errores-ora","tag-11g","tag-12c","tag-alert-log","tag-dataguard","tag-ora-38870"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1970","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=1970"}],"version-history":[{"count":5,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1970\/revisions"}],"predecessor-version":[{"id":1975,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1970\/revisions\/1975"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1970"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}