{"id":10575,"date":"2017-10-24T17:59:09","date_gmt":"2017-10-24T15:59:09","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/"},"modified":"2023-06-08T16:37:13","modified_gmt":"2023-06-08T14:37:13","slug":"standbyfilemanagement-is-set-to-manual-dont-panic","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/","title":{"rendered":"StandbyFileManagement is set to MANUAL : Don’t panic"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

As you may know the parameter STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database.
\nIt is generally recommended to set this parameter to AUTO, but it can happen that this parameter is set to MANUAL for x reasons. If this parameter is set to MANUAL, the replication will stop if we create a new tablespace, or add new data files in the primary until we manually create the same in the standby.
\nIn the article we are going to show an example of tablespace creation in our oracle 12c Dataguard environment.
\nBelow our configuration.
\n
\nDGMGRL> show configuration;
\nConfiguration - prod
\nProtection Mode: MaxPerformance
\nMembers:
\nprod - Primary database
\nproddr - Physical standby database
\nFast-Start Failover: DISABLED
\nConfiguration Status:
\nSUCCESS (status updated 30 seconds ago)
\n<\/code>
\nStandbyFileManagement is set to manual for both primary and standby databases
\n
\nDGMGRL> show database PROD StandbyFileManagement;
\nStandbyFileManagement = 'MANUAL'
\nDGMGRL> show database PRODDR StandbyFileManagement;
\nStandbyFileManagement = 'MANUAL'
\nDGMGRL>
\n<\/code>
\nLet\u2019s show data files on the primary
\n
\nSQL> select name,open_mode from v$database;
\nNAME OPEN_MODE
\n--------- --------------------
\nPROD READ WRITE
\n.
\nSQL> select name from v$datafile;
\nNAME
\n--------------------------------------------------------------------------------
\n\/u01\/app\/oracle\/oradata\/PROD\/datafile\/o1_mf_system_dymg6h55_.dbf
\n\/u01\/app\/oracle\/oradata\/PROD\/datafile\/o1_mf_sysaux_dymg6loy_.dbf
\n\/u01\/app\/oracle\/oradata\/PROD\/datafile\/o1_mf_undotbs1_dymg6nsx_.dbf
\n\/u01\/app\/oracle\/oradata\/PROD\/datafile\/o1_mf_users_dymg6o9o_.dbf
\n\/u01\/app\/oracle\/oradata\/PROD\/datafile\/o1_mf_data_dymwrtph_.dbf
\n<\/code>
\nAnd in the standby
\n
\nSQL> select name,open_mode from v$database;
\nNAME OPEN_MODE
\n--------- --------------------
\nPROD MOUNTED
\n.
\nSQL> select name from v$datafile;
\nNAME
\n--------------------------------------------------------------------------------
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_system_dymtycrm_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_sysaux_dymtytz6_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_undotbs1_dymtzbbr_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_users_dymtzko2_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_data_dymz1b8y_.dbf
\n<\/code>
\nNow let\u2019s create a tablespace in the primary database PROD. In this tablespace we create a table and insert some data inside.
\n
\nSQL> create tablespace TABDATA datafile size 100M;
\nTablespace created.
\n.
\nSQL> create table test1(id number) tablespace data;
\nTable created.
\n.
\nSQL> insert into test1 values(1);
\n1 row created.
\n.
\nSQL> commit;
\nCommit complete.
\n<\/code>
\nAnd then let\u2019s do some switches
\n
\nSQL> alter system switch logfile;
\nSystem altered.
\n.
\nSQL> alter system switch logfile;
\nSystem altered.
\n<\/code>
\nAs we may expect, this new tablespace is not automatically replicated on the standby as our StandbyFileManagement is set to MANUAL and our configuration should return errors.
\n
\nDGMGRL> show configuration;
\nConfiguration - prod
\nProtection Mode: MaxPerformance
\nMembers:
\nprod - Primary database
\nproddr - Physical standby database
\nError: ORA-16810: multiple errors or warnings detected for the member
\nFast-Start Failover: DISABLED
\nConfiguration Status:
\nERROR (status updated 9 seconds ago)
\n<\/code>
\nThe primary database is fine
\n
\nDGMGRL> show database PROD;
\nDatabase - prod
\nRole: PRIMARY
\nIntended State: TRANSPORT-ON
\nInstance(s):
\nPROD
\nDatabase Status:
\nSUCCESS
\n<\/code>
\nBut the standby is not synchronized
\n
\nDGMGRL> show database PRODDR;
\nDatabase - proddr
\nRole: PHYSICAL STANDBY
\nIntended State: APPLY-ON
\nTransport Lag: 0 seconds (computed 1 second ago)
\nApply Lag: 2 minutes 14 seconds (computed 1 second ago)
\nAverage Apply Rate: 2.00 KByte\/s
\nReal Time Query: OFF
\nInstance(s):
\nPROD
\nDatabase Error(s):
\nORA-16766: Redo Apply is stopped<\/strong>
\nDatabase Warning(s):
\nORA-16853: apply lag has exceeded specified threshold
\nDatabase Status:
\nERROR
\nDGMGRL>
\n<\/code>
\nIn the standby alert log file we can see some ORA-
\n
\nFile #6 added to control file as 'UNNAMED00006' because
\nthe parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
\nThe file should be manually created to continue.<\/strong>
\nMRP0: Background Media Recovery terminated with error 1274
\n2017-10-20T15:49:43.368202+02:00
\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/proddr\/PROD\/trace\/PROD_mrp0_7182.trc:
\nORA-01274:<\/strong> cannot add data file that was originally created as
\n'\/u01\/app\/oracle\/oradata\/PROD\/datafile\/o1_mf_tabdata_dymzqmt4_.dbf'
\nManaged Standby Recovery not using Real Time Apply
\nRecovery interrupted!
\n2017-10-20T15:49:43.448802+02:00
\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/proddr\/PROD\/trace\/PROD_m000_7250.trc:
\nORA-01110: <\/strong>data file 1: '\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_system_dymtycrm_.dbf'
\nRecovery stopped due to failure in applying recovery marker (opcode 17.30).
\nDatafiles are recovered to a consistent state at change 380449 but controlfile could be ahead of datafiles.
\n2017-10-20T15:49:43.618264+02:00
\n<\/code>
\nIf we check data files in the standby, we can see that a UNAMED new file is created in the $ORACLE_HOME\/dbs
\n
\nSQL> select name,open_mode from v$database;
\nNAME OPEN_MODE
\n--------- --------------------
\nPROD MOUNTED
\n.
\nSQL> select name from v$datafile;
\nNAME
\n----------------------------------------------------------------------------------------------------
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_system_dymtycrm_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_sysaux_dymtytz6_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_undotbs1_dymtzbbr_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_users_dymtzko2_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_data_dymz1b8y_.dbf
\n\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/dbs\/UNNAMED00006
\n6 rows selected.
\n<\/code>
\nHow can I solve the issue and restart the replication. It\u2019s easy. As I am using Oracle-Managed Files<\/strong>
\n(OMF), I first have to move the data file in the correct directory using following command.
\n
\nSQL> alter database create datafile '\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/dbs\/UNNAMED00006' as new<\/strong>;
\nDatabase altered.
\n.
\nSQL> select name from v$datafile;
\nNAME
\n----------------------------------------------------------------------------------------------------
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_system_dymtycrm_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_sysaux_dymtytz6_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_undotbs1_dymtzbbr_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_users_dymtzko2_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_data_dymz1b8y_.dbf
\n\/u01\/app\/oracle\/oradata\/PRODDR\/datafile\/o1_mf_tabdata_dyn06zm2_.dbf
\n6 rows selected.
\nSQL>
\n<\/code>
\nIf OMF is not used we have to use something like
\n
\nalter database create datafile '\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/dbs\/UNNAMED00006' as 'datafile_location_and_name';
\n<\/code>
\nAfter I decide to update the parameter standbyfilemanagement to AUTO on both primary and standby.
\n
\nDGMGRL> edit database PROD set property StandbyFileManagement = 'AUTO';
\nProperty \"standbyfilemanagement\" updated
\nDGMGRL> edit database PRODDR set property StandbyFileManagement = 'AUTO';
\nProperty \"standbyfilemanagement\" updated
\n<\/code>
\nAnd finally I have to restart the redo apply on the standby
\n
\nDGMGRL> edit database PRODDR set STATE='APPLY-ON';
\nSucceeded.
\nDGMGRL>
\n<\/code>
\nThe synchronization should be fine now and the command show configuration should return success
\n
\nDGMGRL> show configuration;
\nConfiguration - prod
\nProtection Mode: MaxPerformance
\nMembers:
\nprod - Primary database
\nproddr - Physical standby database
\nFast-Start Failover: DISABLED
\nConfiguration Status:
\nSUCCESS (status updated 15 seconds ago)
\n<\/code>
\nOn the primary database
\n
\nDGMGRL> show database PROD;
\nDatabase - prod
\nRole: PRIMARY
\nIntended State: TRANSPORT-ON
\nInstance(s):
\nPROD
\nDatabase Status:
\nSUCCESS
\n<\/code>
\nOn the standby database
\n
\nDGMGRL> show database PRODDR;
\nDatabase - proddr
\nRole: PHYSICAL STANDBY
\nIntended State: APPLY-ON
\nTransport Lag: 0 seconds (computed 0 seconds ago)
\nApply Lag: 0 seconds (computed 0 seconds ago)
\nAverage Apply Rate: 83.00 KByte\/s
\nReal Time Query: OFF
\nInstance(s):
\nPROD
\nDatabase Status:
\nSUCCESS
\nDGMGRL>
\n<\/code>
\nIf we want to verify the new created table, we can open the standby database in a read only mode.
\nBut if we don\u2019t have the Active Dataguard option, the redo apply must be stopped for the standby database before opening it.
\n
\nDGMGRL> edit database PRODDR set STATE='APPLY-OFF';
\nSucceeded.
\n<\/code>
\nAnd then open the database
\n
\nSQL> alter database open read only;
\nDatabase altered.
\n.
\nSQL> select tablespace_name from dba_tablespaces;
\nTABLESPACE_NAME
\n------------------------------
\nSYSTEM
\nSYSAUX
\nUNDOTBS1
\nTEMP
\nUSERS
\nDATA
\nTABDATA
\n7 rows selected.
\n.
\nSQL> select * from test1;
\nID
\n----------
\n1
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw As you may know the parameter STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. It is generally recommended to set this parameter to AUTO, but it can happen that […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1196,1197],"type_dbi":[],"class_list":["post-10575","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dataguard-12-2","tag-standbyfilemanagement"],"acf":[],"yoast_head":"\nStandbyFileManagement is set to MANUAL : Don't panic - 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\/standbyfilemanagement-is-set-to-manual-dont-panic\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"StandbyFileManagement is set to MANUAL : Don't panic\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw As you may know the parameter STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. It is generally recommended to set this parameter to AUTO, but it can happen that […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-24T15:59:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T14:37:13+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\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\/standbyfilemanagement-is-set-to-manual-dont-panic\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"StandbyFileManagement is set to MANUAL : Don’t panic\",\"datePublished\":\"2017-10-24T15:59:09+00:00\",\"dateModified\":\"2023-06-08T14:37:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/\"},\"wordCount\":398,\"commentCount\":0,\"keywords\":[\"Dataguard 12.2\",\"StandbyFileManagement\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/\",\"name\":\"StandbyFileManagement is set to MANUAL : Don't panic - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-10-24T15:59:09+00:00\",\"dateModified\":\"2023-06-08T14:37:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"StandbyFileManagement is set to MANUAL : Don’t panic\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"StandbyFileManagement is set to MANUAL : Don't panic - 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\/standbyfilemanagement-is-set-to-manual-dont-panic\/","og_locale":"en_US","og_type":"article","og_title":"StandbyFileManagement is set to MANUAL : Don't panic","og_description":"By Mouhamadou Diaw As you may know the parameter STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. It is generally recommended to set this parameter to AUTO, but it can happen that […]","og_url":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/","og_site_name":"dbi Blog","article_published_time":"2017-10-24T15:59:09+00:00","article_modified_time":"2023-06-08T14:37:13+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"StandbyFileManagement is set to MANUAL : Don’t panic","datePublished":"2017-10-24T15:59:09+00:00","dateModified":"2023-06-08T14:37:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/"},"wordCount":398,"commentCount":0,"keywords":["Dataguard 12.2","StandbyFileManagement"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/","url":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/","name":"StandbyFileManagement is set to MANUAL : Don't panic - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-10-24T15:59:09+00:00","dateModified":"2023-06-08T14:37:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/standbyfilemanagement-is-set-to-manual-dont-panic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"StandbyFileManagement is set to MANUAL : Don’t panic"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10575","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10575"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10575\/revisions"}],"predecessor-version":[{"id":25704,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10575\/revisions\/25704"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10575"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}