{"id":4859,"date":"2015-06-12T07:39:55","date_gmt":"2015-06-12T05:39:55","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/"},"modified":"2015-06-12T07:39:55","modified_gmt":"2015-06-12T05:39:55","slug":"convert-a-snapshot-standby-to-a-new-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/","title":{"rendered":"Convert a snapshot standby to a new database"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nA snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back to physical standby. But you don’t want to stay in that state definitely because you will accumulate archived logs from the changes done to the primary, and flashback logs for the changes made to the snapshot standby.<\/p>\n

Here I’ll show how to finish it when you want a permanent new database. You can use that when you want to do a duplicate, but don’t know in advance which point-in-time should be used. Then you just configure a physical standby, convert it to snapshot standby, maybe flashback it the the required point. And once you have found the right point, then you finish it to have a new database name and DBID.<\/p>\n

The primary database<\/h3>\n

Here is the primary on host VM111, db name is DEMO11 and db unique name is DEMO11.
\nI’m checking the DBID:<\/p>\n

[oracle@VM111 ~]$ rman target \/\nRecovery Manager: Release 12.1.0.2.0 - Production on Thu May 28 22:36:07 2015\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\nconnected to target database: DEMO11 (DBID=684456715)\n<\/code><\/pre>\n
Data Guard configuration<\/h3>\n
The standby is on VM112, db name is DEMO11 and db unique name is DEMO12:<\/p>\n
[oracle@VM112 ~]$ dgmgrl \/\nDGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production\nCopyright (c) 2000, 2013, Oracle. All rights reserved.\nWelcome to DGMGRL, type \"help\" for information.\nConnected as SYSDG.\n\nDGMGRL> show database demo12\n\nDatabase - demo12\n\n  Role:               PHYSICAL STANDBY\n  Intended State:     APPLY-ON\n  Transport Lag:      0 seconds (computed 1 second ago)\n  Apply Lag:          0 seconds (computed 1 second ago)\n  Average Apply Rate: 52.00 KByte\/s\n  Real Time Query:    ON\n  Instance(s):\n    DEMO12\n\nDatabase Status:\nSUCCESS\n<\/code><\/pre>\n
I’ve a standby that is in sync.<\/p>\n
Snapshot standby<\/h3>\n
I want to convert that standby to a new database. For the moment, I’ll only convert to a snapshot standby, so that I can flashback if I need to apply more archived logs later and start again from another point.<\/p>\n
DGMGRL> convert database demo12 to snapshot standby;\nConverting database \"demo12\" to a Snapshot Standby database, please wait...\nDatabase \"demo12\" converted successfully\n<\/code><\/pre>\n
A restore point has been automatically created in order to be able to flashback to the point where log apply can continue:<\/p>\n
RMAN> list restore point all;\n\nusing target database control file instead of recovery catalog\nSCN              RSP Time  Type       Time      Name\n---------------- --------- ---------- --------- ----\n2156577                    GUARANTEED 28-MAY-15 SNAPSHOT_STANDBY_REQUIRED_05\/28\/2015 22:36:46\n<\/code><\/pre>\n
Log shipping<\/h3>\n
The snapshot standby is a database that is open read-write. The only difference with a new database (a duplicate for example) is that the DBID is still the same as the primary. But the advantage is that it stills receives the archived log and can be converted back to a standby database. Look at the primary and switch a few logfiles:<\/p>\n
[oracle@VM111 ~]$ sqlplus \/ as sysdba\nSQL*Plus: Release 12.1.0.2.0 Production on Thu May 28 22:39:36 2015\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nSQL> archive log list\nDatabase log mode              Archive Mode\nAutomatic archival             Enabled\nArchive destination            USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence     47\nNext log sequence to archive   49\nCurrent log sequence           49\nSQL> alter system switch logfile;\nSystem altered.\nSQL> alter system switch logfile;\nSystem altered.\n<\/code><\/pre>\n
and check at the standby site:<\/p>\n
[oracle@VM112 ~]$ NLS_DATE_FORMAT='dd-mon-yy hh24:mi:ss' rman target \/\nRecovery Manager: Release 12.1.0.2.0 - Production on Thu May 28 22:41:35 2015\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\nconnected to target database: DEMO11 (DBID=684456715)\n\nRMAN> list archivelog all;\n...\n44      1    49      A 28-may-15 22:39:32\n        Name: \/u02\/DEMO\/fast_recovery_area\/DEMO12\/archivelog\/2015_05_28\/o1_mf_1_49_bpgz9pxt_.arc\n45      1    50      A 28-may-15 22:40:22\n        Name: \/u02\/DEMO\/fast_recovery_area\/DEMO12\/archivelog\/2015_05_28\/o1_mf_1_50_bpgzbbjs_.arc\n46      1    51      A 28-may-15 22:40:42\n        Name: \/u02\/DEMO\/fast_recovery_area\/DEMO12\/archivelog\/2015_05_28\/o1_mf_1_51_bpgzbg5x_.arc\n<\/code><\/pre>\n
all the archived logs are there. You can see that DBID is the same as the primary.<\/p>\n
Transport and Apply lag<\/h3>\n
Let’s check the lag:<\/p>\n
[oracle@VM111 ~]$ dgmgrl \/\nDGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production\nCopyright (c) 2000, 2013, Oracle. All rights reserved.\nWelcome to DGMGRL, type \"help\" for information.\nConnected as SYSDG.\nDGMGRL> show database demo12\n\nDatabase - demo12\n\n  Role:               SNAPSHOT STANDBY\n  Transport Lag:      0 seconds (computed 1 second ago)\n  Apply Lag:          5 minutes 4 seconds (computed 1 second ago)\n  Instance(s):\n    DEMO12\n\nDatabase Status:\nSUCCESS\n<\/code><\/pre>\n
I have an apply lag (the apply stopped when I converted the physical standby to a snapshot standby) but there is no transport lag.<\/p>\n
At that point, I have my new database. I can do whatever I want, with the possibility to convert back to a standby, apply more archived logs, re-convert to a snapshot standby, etc. Then when I’m happy with it, I’ll finalize it:<\/p>\n
    \n
  • remove the standby configuration<\/li>\n
  • delete all the unwanted archived logs<\/li>\n
  • change DBID and DB_NAME to new ones<\/li>\n<\/ul>\n
    Remove standby database configuration<\/h3>\n
    This is done from Data Guard Broker and it will stop log shipping to the standby.<\/p>\n
    DGMGRL> remove database demo12;\nRemoved database \"demo12\" from the configuration\n\n<\/code><\/pre>\n
    At that point we can remove the archived logs on the standby site (rman delete archivelog all). We can also check the parameters that have been set by standby configuration(file name convert, fal_server, archive_lag_target) and set the dg_broker_start if you don’t want it anymore. The log_archive_config and log_archive_dest should have been reset properly by the ‘remove database from configuration’.<\/p>\n
    DBNEWID<\/h3>\n
    I’m setting the DB_NAME to DEMO12 (instead of DEMO11) and I want a new DBID. This is done with ‘nid’ when in mount:<\/p>\n
    SQL> shutdown immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL> startup mount\nORACLE instance started.\n\nTotal System Global Area  473956352 bytes\nFixed Size                  2925744 bytes\nVariable Size             268438352 bytes\nDatabase Buffers          197132288 bytes\nRedo Buffers                5459968 bytes\nDatabase mounted.\nSQL> exit\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\n[oracle@VM112 dbs]$ nid target=sys\/oracle dbname=DEMO12\n\nDBNEWID: Release 12.1.0.2.0 - Production on Thu May 28 22:52:04 2015\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\nConnected to database DEMO11 (DBID=684456715)\nConnected to server version 12.1.0\n\nControl Files in database:\n    \/u01\/DEMO\/oradata\/DEMO12\/control01.ctl\n    \/u01\/DEMO\/fast_recovery_area\/DEMO12\/control02.ctl\n\nChange database ID and database name DEMO11 to DEMO12? (Y\/[N]) => Y\n\nProceeding with operation\nChanging database ID from 684456715 to 833681684\nChanging database name from DEMO11 to DEMO12\n    Control File \/u01\/DEMO\/oradata\/DEMO12\/control01.ctl - modified\n    Control File \/u01\/DEMO\/fast_recovery_area\/DEMO12\/control02.ctl - modified\n    Datafile \/u01\/DEMO\/oradata\/DEMO12\/system01.db - dbid changed, wrote new name\n    Datafile \/u01\/DEMO\/oradata\/DEMO12\/sysaux01.db - dbid changed, wrote new name\n    Datafile \/u01\/DEMO\/oradata\/DEMO12\/undotbs01.db - dbid changed, wrote new name\n    Datafile \/u01\/DEMO\/oradata\/DEMO12\/example01.db - dbid changed, wrote new name\n    Datafile \/u01\/DEMO\/oradata\/DEMO12\/users01.db - dbid changed, wrote new name\n    Datafile \/u01\/DEMO\/oradata\/DEMO12\/temp01.db - dbid changed, wrote new name\n    Control File \/u01\/DEMO\/oradata\/DEMO12\/control01.ctl - dbid changed, wrote new name\n    Control File \/u01\/DEMO\/fast_recovery_area\/DEMO12\/control02.ctl - dbid changed, wrote new name\n    Instance shut down\n\nDatabase name changed to DEMO12.\nModify parameter file and generate a new password file before restarting.\nDatabase ID for database DEMO12 changed to 833681684.\nAll previous backups and archived redo logs for this database are unusable.\nDatabase is not aware of previous backups and archived logs in Recovery Area.\nDatabase has been shutdown, open database with RESETLOGS option.\nSuccesfully changed database name and ID.\nDBNEWID - Completed succesfully.\n<\/code><\/pre>\n
    I have to change the DB_NAME in the spfile and I also reset the parameters that I do not want as this database is not in a Data Guard configuration anymore:<\/p>\n
    SQL> alter system set db_name='DEMO12' scope=spfile dg_broker_start=false scope=spfile;\nSystem altered.\n\nSQL> alter system reset fal_server;\nSystem altered.\n<\/code><\/pre>\n
    then I restart and open resetlogs:<\/p>\n
    SQL> startup force\nORACLE instance started.\n\nTotal System Global Area  473956352 bytes\nFixed Size                  2925744 bytes\nVariable Size             268438352 bytes\nDatabase Buffers          197132288 bytes\nRedo Buffers                5459968 bytes\nDatabase mounted.\nORA-01589: must use RESETLOGS or NORESETLOGS option for database open\n\nSQL> alter database open resetlogs;\nDatabase altered.\n<\/code><\/pre>\n
    Flashback logs<\/h3>\n
    I had to remove the archived logs, bit let’s check the flashback logs:<\/p>\n
    SQL> select * from v$recovery_area_usage;\n\nFILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES\n----------------------- ------------------ ------------------------- ---------------\nCONTROL FILE                             0                         0               0\nREDO LOG                                 0                         0               0\nARCHIVED LOG                             0                         0               0\nBACKUP PIECE                             0                         0               0\nIMAGE COPY                               0                         0               0\nFLASHBACK LOG                            0                         0               0\nFOREIGN ARCHIVED LOG                     0                         0               0\nAUXILIARY DATAFILE COPY                  0                         0               0\n<\/code><\/pre>\n
    the cleanup has been done because the restore point has been removed:<\/p>\n
    RMAN> list restore point all;\n\nusing target database control file instead of recovery catalog\nSCN              RSP Time  Type       Time      Name\n---------------- --------- ---------- --------- ----\n<\/code><\/pre>\n
    Summary<\/h3>\n
    The operation is something simple. The goal of this post is to show in which order to do it so that there is a minimum cleanup to do. Snapshot standby is a very useful feature available in Enterprise Edition since 11g.<\/p>\n","protected":false},"excerpt":{"rendered":"
    By Franck Pachot . A snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back to physical standby. But you don’t want to stay in that state definitely because you will […]<\/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":[198,59],"tags":[221,96],"type_dbi":[],"class_list":["post-4859","post","type-post","status-publish","format-standard","hentry","category-database-management","category-oracle","tag-data-guard","tag-oracle"],"acf":[],"yoast_head":"\nConvert a snapshot standby to a new database - 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\/convert-a-snapshot-standby-to-a-new-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert a snapshot standby to a new database\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . A snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back to physical standby. But you don’t want to stay in that state definitely because you will […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-12T05:39:55+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=\"8 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\\\/convert-a-snapshot-standby-to-a-new-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Convert a snapshot standby to a new database\",\"datePublished\":\"2015-06-12T05:39:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/\"},\"wordCount\":681,\"commentCount\":0,\"keywords\":[\"Data Guard\",\"Oracle\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/\",\"name\":\"Convert a snapshot standby to a new database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2015-06-12T05:39:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/convert-a-snapshot-standby-to-a-new-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert a snapshot standby to a new database\"}]},{\"@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":"Convert a snapshot standby to a new database - 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\/convert-a-snapshot-standby-to-a-new-database\/","og_locale":"en_US","og_type":"article","og_title":"Convert a snapshot standby to a new database","og_description":"By Franck Pachot . A snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back to physical standby. But you don’t want to stay in that state definitely because you will […]","og_url":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/","og_site_name":"dbi Blog","article_published_time":"2015-06-12T05:39:55+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Convert a snapshot standby to a new database","datePublished":"2015-06-12T05:39:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/"},"wordCount":681,"commentCount":0,"keywords":["Data Guard","Oracle"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/","url":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/","name":"Convert a snapshot standby to a new database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-06-12T05:39:55+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/convert-a-snapshot-standby-to-a-new-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Convert a snapshot standby to a new database"}]},{"@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\/4859","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=4859"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4859\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4859"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}