{"id":13115,"date":"2019-11-29T09:07:15","date_gmt":"2019-11-29T08:07:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/"},"modified":"2019-11-29T09:07:15","modified_gmt":"2019-11-29T08:07:15","slug":"dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/","title":{"rendered":"dbvisit dbvctl process is terminating abnormally with Error Code: 2044"},"content":{"rendered":"<p>When applying archive logs on the standby, dbvctl process can terminate abnormally with Error Code: 2044. This can happen in case there are several archive logs with huge size to be applied.<br \/>\n<!--more--><\/p>\n<h3>Problem description<\/h3>\n<p>With dbvisit there is 2 ways to recover the archive log on the standby, either using sqlplus or rman. By default the configuration is set to sqlplus. It can happen that, following a maintenance windows where synchronization had to be suspended, a huge gap is faced between the primary and the standby databases. Several archive logs need to be applied. Problem is even more visible if the size of the archive log files is big. In my case there were about 34 archive logs to be applied following a maintenance activity and size of each file was 8 GB. <\/p>\n<p>Applying the archive logs on the standby failed as seen in the following output.<\/p>\n<p><code>oracle@server_name:\/u01\/app\/dbvisit\/standby\/ [DB_name] .\/dbvctl -d DDC_name<br \/>\n=============================================================<br \/>\nDbvisit Standby Database Technology (8.0.20_0_g7e6bd51b) (pid 1939)<br \/>\ndbvctl started on server_name: Mon Oct 28 16:19:01 2019<br \/>\n=============================================================<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&gt;&gt;&gt; Applying Log file(s) from primary_server to DB_name on standby_server:<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\nDbvisit Standby terminated...<br \/>\nError Code: 2044<br \/>\nFile (\/u01\/app\/dbvisit\/standby\/tmp\/1939.dbvisit.201910281619.sqlplus.dbv) does not<br \/>\nexist or is empty. Please check space and file permissions.<br \/>\n&nbsp;<br \/>\nTracefile from server: server_name (PID:1939)<br \/>\n1939_dbvctl_DB_name_201910281619.trc<br \/>\n&nbsp;<br \/>\noracle@server_name:\/u01\/app\/dbvisit\/standby\/ [DB_name] ls -l \/u01\/app\/dbvisit\/standby\/tmp\/1939.dbvisit.201910281619.sqlplus.dbv<br \/>\nls: cannot access \/u01\/app\/dbvisit\/standby\/tmp\/1939.dbvisit.201910281619.sqlplus.dbv: No such file or directory<\/code><\/p>\n<h3>Solution<\/h3>\n<p>To solve this problem, you can change DDC configuration on the primary to use RMAN to apply archive log, at least time the gap is caught up. You will have to synchronize the standby configuration as well.<br \/>\nTo use RMAN, set APPLY_ARCHIVE_RMAN parameter to Y in the DDC configuration file. <\/p>\n<p>Procedure is described below :<\/p>\n<h4>Backup the DDC configuration file<\/h4>\n<p><code>oracle@server_name:\/u01\/app\/dbvisit\/standby\/ [DB_name] cd conf<br \/>\noracle@server_name:\/u01\/app\/dbvisit\/standby\/conf\/ [DB_name] cp -p dbv_DCC_name.env dbv_DCC_name.env.20191028<\/code><\/p>\n<h4>Change the parameter<\/h4>\n<p><code>oracle@server_name:\/u01\/app\/dbvisit\/standby\/conf\/ [DB_name] vi dbv_DCC_name.env<br \/>\noracle@server_name:\/u01\/app\/dbvisit\/standby\/conf\/ [DB_name] diff dbv_DCC_name.env dbv_DCC_name.env.20191028<br \/>\n543c543<br \/>\n  APPLY_ARCHIVE_RMAN = Y<br \/>\n---<br \/>\n  APPLY_ARCHIVE_RMAN = N<\/code><\/p>\n<h4>Send the configuration changes to the standby<\/h4>\n<p><code>oracle@server_name:\/u01\/app\/dbvisit\/standby\/conf\/ [DB_name] cd ..<br \/>\noracle@server_name:\/u01\/app\/dbvisit\/standby\/ [DB_name] .\/dbvctl -d DCC_name -C<br \/>\n=============================================================<br \/>\nDbvisit Standby Database Technology (8.0.20_0_g7e6bd51b) (pid 9318)<br \/>\ndbvctl started on server_name: Mon Oct 28 16:51:45 2019<br \/>\n=============================================================<br \/>\n&nbsp;<br \/>\n&gt;&gt;&gt; Dbvisit Standby configurational differences found between primary_server and standby_server.<br \/>\n    Synchronised.<br \/>\n&nbsp;<br \/>\n=============================================================<br \/>\ndbvctl ended on server_name: Mon Oct 28 16:51:52 2019<br \/>\n=============================================================<\/code><\/p>\n<h4>Apply archive log on the standby again and it will be completed successfully<\/h4>\n<p><code>oracle@server_name:\/u01\/app\/dbvisit\/standby\/ [DB_name] .\/dbvctl -d DDC_name<br \/>\n=============================================================<br \/>\nDbvisit Standby Database Technology (8.0.20_0_g7e6bd51b) (pid 50909)<br \/>\ndbvctl started on server_name: Mon Oct 28 16:53:05 2019<br \/>\n=============================================================<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&gt;&gt;&gt; Applying Log file(s) from from primary_server to DB_name on standby_server:<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n    Next SCN required for recovery 3328390017 generated at 2019-10-28:11:57:42 +01:00.<br \/>\n    Next log(s) required for recovery:<br \/>\n    thread 1 sequence 77553<br \/>\n&gt;&gt;&gt; Searching for new archive logs under \/u03\/app\/oracle\/dbvisit_arch\/DB_name_SITE2... done<br \/>\n    thread 1 sequence 77553 (1_77553_973158276.arc)<br \/>\n    thread 1 sequence 77554 (1_77554_973158276.arc)<br \/>\n    thread 1 sequence 77555 (1_77555_973158276.arc)<br \/>\n    thread 1 sequence 77556 (1_77556_973158276.arc)<br \/>\n    thread 1 sequence 77557 (1_77557_973158276.arc)<br \/>\n    thread 1 sequence 77558 (1_77558_973158276.arc)<br \/>\n    thread 1 sequence 77559 (1_77559_973158276.arc)<br \/>\n    thread 1 sequence 77560 (1_77560_973158276.arc)<br \/>\n    thread 1 sequence 77561 (1_77561_973158276.arc)<br \/>\n    thread 1 sequence 77562 (1_77562_973158276.arc)<br \/>\n    thread 1 sequence 77563 (1_77563_973158276.arc)<br \/>\n    thread 1 sequence 77564 (1_77564_973158276.arc)<br \/>\n    thread 1 sequence 77565 (1_77565_973158276.arc)<br \/>\n    thread 1 sequence 77566 (1_77566_973158276.arc)<br \/>\n    thread 1 sequence 77567 (1_77567_973158276.arc)<br \/>\n    thread 1 sequence 77568 (1_77568_973158276.arc)<br \/>\n    thread 1 sequence 77569 (1_77569_973158276.arc)<br \/>\n    thread 1 sequence 77570 (1_77570_973158276.arc)<br \/>\n    thread 1 sequence 77571 (1_77571_973158276.arc)<br \/>\n    thread 1 sequence 77572 (1_77572_973158276.arc)<br \/>\n    thread 1 sequence 77573 (1_77573_973158276.arc)<br \/>\n    thread 1 sequence 77574 (1_77574_973158276.arc)<br \/>\n&gt;&gt;&gt; Catalog archives... done<br \/>\n&gt;&gt;&gt; Recovering database... done<br \/>\n    Last applied log(s):<br \/>\n    thread 1 sequence 77574<br \/>\n&nbsp;<br \/>\n    Next SCN required for recovery 3331579974 generated at 2019-10-28:16:50:18 +01:00.<br \/>\n    Next required log thread  sequence<br \/>\n&nbsp;<br \/>\n&gt;&gt;&gt; Dbvisit Archive Management Module (AMM)<br \/>\n&nbsp;<br \/>\n    Config: number of archives to keep      = 0<br \/>\n    Config: number of days to keep archives = 7<br \/>\n    Config: diskspace full threshold        = 80%<br \/>\n==========<br \/>\n&nbsp;<br \/>\nProcessing \/u03\/app\/oracle\/dbvisit_arch\/DB_name_SITE2...<br \/>\n    Archive log dir: \/u03\/app\/oracle\/dbvisit_arch\/DB_name_SITE2<br \/>\n    Total number of archive files   : 1025<br \/>\n    Number of archive logs deleted = 8<br \/>\n    Current Disk percent full       : 51%<br \/>\n&nbsp;<br \/>\n=============================================================<br \/>\ndbvctl ended on server_name: Mon Oct 28 17:10:36 2019<br \/>\n=============================================================<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When applying archive logs on the standby, dbvctl process can terminate abnormally with Error Code: 2044. This can happen in case there are several archive logs with huge size to be applied.<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[372,790,96],"type_dbi":[],"class_list":["post-13115","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-dbvisit","tag-disaster-recovery","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>dbvisit dbvctl process is terminating abnormally with Error Code: 2044 - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"dbvisit dbvctl process is terminating abnormally with Error Code: 2044\" \/>\n<meta property=\"og:description\" content=\"When applying archive logs on the standby, dbvctl process can terminate abnormally with Error Code: 2044. This can happen in case there are several archive logs with huge size to be applied.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-29T08:07:15+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"dbvisit dbvctl process is terminating abnormally with Error Code: 2044\",\"datePublished\":\"2019-11-29T08:07:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/\"},\"wordCount\":237,\"commentCount\":0,\"keywords\":[\"dbvisit\",\"disaster recovery\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/\",\"name\":\"dbvisit dbvctl process is terminating abnormally with Error Code: 2044 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2019-11-29T08:07:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"dbvisit dbvctl process is terminating abnormally with Error Code: 2044\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"dbvisit dbvctl process is terminating abnormally with Error Code: 2044 - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/","og_locale":"en_US","og_type":"article","og_title":"dbvisit dbvctl process is terminating abnormally with Error Code: 2044","og_description":"When applying archive logs on the standby, dbvctl process can terminate abnormally with Error Code: 2044. This can happen in case there are several archive logs with huge size to be applied.","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/","og_site_name":"dbi Blog","article_published_time":"2019-11-29T08:07:15+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"dbvisit dbvctl process is terminating abnormally with Error Code: 2044","datePublished":"2019-11-29T08:07:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/"},"wordCount":237,"commentCount":0,"keywords":["dbvisit","disaster recovery","Oracle"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/","name":"dbvisit dbvctl process is terminating abnormally with Error Code: 2044 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2019-11-29T08:07:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-dbvctl-process-is-terminating-abnormally-with-error-code-2044\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"dbvisit dbvctl process is terminating abnormally with Error Code: 2044"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=13115"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13115\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13115"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}