{"id":10673,"date":"2017-11-28T13:51:51","date_gmt":"2017-11-28T12:51:51","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/"},"modified":"2023-06-08T16:37:42","modified_gmt":"2023-06-08T14:37:42","slug":"dataguard-quizz-on-snapshot-standby","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/","title":{"rendered":"Dataguard: QUIZZ on Snapshot Standby"},"content":{"rendered":"<p><strong>By Mouhamadou Diaw<\/strong><\/p>\n<p>In oracle documentation we can find this about snapshot standby: <em>A snapshot standby database is a fully updatable standby database that provides disaster recovery and data protection benefits that are similar to those of a physical standby database.<\/em><\/p>\n<p>The concept of snapshot standby is that we can temporary convert a physical standby to an updatable database for different purposes and then convert back to a physical standby. During the time that the database is a snapshot standby, it can be used as a normal read write database. And then after the flashback technology is used combined with archived logfiles to convert back the snapshot to a physical standby.<br \/>\nIn this blog I have tested some common tasks on a snapshot database and I am describing below the results.<\/p>\n<p>We show our configuration, oracle 12.2 is used.<br \/>\n<strong>ORCL_SITE<\/strong>: Primary<br \/>\n<strong>ORCL_SITE2<\/strong>: Physical Standby<br \/>\n<strong>ORCL_SITE2<\/strong>: Physical Standby<br \/>\n<strong>ORCL_SITE3<\/strong>: Logical Standby<\/p>\n<p><code><br \/>\nDGMGRL&gt; show configuration;<br \/>\n.<br \/>\nConfiguration - ORCL_DR<br \/>\n.<br \/>\nProtection Mode: MaxPerformance<br \/>\nMembers:<br \/>\nORCL_SITE  - Primary database<br \/>\nORCL_SITE1 - Physical standby database<br \/>\nORCL_SITE2 - Physical standby database<br \/>\nORCL_SITE3 - Logical standby database<br \/>\n.<br \/>\nFast-Start Failover: DISABLED<br \/>\n.<br \/>\nConfiguration Status:<br \/>\nSUCCESS   (status updated 42 seconds ago)<br \/>\n.<br \/>\nDGMGRL&gt;<br \/>\n<\/code><br \/>\nThe first question we can ask is which type of standby can be converted to a snapshot database<\/p>\n<p><strong>1- Can we convert a logical standby to a snapshot standby<\/strong><br \/>\nLet\u2019s convert our logical standby to a snapshot standby<br \/>\n<code><br \/>\nDGMGRL&gt; CONVERT DATABASE 'ORCL_SITE3' TO SNAPSHOT STANDBY;<br \/>\nConverting database \"ORCL_SITE3\" to a Snapshot Standby database, please wait...<br \/>\nError: ORA-16831: operation not allowed on this member<br \/>\n.<br \/>\nFailed.<br \/>\nFailed to convert database \"ORCL_SITE3\"<br \/>\nDGMGRL&gt;<br \/>\n<\/code><\/p>\n<p><strong>Answer<\/strong>: NO we cannot convert a logical standby to a snapshot standby<\/p>\n<p><strong>2- Can we convert a physical standby to a snapshot standby<\/strong><br \/>\nLet\u2019s convert our physical standby to a snapshot standby<br \/>\n<code><br \/>\nDGMGRL&gt; CONVERT DATABASE 'ORCL_SITE2' TO SNAPSHOT STANDBY;<br \/>\nConverting database \"ORCL_SITE2\" to a Snapshot Standby database, please wait...<br \/>\nDatabase \"ORCL_SITE2\" converted successfully<br \/>\nDGMGRL&gt;<br \/>\n<\/code><br \/>\nAnd we can verify the new status of the database &#8216;ORCL_SITE2&#8217;<br \/>\n<code><br \/>\nDGMGRL&gt; show database 'ORCL_SITE2';<br \/>\n.<br \/>\nDatabase - ORCL_SITE2<br \/>\n.<br \/>\nRole:               SNAPSHOT STANDBY<br \/>\nTransport Lag:      0 seconds (computed 1 second ago)<br \/>\nApply Lag:          1 minute 33 seconds (computed 1 second ago)<br \/>\nInstance(s):<br \/>\nORCL<br \/>\n.<br \/>\nDatabase Status:<br \/>\nSUCCESS<br \/>\n.<br \/>\nDGMGRL&gt;<br \/>\n.<br \/>\n<\/code><br \/>\n<strong>Answer<\/strong>: Yes we can convert a physical standby to a snapshot standby.<\/p>\n<p>Now that the physical is converted to a snapshot let\u2019s continue our quizz.<\/p>\n<p><strong>3- Can we open a snapshot standby on a read only mode<\/strong><br \/>\nLet\u2019s shutdown our standby snapshot and let\u2019s open it on read only mode<br \/>\n<code><br \/>\nSQL&gt; startup open read only;<br \/>\nORACLE instance started.<br \/>\n.<br \/>\nTotal System Global Area  943718400 bytes<br \/>\nFixed Size                  8627440 bytes<br \/>\nVariable Size             348130064 bytes<br \/>\nDatabase Buffers          583008256 bytes<br \/>\nRedo Buffers                3952640 bytes<br \/>\nDatabase mounted.<br \/>\nDatabase opened.<br \/>\n<\/code><br \/>\nThe status is now open read only<br \/>\n<code><br \/>\nSQL&gt; select db_unique_name,database_role,open_mode from v$database;<br \/>\n.<br \/>\nDB_UNIQUE_NAME                 DATABASE_ROLE    OPEN_MODE<br \/>\n------------------------------ ---------------- --------------------<br \/>\nORCL_SITE2                     SNAPSHOT STANDBY READ ONLY<br \/>\n<\/code><\/p>\n<p><strong>Answer<\/strong>: Yes a snapshot standby can be opened in a READ ONLY mode<\/p>\n<p><strong>4- Can we create a tablespace on a snapshot standby<\/strong><br \/>\nConnected to the standby database let\u2019s create a tablespace<br \/>\n<code><br \/>\nSQL&gt; create tablespace mytab_snap datafile '\/u01\/app\/oracle\/oradata\/ORCL\/mytab_snap01.dbf' size 2M autoextend on maxsize 10M;<br \/>\n.<br \/>\nTablespace created.<br \/>\n<\/code><br \/>\nWe can verify in the table dba_tablespaces<br \/>\n<code><br \/>\nSQL&gt; select tablespace_name from dba_tablespaces;<br \/>\n.<br \/>\nTABLESPACE_NAME<br \/>\n------------------------------<br \/>\nSYSTEM<br \/>\nSYSAUX<br \/>\nUNDOTBS1<br \/>\nTEMP<br \/>\nUSERS<br \/>\nMYTAB_SNAP<br \/>\nTAB_TEST<br \/>\n<\/code><br \/>\n<strong>Answer<\/strong>: Yes we can see that the tablespace MYTAB_SNAP was created.<\/p>\n<p><strong>5- Can we drop a tablespace on a snapshot standby<\/strong><br \/>\nLet&#8217;s drop a tablespace<br \/>\n<code>SQL&gt; drop tablespace TAB_TEST  including contents and datafiles;<br \/>\ndrop tablespace TAB_TEST  including contents and datafiles<br \/>\n*<br \/>\nERROR at line 1:<br \/>\nORA-38881: Cannot drop tablespace TAB_TEST on primary database due to<br \/>\nguaranteed restore points.<br \/>\n<\/code><\/p>\n<p><strong>Answer<\/strong>: No due to guaranteed restore point, we cannot drop a tablespace on a snapshot database.<\/p>\n<p><strong>6- Can we extend a datafile on a snapshot standby<\/strong><br \/>\nWe are going to consider two types of datafiles.<br \/>\n\u2022 One from tablespace MYTAB_SNAP created on the snapshot standby<br \/>\n\u2022 Another from tablespace TAB_TEST created on the primary<br \/>\n<code><br \/>\nFILE_NAME                                          TABLESPACE_NAME<br \/>\n-------------------------------------------------- ------------------------------<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/users01.dbf           USERS<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/undotbs01.dbf         UNDOTBS1<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/system01.dbf          SYSTEM<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/sysaux01.dbf          SYSAUX<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/stab_test.dbf         TAB_TEST<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/mytab_snap01.dbf      MYTAB_SNAP<br \/>\n<\/code><\/p>\n<p>Let\u2019s extend first the datafile created on the snapshot standby<br \/>\n<code><br \/>\nSQL&gt; alter database datafile '\/u01\/app\/oracle\/oradata\/ORCL\/mytab_snap01.dbf' resize 20M;<br \/>\n.<br \/>\nDatabase altered.<br \/>\n<\/code><\/p>\n<p>And then let\u2019s do the same operation on the datafile created on the primary<br \/>\n<code><br \/>\nSQL&gt; alter database datafile '\/u01\/app\/oracle\/oradata\/ORCL\/stab_test.dbf' resize 20M;<br \/>\n.<br \/>\nDatabase altered.<br \/>\n<\/code><\/p>\n<p>We can verify the new sizes<br \/>\n<code><br \/>\nSQL&gt; select FILE_NAME,sum(BYTES) from dba_data_files group by FILE_NAME;<br \/>\n.<br \/>\nFILE_NAME                                          SUM(BYTES)<br \/>\n-------------------------------------------------- ----------<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/users01.dbf              5242880<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/undotbs01.dbf           73400320<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/system01.dbf           870318080<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/sysaux01.dbf           587202560<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/stab_test.dbf           20971520<br \/>\n\/u01\/app\/oracle\/oradata\/ORCL\/mytab_snap01.dbf        20971520<br \/>\n.<br \/>\n6 rows selected.<br \/>\n<\/code><\/p>\n<p><strong>Answer<\/strong>: Yes we can extend datafiles on a snapshot standby.<\/p>\n<p><em>Just note that when the snapshot standby is converted back to a physical, the datafile is shrinked until his previous size.<\/em><\/p>\n<p><strong>7- Can we reduce a datafile on a standby database<\/strong><br \/>\nLet\u2019s now reduce the size of the datafile created on the snapshot<br \/>\n<code><br \/>\nSQL&gt; alter database datafile '\/u01\/app\/oracle\/oradata\/ORCL\/mytab_snap01.dbf' resize 5M;<br \/>\n.<br \/>\nDatabase altered.<br \/>\n<\/code><br \/>\nAnd let\u2019s do the same operation on the datafile created on the primary<br \/>\n<code><br \/>\nSQL&gt; alter database datafile '\/u01\/app\/oracle\/oradata\/ORCL\/stab_test.dbf' resize 5M;<br \/>\nalter database datafile '\/u01\/app\/oracle\/oradata\/ORCL\/stab_test.dbf' resize 5M<br \/>\n*<br \/>\nERROR at line 1:<br \/>\nORA-38883: Cannot shrink data file \/u01\/app\/oracle\/oradata\/ORCL\/stab_test.dbf<br \/>\non primary database due to guaranteed restore points.<br \/>\n<\/code><\/p>\n<p><strong>Answer<\/strong>: Yes we see that we can only reduce size for datafiles created on the snapshot standby.<\/p>\n<p><strong>8- Can we do a switchover to a snapshot standby<\/strong><br \/>\nAs a snapshot is a physical standby which was converted, one may ask if a switchover is possible to a snapshot standby.<br \/>\n<code><br \/>\nDGMGRL&gt; switchover to 'ORCL_SITE2';<br \/>\nPerforming switchover NOW, please wait...<br \/>\nError: ORA-16831: operation not allowed on this member<br \/>\n.<br \/>\nFailed.<br \/>\nUnable to switchover, primary database is still \"ORCL_SITE\"<br \/>\nDGMGRL&gt;<br \/>\n<\/code><\/p>\n<p><strong>Answer<\/strong>: No we cannot do a switchover to a snapshot standby.<\/p>\n<p><strong>9- Can we do a failover to a snapshot standby <\/strong><br \/>\nThe same question can be asked about failover.<br \/>\n<code><br \/>\nDGMGRL&gt; connect sys\/root@ORCL_SITE2<br \/>\nConnected to \"ORCL_SITE2\"<br \/>\nConnected as SYSDBA.<br \/>\nDGMGRL&gt; failover  to 'ORCL_SITE2';<br \/>\nConverting database \"ORCL_SITE2\" to a Physical Standby database, please wait...<br \/>\nOperation requires shut down of instance \"ORCL\" on database \"ORCL_SITE2\"<br \/>\nShutting down instance \"ORCL\"...<br \/>\nConnected to \"ORCL_SITE2\"<br \/>\nDatabase closed.<br \/>\nDatabase dismounted.<br \/>\nORACLE instance shut down.<br \/>\nOperation requires start up of instance \"ORCL\" on database \"ORCL_SITE2\"<br \/>\nStarting instance \"ORCL\"...<br \/>\nORACLE instance started.<br \/>\nDatabase mounted.<br \/>\nConnected to \"ORCL_SITE2\"<br \/>\nConnected to \"ORCL_SITE2\"<br \/>\nContinuing to convert database \"ORCL_SITE2\" ...<br \/>\nDatabase \"ORCL_SITE2\" converted successfully<br \/>\nPerforming failover NOW, please wait...<br \/>\nFailover succeeded, new primary is \"ORCL_SITE2\"<br \/>\nDGMGRL&gt;<br \/>\n<\/code><\/p>\n<p><strong>Answer<\/strong>: Yes, we can do a failover to a snapshot standby but the time of the failover is longer than if the failover was done to a physical standby. Indeed oracle has<\/p>\n<p>\u2022 Convert the snapshot to physical standby one<br \/>\n\u2022 Applied archived logs to the physical standby<br \/>\n\u2022 And then do the failover<\/p>\n<p><strong>Conclusion<\/strong>: In this blog, we tried to explain some behaviors of snapshot standby. Hope that this article may help<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Mouhamadou Diaw In oracle documentation we can find this about snapshot standby: A snapshot standby database is a fully updatable standby database that provides disaster recovery and data protection benefits that are similar to those of a physical standby database. The concept of snapshot standby is that we can temporary convert a physical standby [&hellip;]<\/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,511,988,1234,1235],"type_dbi":[],"class_list":["post-10673","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dataguard-12-2","tag-failover","tag-oracle-12-2","tag-standby-database","tag-swithover"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Dataguard: QUIZZ on Snapshot Standby - dbi Blog<\/title>\n<meta name=\"description\" content=\"snapshot database, oracle 12.2, dataguard\" \/>\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\/dataguard-quizz-on-snapshot-standby\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dataguard: QUIZZ on Snapshot Standby\" \/>\n<meta property=\"og:description\" content=\"snapshot database, oracle 12.2, dataguard\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-28T12:51:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T14:37:42+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\/dataguard-quizz-on-snapshot-standby\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Dataguard: QUIZZ on Snapshot Standby\",\"datePublished\":\"2017-11-28T12:51:51+00:00\",\"dateModified\":\"2023-06-08T14:37:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/\"},\"wordCount\":672,\"commentCount\":0,\"keywords\":[\"Dataguard 12.2\",\"failover\",\"Oracle 12.2\",\"standby database\",\"swithover\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/\",\"name\":\"Dataguard: QUIZZ on Snapshot Standby - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-11-28T12:51:51+00:00\",\"dateModified\":\"2023-06-08T14:37:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"snapshot database, oracle 12.2, dataguard\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dataguard: QUIZZ on Snapshot Standby\"}]},{\"@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":"Dataguard: QUIZZ on Snapshot Standby - dbi Blog","description":"snapshot database, oracle 12.2, dataguard","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\/dataguard-quizz-on-snapshot-standby\/","og_locale":"en_US","og_type":"article","og_title":"Dataguard: QUIZZ on Snapshot Standby","og_description":"snapshot database, oracle 12.2, dataguard","og_url":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/","og_site_name":"dbi Blog","article_published_time":"2017-11-28T12:51:51+00:00","article_modified_time":"2023-06-08T14:37:42+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\/dataguard-quizz-on-snapshot-standby\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Dataguard: QUIZZ on Snapshot Standby","datePublished":"2017-11-28T12:51:51+00:00","dateModified":"2023-06-08T14:37:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/"},"wordCount":672,"commentCount":0,"keywords":["Dataguard 12.2","failover","Oracle 12.2","standby database","swithover"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/","url":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/","name":"Dataguard: QUIZZ on Snapshot Standby - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-11-28T12:51:51+00:00","dateModified":"2023-06-08T14:37:42+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"snapshot database, oracle 12.2, dataguard","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-quizz-on-snapshot-standby\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dataguard: QUIZZ on Snapshot Standby"}]},{"@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\/10673","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=10673"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10673\/revisions"}],"predecessor-version":[{"id":25705,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10673\/revisions\/25705"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10673"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}