{"id":24086,"date":"2023-03-28T18:56:11","date_gmt":"2023-03-28T16:56:11","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=24086"},"modified":"2023-03-28T18:56:12","modified_gmt":"2023-03-28T16:56:12","slug":"considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/","title":{"rendered":"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)"},"content":{"rendered":"\n

To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using platforms like Exadata Cloud at Customer. I recently had a case where both the Primary and the Standby site had the same NFS-location mounted and used that as the location for backups.<\/p>\n\n\n\n

REMARK: To protect against ransomware attacks, products like Cohesity provide NFS-targets with a Write Once Read Many (WORM) mechanism. I.e. backups can be written, but are then immutable and hence cannot be modified by ransomware.<\/p>\n\n\n\n

To be able to backup your Oracle DBs from the Primary and Standby site to shared NFS and also be able to restore and recover the DB on Primary and Standby site from shared NFS a couple of things have to be considered:<\/p>\n\n\n\n

Visibility of Backups<\/h4>\n\n\n\n

Backups written to disk are only visible on the site, which created the backup. Backups to tape are visible on Primary and Standby site. In any case an rman catalog has to be used to see backups from both sites. Below the rman-documentation<\/a> concerning this topic:<\/p>\n\n\n\n

In a Data Guard environment, the recovery catalog considers disk backups as accessible only to the database with which they are associated, whereas tape backups created on one database are accessible to all databases.
\u2026
Note:
You can transfer a backup from a standby host to a primary host or vice versa, connect as TARGET to the database on this host, and then use the CATALOG command to catalog the backup. After a file is cataloged by the target database, the file is associated with the target database.<\/em><\/p>\n\n\n\n

REMARK: You may use the following command in RMAN to make backups of the other site visible in your session:<\/p>\n\n\n\n

RMAN> SET BACKUP FILES FOR DEVICE TYPE DISK TO ACCESSIBLE;<\/code><\/pre>\n\n\n\n
My colleague has blogged<\/a> about it some time ago. <\/p>\n\n\n\n
The issue is that this is not persistent and has to be set for every RMAN-session again. I.e. an archivelog deletion policy “BACKED UP 1 TIMES TO DISK” is not considered for backups from the other site after using above command.<\/p>\n\n\n\n
So only catalogued backups are visible. I.e. we need an rman-job, which catalogs backups done on the other site regularly.<\/p>\n\n\n\n
RMAN-Connection with password required<\/h4>\n\n\n\n
Doing backups on the Standby site requires an RMAN-connection to the DB with a password. I.e. <\/p>\n\n\n\n
RMAN> connect target sys\/mysupersecretpwd<\/code><\/pre>\n\n\n\n
instead of<\/p>\n\n\n\n
RMAN> connect target \/<\/code><\/pre>\n\n\n\n
because a consistent backup needs the redo, which was produced during the backup. I.e. at the end of the e.g. INC0-backup the current online redo has to be archived. That operation has to be done on the Primary site. To do that, rman needs the credentials to login to the Primary site to archive the redo on Primary to be able to back it up at the standby site.<\/p>\n\n\n\n
See MOS Note “RMAN-06820 ORA-17629 During Backup at Standby Site (Doc ID 1616074.1)”<\/p>\n\n\n\n
Retention policy on Standby site<\/h4>\n\n\n\n
A command “CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF x DAYS;” fails on the Standby-Site with RMAN-05021. E.g.<\/p>\n\n\n\n
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;\n\nresync only records later than timestamp 1128819277\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of configure command at 02\/15\/2023 13:47:08\nRMAN-05021: this configuration cannot be changed for a BACKUP or STANDBY control file<\/code><\/pre>\n\n\n\n
The workaround is to NOT use the command on standby and instead either<\/p>\n\n\n\n
    \n
  • set it on Primary and recreate the standby controlfile<\/li>\n\n\n\n
  • or use the retention policy in the delete obsolete statements. E.g.<\/li>\n<\/ul>\n\n\n\n
    delete noprompt obsolete recovery window of <RET_POLICY> days device type disk;<\/code><\/pre>\n\n\n\n
    See MOS Note “RMAN-5021 this configuration cannot be changed for a BACKUP or STANDBY (Doc ID 1519386.1)”<\/p>\n\n\n\n
    Snapshot controlfile with unique name per site<\/h4>\n\n\n\n
    If your snapshot controlfile is on the shared backup location you should make sure to provide a unique name for the standby controlfile on primary and standby. E.g. on Primary:<\/p>\n\n\n\n
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '\/my_nfs_backup\/snapcf_P_MYDB.f';<\/code><\/pre>\n\n\n\n
    And on Standby:<\/p>\n\n\n\n
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '\/my_nfs_backup\/snapcf_S_MYDB.f';<\/code><\/pre>\n\n\n\n
    Make sure the standby is in synch with the Primary before starting the backup<\/h4>\n\n\n\n
    You may want to check that the standby DB is in synch with the primary before starting a backup.<\/p>\n\n\n\n
    With the broker active the following SQL can be used on the standby DB to check if there is a lag:<\/p>\n\n\n\n
    SELECT\nCASE \n   WHEN decode(value,'+00 00:00:00','no lag',NULL,'unknown','lag')='no lag' AND (sysdate-to_date(time_computed,'mm\/dd\/yyyy hh24:mi:ss'))*60*60*24 < 31\n   THEN 'no_lag'\n   WHEN decode(value,'+00 00:00:00','no lag',NULL,'unknown','lag')='lag'\n   THEN 'lag'\n   ELSE 'unknown'\nEND LAG\nfrom dual, v$dataguard_stats where decode(dummy,'X','apply lag')=name(+) ;<\/code><\/pre>\n\n\n\n
    Please consider that I do not allow any lag (should be in synch), but I do allow the lag computation to be from up to 30 seconds ago. E.g. when looking at DGMGRL’s command “show configuration lag” then I would show no lag in the following case:<\/p>\n\n\n\n
    Apply Lag:          0 seconds (computed 20 seconds ago)<\/code><\/pre>\n\n\n\n
    But I would show a lag here:<\/p>\n\n\n\n
    Apply Lag:          1 seconds (computed 1 second ago)<\/code><\/pre>\n\n\n\n
    ARCHIVELOG DELETION POLICY considerations<\/h4>\n\n\n\n
    The ARCHIVELOG DELETION POLICY should be adjusted when writing archivelogs to the Fast Recovery Area and doing backups on the standby site. I.e. archived redo has to become reclaimable when it has been applied to the standby site(s) and has been backed up. Usually we do use the following setting:<\/p>\n\n\n\n
    On the site where backups happen: <\/p>\n\n\n\n
    RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY  BACKED UP 1 TIMES TO DISK;<\/code><\/pre>\n\n\n\n
    On the site where no backups happen: <\/p>\n\n\n\n
    RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;<\/code><\/pre>\n\n\n\n
    If archivelog backups have been catalogued at both sites (i.e. at the site which hasn’t done the backup) then both sites can use<\/p>\n\n\n\n
    RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY  BACKED UP 1 TIMES TO DISK;<\/code><\/pre>\n\n\n\n
    to make the archived redo in the Fast Recovery Area reclaimable, which has been applied on all standby and has been backed up.<\/p>\n\n\n\n
    Summary<\/h3>\n\n\n\n
    So in summary you should consider the following when backing up on Primary and Standby (or only on Standby) to a “disk” visible on both Primary and Standby:<\/p>\n\n\n\n
      \n
    • use an rman catalog<\/li>\n\n\n\n
    • catalog all backups regularly on the site which didn’t do the backup
      E.g. with
      RMAN> catalog start with ‘\/rman_disk_backup’ noprompt;
      This is necessary to “see” all backups on both sites. If you restore a database on a site which haven’t done all backups then you should catalog before doing restore and recovery.<\/li>\n\n\n\n
    • provide a password when connecting to the DB for a backup on the standby site
      E.g. with
      RMAN> connect target sys\/mysupersecretpwd@standby_site
      Otherwise archiving of the current redo after the backup is not possible and would make the backup “incomplete” as the archivelog to recover to a consistent point is not available in the backup.<\/li>\n\n\n\n
    • if the snapshot controlfile is on the shared NFS storage then make sure to have a unique name for both sites<\/li>\n\n\n\n
    • you should check that the standby DB is in synch with the primary before starting a backup<\/li>\n\n\n\n
    • when changing the retention policy then do that on the primary site and recreate the standby controlfile. Alternatively always specify the retention when doing a “delete obsolete”.
      E.g.
      delete noprompt obsolete recovery window of 31 days device type disk;<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
      To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using platforms like Exadata Cloud at Customer. I recently had a case where both the Primary […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[202,2893,2742,112,96,270,238],"type_dbi":[],"class_list":["post-24086","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-backup","tag-backup-to-disk","tag-data-guard-2","tag-nfs","tag-oracle","tag-rman","tag-standby"],"acf":[],"yoast_head":"\nConsiderations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS) - 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\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)\" \/>\n<meta property=\"og:description\" content=\"To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using platforms like Exadata Cloud at Customer. I recently had a case where both the Primary […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-28T16:56:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-28T16:56:12+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=\"6 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\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)\",\"datePublished\":\"2023-03-28T16:56:11+00:00\",\"dateModified\":\"2023-03-28T16:56:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/\"},\"wordCount\":1065,\"commentCount\":0,\"keywords\":[\"Backup\",\"backup to disk\",\"Data Guard\",\"NFS\",\"Oracle\",\"RMAN\",\"Standby\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/\",\"name\":\"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2023-03-28T16:56:11+00:00\",\"dateModified\":\"2023-03-28T16:56:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)\"}]},{\"@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":"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS) - 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\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/","og_locale":"en_US","og_type":"article","og_title":"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)","og_description":"To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using platforms like Exadata Cloud at Customer. I recently had a case where both the Primary […]","og_url":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/","og_site_name":"dbi Blog","article_published_time":"2023-03-28T16:56:11+00:00","article_modified_time":"2023-03-28T16:56:12+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)","datePublished":"2023-03-28T16:56:11+00:00","dateModified":"2023-03-28T16:56:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/"},"wordCount":1065,"commentCount":0,"keywords":["Backup","backup to disk","Data Guard","NFS","Oracle","RMAN","Standby"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/","url":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/","name":"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2023-03-28T16:56:11+00:00","dateModified":"2023-03-28T16:56:12+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/considerations-when-backing-up-from-the-oracle-standby-database-data-guard-with-rman-to-shared-storage-nfs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)"}]},{"@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\/24086","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=24086"}],"version-history":[{"count":8,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24086\/revisions"}],"predecessor-version":[{"id":24115,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24086\/revisions\/24115"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=24086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=24086"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=24086"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=24086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}