{"id":9044,"date":"2016-10-11T10:26:57","date_gmt":"2016-10-11T08:26:57","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/"},"modified":"2016-10-11T10:26:57","modified_gmt":"2016-10-11T08:26:57","slug":"otn-appreciation-day-advm","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/","title":{"rendered":"OTN Appreciation Day : ADVM"},"content":{"rendered":"<p>Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. Here is my favorite feature: <a href=\"http:\/\/docs.oracle.com\/database\/121\/OSTMG\/GUID-B7A61F3B-C22A-4021-A846-F5EA749E79FF.htm#OSTMG32000\" target=\"_blank\">ADVM<\/a> &#8211; The Oracle ASM Dynamic Volume Manager.<\/p>\n<p><!--more--><\/p>\n<p>So, what is it? The docs tell you this: &#8220;Oracle ASM Dynamic Volume Manager (Oracle ADVM) provides volume management services and a standard disk device driver interface to clients. File systems and other disk-based applications send I\/O requests to Oracle ADVM volume devices as they would to other storage devices on a vendor operating system.&#8221; <\/p>\n<p>The easy to understand version is this: It enables us to use regular file systems on top of ASM.<\/p>\n<p>Does is make sense to use it? When you have ASM running on the host or all the hosts of a Grid Infrastructure cluster anyway then it definitely makes sense. ASM will do all the mirroring and striping for you so there is no need to use another technology to achieve that when you can create ADVM volumes and create file systems on top of these. Although the most common scenario is to create an <a href=\"http:\/\/docs.oracle.com\/database\/121\/OSTMG\/GUID-579FDDA5-7D18-4A01-B3D6-906B6DB93851.htm#OSTMG94163\" target=\"_blank\">ACFS file system<\/a> on top of the volumes you are actually not limited to that. Lets do a short demo.<\/p>\n<p>Lets say we have these devices available for use by the grid user:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[root@rac1 ~] ls -la \/dev\/sd[b-f]*\nbrw-rw----. 1 root disk     8, 16 Oct 10 17:54 \/dev\/sdb\nbrw-rw----. 1 grid asmadmin 8, 17 Oct 10 18:10 \/dev\/sdb1\nbrw-rw----. 1 root disk     8, 32 Oct 10 17:54 \/dev\/sdc\nbrw-rw----. 1 grid asmadmin 8, 33 Oct 10 18:10 \/dev\/sdc1\nbrw-rw----. 1 root disk     8, 48 Oct 10 17:54 \/dev\/sdd\nbrw-rw----. 1 grid asmadmin 8, 49 Oct 10 18:10 \/dev\/sdd1\nbrw-rw----. 1 root disk     8, 64 Oct 10 17:54 \/dev\/sde\nbrw-rw----. 1 grid asmadmin 8, 65 Oct 10 18:10 \/dev\/sde1\nbrw-rw----. 1 root disk     8, 80 Oct 10 17:54 \/dev\/sdf\nbrw-rw----. 1 grid asmadmin 8, 81 Oct 10 18:10 \/dev\/sdf1\n<\/pre>\n<p>We want to use &#8220;\/dev\/sde1&#8221; for our new ADVM volume. What we need is an ASM diskgroup in a first step because for creating an ADVM volume you&#8217;ll need a ASM diskgroup where you can place your volume on:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ngrid@rac1:\/home\/grid\/ [+ASM1] sqlplus \/ as sysasm\nSQL&gt; create diskgroup ADVM external redundancy disk '\/dev\/sde1';\n\nDiskgroup created.\n\nSQL&gt; \n<\/pre>\n<p>Ok, fine. How can we proceed with creating a volume? Quite easy:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ngrid@rac1:\/home\/grid\/ [+ASM1] asmcmd volcreate -G ADMV -s 2g VOLADVM\nORA-15032: not all alterations performed\nORA-15221: ASM operation requires compatible.asm of 11.2.0.0.0 or higher (DBD ERROR: OCIStmtExecute)\n<\/pre>\n<p>Hm, quite clear when you search the documentation: ADVM is available since 11gR2:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search.png\" alt=\"advm_search\" width=\"1336\" height=\"662\" class=\"aligncenter size-full wp-image-11641\" \/><\/a><\/p>\n<p>Easy to fix:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ngrid@rac1:\/home\/grid\/ [+ASM1] sqlplus \/ as sysasm\n\nSQL&gt; alter diskgroup ADVM set attribute 'compatible.asm'='12.1';\n\nDiskgroup altered.\n\nSQL&gt; \n<\/pre>\n<p>Lets try again:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ngrid@rac1:\/home\/grid\/ [+ASM1] asmcmd volcreate -G ADMV -s 2g VOLADVM\ngrid@rac1:\/home\/grid\/ [+ASM1] \n<\/pre>\n<p>Perfect. Now I have a volume visible to the operating system:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ngrid@rac1:\/home\/grid\/ [+ASM1] ls -la \/dev\/asm\/*advm*\nbrwxrwx---. 1 root asmadmin 252, 115201 Oct 10 18:20 \/dev\/asm\/voladvm-225\n<\/pre>\n<p>On top of this volume we can now create file systems. The natural one would be ACFS:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[root@rac1 ~] mkfs.acfs \/dev\/asm\/voladvm-225\nmkfs.acfs: version                   = 12.1.0.2.0\nmkfs.acfs: on-disk version           = 39.0\nmkfs.acfs: volume                    = \/dev\/asm\/voladvm-225\nmkfs.acfs: volume size               = 2147483648  (   2.00 GB )\nmkfs.acfs: Format complete.\n<\/pre>\n<p>But in fact every other file system the operating system supports is possible, too:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n[root@rac1 ~] mkfs.xfs \/dev\/asm\/voladvm-225\nmeta-data=\/dev\/asm\/voladvm-225   isize=256    agcount=4, agsize=131072 blks\n         =                       sectsz=512   attr=2, projid32bit=1\n         =                       crc=0        finobt=0\ndata     =                       bsize=4096   blocks=524288, imaxpct=25\n         =                       sunit=0      swidth=0 blks\nnaming   =version 2              bsize=4096   ascii-ci=0 ftype=0\nlog      =internal log           bsize=4096   blocks=2560, version=2\n         =                       sectsz=512   sunit=0 blks, lazy-count=1\nrealtime =none                   extsz=4096   blocks=0, rtextents=0\n<\/pre>\n<p>Quite cool, isn&#8217;t it? Whatever file system your operating system supports can be put on ASM disk groups &#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. Here is my favorite feature: ADVM &#8211; The Oracle ASM Dynamic Volume Manager.<\/p>\n","protected":false},"author":29,"featured_media":9046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[951,37,96],"type_dbi":[],"class_list":["post-9044","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-advm","tag-asm","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>OTN Appreciation Day : ADVM - 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\/otn-appreciation-day-advm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OTN Appreciation Day : ADVM\" \/>\n<meta property=\"og:description\" content=\"Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. Here is my favorite feature: ADVM &#8211; The Oracle ASM Dynamic Volume Manager.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-11T08:26:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1336\" \/>\n\t<meta property=\"og:image:height\" content=\"662\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\\\/otn-appreciation-day-advm\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"OTN Appreciation Day : ADVM\",\"datePublished\":\"2016-10-11T08:26:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/\"},\"wordCount\":364,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/advm_search-1.png\",\"keywords\":[\"ADVM\",\"ASM\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/\",\"name\":\"OTN Appreciation Day : ADVM - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/advm_search-1.png\",\"datePublished\":\"2016-10-11T08:26:57+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/advm_search-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/advm_search-1.png\",\"width\":1336,\"height\":662},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/otn-appreciation-day-advm\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OTN Appreciation Day : ADVM\"}]},{\"@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\\\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\\\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\\\/\\\/x.com\\\/westermanndanie\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/daniel-westermann\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"OTN Appreciation Day : ADVM - 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\/otn-appreciation-day-advm\/","og_locale":"en_US","og_type":"article","og_title":"OTN Appreciation Day : ADVM","og_description":"Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. Here is my favorite feature: ADVM &#8211; The Oracle ASM Dynamic Volume Manager.","og_url":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/","og_site_name":"dbi Blog","article_published_time":"2016-10-11T08:26:57+00:00","og_image":[{"width":1336,"height":662,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search-1.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"OTN Appreciation Day : ADVM","datePublished":"2016-10-11T08:26:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/"},"wordCount":364,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search-1.png","keywords":["ADVM","ASM","Oracle"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/","url":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/","name":"OTN Appreciation Day : ADVM - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search-1.png","datePublished":"2016-10-11T08:26:57+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/advm_search-1.png","width":1336,"height":662},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/otn-appreciation-day-advm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"OTN Appreciation Day : ADVM"}]},{"@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\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9044","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9044"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9044\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9046"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9044"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}