{"id":1761,"date":"2017-08-27T20:23:58","date_gmt":"2017-08-27T18:23:58","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=1761"},"modified":"2017-08-27T20:24:27","modified_gmt":"2017-08-27T18:24:27","slug":"ora-16179-incremental-changes-to-log_archive_dest_1-not-allowed-with-spfile","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/ora-16179-incremental-changes-to-log_archive_dest_1-not-allowed-with-spfile\/","title":{"rendered":"ORA-16179: incremental changes to \u201clog_archive_dest_1\u201d not allowed with SPFILE"},"content":{"rendered":"<p>Vamos a ver una peque\u00f1a entrada r\u00e1pida muy muy de dummie sobre un error ORA-XX<\/p>\n<p>Intentando modificar el par\u00e1metro de los archivers de mi CDB de pruebas me encuentro con que, al  ejecutar <\/p>\n<pre>\r\nalter system set LOG_ARCHIVE_DEST_1 ='LOCATION   =\/u01\/app\/oracle\/oradata\/cdbtest\/archivelog\/' scope=both sid='*'\r\n<\/pre>\n<p>Recibimo el error <\/p>\n<pre>\r\nERROR at line 1:\r\nORA-32017: failure in updating SPFILE\r\nORA-16179: incremental changes to \"log_archive_dest_1\" not allowed with SPFILE\r\n<\/pre>\n<p>Si miramos la configuraci\u00f3n del archivado<\/p>\n<pre>\r\nSQL>  archive log list\r\nDatabase log mode\t       Archive Mode\r\nAutomatic archival\t       Enabled\r\nArchive destination\t       \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/dbs\/arch\r\nOldest online log sequence     38\r\nNext log sequence to archive   40\r\nCurrent log sequence\t       40\r\n<\/pre>\n<p>Despu\u00e9s de muchas muchas vueltas, he visto lo sencilla que era la soluci\u00f3n .<br \/>\nLa cl\u00e1usula <b>LOCATION<\/b> de og_archive_dest_1 no puede tener espacios.<br \/>\nAs\u00ed pues <\/p>\n<p>&#8216;LOCATION  = \/path\/&#8217;; -> <font color=red> ERROR<\/font><br \/>\n&#8216;LOCATION=\/path\/&#8217;; -> <font color=green> CORRECTO<\/font><\/p>\n<p>Como veis, otra de las soluciones sencillas a problemas que pueden traernos de cabeza!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vamos a ver una peque\u00f1a entrada r\u00e1pida muy muy de dummie sobre un error ORA-XX Intentando modificar el par\u00e1metro de los archivers de mi CDB de pruebas me encuentro con que, al ejecutar alter system set LOG_ARCHIVE_DEST_1 =&#8217;LOCATION =\/u01\/app\/oracle\/oradata\/cdbtest\/archivelog\/&#8217; scope=both &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/ora-16179-incremental-changes-to-log_archive_dest_1-not-allowed-with-spfile\/\">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":[60,744,9,66],"tags":[589,623,625,28],"class_list":["post-1761","post","type-post","status-publish","format-standard","hentry","category-12c","category-cdbpdb","category-dummie","category-errores-ora","tag-archiver","tag-log_archive_dest_1","tag-ora-16179","tag-spfile"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1761","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=1761"}],"version-history":[{"count":4,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1761\/revisions"}],"predecessor-version":[{"id":1765,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1761\/revisions\/1765"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1761"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}