{"id":10677,"date":"2017-11-30T10:58:20","date_gmt":"2017-11-30T09:58:20","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/"},"modified":"2017-11-30T10:58:20","modified_gmt":"2017-11-30T09:58:20","slug":"transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/","title":{"rendered":"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots"},"content":{"rendered":"

If you store your databases on the cluster filesystem ACFS you may use the provided Perl-script gDBClone<\/a> from OTN to clone databases or create snapshot databases. It is an interesting approach to create clones from the Production DB in minutes regardless of the production DB size. What you do is to create a standby DB from your production DB on a separate cluster and use that standby DB as a Gold\/Master copy for ACFS snapshots. <\/p>\n

In a Production environment with Data Guard Broker we wanted to use that technique, but were confronted with an issue:<\/p>\n

The Production DB had already a physical standby DB with the Data Guard Broker running. The protection mode was MaxAvailability, which means transport of the redo in sync mode. The master\/gold copy to get the snapshots from should receive the redo data in async mode. How to achieve that?<\/p>\n

Actually you can achieve it by adding a standby database and set the database property LogXptMode = ‘ASYNC’, but that would add a “non-production” database to your production broker configuration.<\/p>\n

There is an alternative. Not very common parameters in a Broker configuration are<\/p>\n


\nExternalDestination1
\nExternalDestination2
\n<\/code><\/p>\n

With those parameters (which are available in 11.2.0.4 and 12.1.0.2 onwards) you actually can send your redo to a destination in async mode. The parameters are documented as follows:
\n
\nThe ExternalDestination1 configuration property is used to specify a redo transport destination that can receive redo data from the current primary database. To set up transport of redo data to the specified destination, the broker uses the values specified for this parameter to define a LOG_ARCHIVE_DEST_n initialization parameter on the primary database. The broker also monitors the health of the transport to the specified destination.<\/p>\n

After a role change, the broker automatically sets up a LOG_ARCHIVE_DEST_n initialization parameter on the new primary database to ship redo data to the specified destination.<\/p>\n

I.e. you can set the parameter the same as LOG_ARCHIVE_DEST_n, but the following options are not allowed:<\/p>\n

ALTERNATE
\nDELAY
\nLOCATION
\nMANDATORY
\nMAX_FAILURE
\nNET_TIMEOUT
\nSYNC
\nVALID_FOR
\n<\/em><\/p>\n

So let’s assume I created my DB GOLDCOP as a standby DB using the rman duplicate command<\/p>\n


\nRMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
\n<\/code><\/p>\n

or alternatively using<\/p>\n


\n# .\/gDBClone clone -sdbname PRIM -sdbscan scoda7 -tdbname GOLDCOP -tdbhome OraDb11g_home1 -dataacfs \/cloudfs -standby
\n<\/code><\/p>\n

In the broker configuration I added the DB GOLDCOP as follows:
\n
\nDGMGRL> show configuration;
\n 
\nConfiguration - MYPROD
\n 
\n Protection Mode: MaxAvailability
\n Databases:
\n PRIM - Primary database
\n STBY - Physical standby database
\n 
\nFast-Start Failover: DISABLED
\n 
\nConfiguration Status:
\nSUCCESS
\n 
\nDGMGRL> edit configuration set property ExternalDestination1 = 'service=goldcop db_unique_name=GOLDCOP noaffirm async';
\nProperty \"externaldestination1\" updated
\nDGMGRL> show configuration;
\n 
\nConfiguration - MYPROD
\n 
\n Protection Mode: MaxAvailability
\n Databases:
\n PRIM - Primary database
\n STBY - Physical standby database
\n GOLDCOP - External destination 1
\n 
\nFast-Start Failover: DISABLED
\n 
\nConfiguration Status:
\nSUCCESS
\n<\/code><\/p>\n

Let’s check if I really do NOAFFIRM ASYNC redo transport on PRIM:
\n
\nSQL> select DEST_NAME, DB_UNIQUE_NAME, AFFIRM, TRANSMIT_MODE from v$archive_dest where dest_id in (2,3);
\n 
\nDEST_NAME DB_UNIQUE_NAME AFF TRANSMIT_MOD
\n-------------------------------- ------------------------------ --- ------------
\nLOG_ARCHIVE_DEST_2 STBY YES PARALLELSYNC
\nLOG_ARCHIVE_DEST_3 GOLDCOP NO ASYNCHRONOUS
\n<\/code><\/p>\n

The external destination is not a database in the configuration:
\n
\nDGMGRL> show database \"GOLDCOP\";
\nObject \"GOLDCOP\" was not found
\n<\/code><\/p>\n

But the transport to its destination is monitored by the Broker. I.e. when shutting down the DB GOLDCOP I do get an error:
\n
\nDGMGRL> show configuration;
\n 
\nConfiguration - MYPROD
\n 
\n Protection Mode: MaxAvailability
\n Databases:
\n PRIM - Primary database
\n Error: ORA-16778: redo transport error for one or more databases
\n 
\n STBY - Physical standby database
\n GOLDCOP - External destination 1
\n 
\nFast-Start Failover: DISABLED
\n 
\nConfiguration Status:
\nERROR
\n 
\nDGMGRL> show instance \"PRIM\";
\n 
\nInstance 'PRIM' of database 'PRIM'
\n 
\n Instance Error(s):
\n ORA-16737: the redo transport service for standby database \"GOLDCOP\" has an error
\n 
\nInstance Status:
\nERROR
\n<\/code><\/p>\n

As the External destination 1 is not “a database” in the broker configuration, it actually also does not matter if the broker is started (dg_broker_start=TRUE) at the external destination GOLDCOP or not.
\nTo start applying redo on the external destination, you have to start managed recovery as you would without a broker configuration:
\n
\nalter database recover managed standby database using current logfile disconnect from session;
\n<\/code><\/p>\n

And redo real time apply is happening on GOLDCOP:
\n
\nSQL> select name,value
\n 2 from v$dataguard_stats
\n 3 where name in ('apply lag','transport lag');
\n 
\nNAME VALUE
\n-------------------- --------------------
\ntransport lag +00 00:00:00
\napply lag +00 00:00:00
\n 
\nSQL>
\nSQL> select inst_id,process,pid,status,thread#,sequence#, block#
\n 2 from gv$managed_standby
\n 3 where process like 'MRP%';
\n 
\n INST_ID PROCESS PID STATUS THREAD# SEQUENCE# BLOCK#
\n---------- --------- ---------- ------------ ---------- ---------- ----------
\n 1 MRP0 5155 APPLYING_LOG 1 50 420
\n<\/code><\/p>\n

To make the external destination self managing I did set the archivelog deletion policy on GOLDCOP to
\n
\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
\n<\/code>
\nin rman so that applied archives become reclaimable automatically in the fast recovery area. In addition I set
\n
\nfal_server='PRIM'
\n<\/code><\/p>\n

on GOLDCOP to ensure that archive gaps can be resolved.<\/p>\n

The pro’s of above configuration are:
\n– the GOLDCOP-DB does not cause much overhead for my Production DB (async redo transport).
\n– Decoupling my GOLDCOP DB from Primary (temporarily) is fast and easy:
\nedit configuration set property ExternalDestination1 = '';<\/code><\/p>\n

REMARK: Of course I do also have the other advantages of the gDBClone-approach:
\n– A production copy on a separate cluster which serves as a gold-copy to take snapshots from for testing or development purposes.
\n– Creating a snapshot database takes minutes regardless of the DB size.<\/p>\n

Con’s:
\n– I have to take care to start managed standby database recovery on my GOLDCOP-DB. I.e. the same as when running data guard without the Broker.<\/p>\n

To create a snapshot DB I just do something like:<\/p>\n


\n# .\/gDBClone snap -sdbname GOLDCOP -tdbname PRODCOP1
\n<\/code><\/p>\n

Et voil\u00e0 a production copy in 2 minutes.<\/p>\n

If PRODCOP1 is no longer needed I can delete it:<\/p>\n


\n# .\/gDBClone deldb -tdbname PRODCOP1
\n<\/code><\/p>\n

Besides using the configuration property ExternalDestination1 there are other possibilities in 12c to run a standby DB as a master copy for snapshots without affecting the production system (like e.g. the support of cascaded standby DBs in the Broker), but I still think that the external destinations feature offers a good possibility to run a master copy.<\/p>\n","protected":false},"excerpt":{"rendered":"

If you store your databases on the cluster filesystem ACFS you may use the provided Perl-script gDBClone from OTN to clone databases or create snapshot databases. It is an interesting approach to create clones from the Production DB in minutes regardless of the production DB size. What you do is to create a standby DB […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[600,1236,1237,221,1238,1239,1240],"type_dbi":[],"class_list":["post-10677","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-acfs","tag-async","tag-broker","tag-data-guard","tag-externaldestination1","tag-externaldestination2","tag-gdbclone"],"acf":[],"yoast_head":"\nTransfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots - 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\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots\" \/>\n<meta property=\"og:description\" content=\"If you store your databases on the cluster filesystem ACFS you may use the provided Perl-script gDBClone from OTN to clone databases or create snapshot databases. It is an interesting approach to create clones from the Production DB in minutes regardless of the production DB size. What you do is to create a standby DB […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-30T09:58:20+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots\",\"datePublished\":\"2017-11-30T09:58:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/\"},\"wordCount\":743,\"commentCount\":0,\"keywords\":[\"ACFS\",\"async\",\"Broker\",\"Data Guard\",\"ExternalDestination1\",\"ExternalDestination2\",\"gDBClone\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/\",\"name\":\"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-11-30T09:58:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots\"}]},{\"@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\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots - 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\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/","og_locale":"en_US","og_type":"article","og_title":"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots","og_description":"If you store your databases on the cluster filesystem ACFS you may use the provided Perl-script gDBClone from OTN to clone databases or create snapshot databases. It is an interesting approach to create clones from the Production DB in minutes regardless of the production DB size. What you do is to create a standby DB […]","og_url":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/","og_site_name":"dbi Blog","article_published_time":"2017-11-30T09:58:20+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots","datePublished":"2017-11-30T09:58:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/"},"wordCount":743,"commentCount":0,"keywords":["ACFS","async","Broker","Data Guard","ExternalDestination1","ExternalDestination2","gDBClone"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/","url":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/","name":"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-11-30T09:58:20+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/transfer-redo-in-async-mode-to-the-goldmaster-copy-of-the-production-db-for-acfs-snapshots\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Transfer redo in async-mode to the Gold\/Master copy of the Production DB for ACFS snapshots"}]},{"@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\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10677","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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10677"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10677\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10677"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}