{"id":10704,"date":"2017-12-20T18:12:36","date_gmt":"2017-12-20T17:12:36","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/"},"modified":"2023-06-09T16:49:56","modified_gmt":"2023-06-09T14:49:56","slug":"oracle-12-2-dataguard-pdb-flashback-on-the-primary","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/","title":{"rendered":"Oracle 12.2 Dataguard : PDB Flashback on the Primary"},"content":{"rendered":"<p><strong>By Mouhamadou Diaw<\/strong><\/p>\n<p>The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog.<br \/>\nBelow our broker configuration. Oracle 12.2 is used.<br \/>\n<code><br \/>\nDGMGRL&gt; show configuration;<br \/>\nConfiguration - MYCONT_DR<br \/>\nProtection Mode: MaxPerformance<br \/>\nMembers:<br \/>\nMYCONT_SITE  - Primary database<br \/>\nMYCONT_SITE1 - Physical standby database<br \/>\nFast-Start Failover: DISABLED<br \/>\nConfiguration Status:<br \/>\nSUCCESS   (status updated 35 seconds ago)<br \/>\nDGMGRL&gt;<br \/>\n<\/code><br \/>\nThe primary database has the flashback database set to YES.<br \/>\n<code><br \/>\nSQL&gt; select db_unique_name,open_mode,flashback_on  from v$database;<br \/>\nDB_UNIQUE_NAME                 OPEN_MODE            FLASHBACK_ON<br \/>\n------------------------------ -------------------- ------------------<br \/>\nMYCONT_SITE                    READ WRITE           YES<br \/>\n.<br \/>\nSQL&gt; select name,open_mode from v$pdbs;<br \/>\nNAME                 OPEN_MODE<br \/>\n-------------------- ----------<br \/>\nPDB$SEED             READ ONLY<br \/>\nPDB1                 READ WRITE<br \/>\nPDB2                 READ WRITE<br \/>\n<\/code><br \/>\nSame for the standby database<br \/>\n<code><br \/>\nSQL&gt; select db_unique_name,open_mode,flashback_on  from v$database;<br \/>\nDB_UNIQUE_NAME                 OPEN_MODE            FLASHBACK_ON<br \/>\n------------------------------ -------------------- ------------------<br \/>\nMYCONT_SITE1                   READ ONLY WITH APPLY YES<br \/>\n.<br \/>\nSQL&gt; select name,open_mode from v$pdbs;<br \/>\nNAME                 OPEN_MODE<br \/>\n-------------------- ----------<br \/>\nPDB$SEED             READ ONLY<br \/>\nPDB1                 READ ONLY<br \/>\nPDB2                 READ ONLY<br \/>\n<\/code><br \/>\nFor the tests we are going to do a flashback database for the primary PDB1.<br \/>\nLet\u2019s connect to PDB1<br \/>\n<code><br \/>\n10:15:59 SQL&gt; alter session set container=pdb1;<br \/>\nSession altered.<br \/>\n.<br \/>\n10:16:15 SQL&gt; show con_name;<br \/>\nCON_NAME<br \/>\n------------------------------<br \/>\nPDB1<br \/>\n10:16:22 SQL&gt;<br \/>\n<\/code><br \/>\nAnd let\u2019s create a table article with some datafor reference<br \/>\n<code><br \/>\n10:16:22 SQL&gt; create table article (idart number);<br \/>\nTable created.<br \/>\n.<br \/>\n10:18:12 SQL&gt; insert into article values (1);<br \/>\n1 row created.<br \/>\n10:18:31 SQL&gt; insert into article values (2);<br \/>\n1 row created.<br \/>\n.<br \/>\n10:18:34 SQL&gt; select * from article;<br \/>\nIDART<br \/>\n----------<br \/>\n1<br \/>\n2<br \/>\n.<br \/>\n10:18:46 SQL&gt; commit;<br \/>\n<\/code><br \/>\nNow let\u2019s do a database flashback of primary pdb1 before the creation of the table article.<br \/>\n<code><br \/>\n10:28:12 SQL&gt; show con_name<br \/>\nCON_NAME<br \/>\n------------------------------<br \/>\nPDB1<br \/>\n.<br \/>\n10:28:16 SQL&gt; shut immediate;<br \/>\nPluggable Database closed.<br \/>\n.<br \/>\n10:28:28 SQL&gt; select name,open_mode from v$pdbs;<br \/>\nNAME                 OPEN_MODE<br \/>\n-------------------- ----------<br \/>\nPDB1                 MOUNTED<br \/>\n10:28:54 SQL&gt;<br \/>\n.<br \/>\n10:28:54 SQL&gt; FLASHBACK PLUGGABLE DATABASE PDB1 TO TIMESTAMP TO_TIMESTAMP('2017-12-20 10:16:00', 'YYYY-MM-DD HH24:MI:SS');<br \/>\nFlashback complete.<br \/>\n10:30:14 SQL&gt;<br \/>\n<\/code><br \/>\nNow let\u2019s open PDB1 with resetlogs option<br \/>\n<code><br \/>\n10:31:08 SQL&gt; alter pluggable database PDB1 open resetlogs;<br \/>\nPluggable database altered.<br \/>\n10:32:15 SQL&gt;<br \/>\n<\/code><br \/>\nAnd let\u2019s query the table article. As expected the table is no longer present<br \/>\n<code><br \/>\n10:32:15 SQL&gt; select name,open_mode from v$pdbs;<br \/>\nNAME                 OPEN_MODE<br \/>\n-------------------- ----------<br \/>\nPDB1                 READ WRITE<br \/>\n.<br \/>\n10:32:59 SQL&gt; select * from article;<br \/>\nselect * from article<br \/>\n*<br \/>\nERROR at line 1:<br \/>\nORA-00942: table or view does not exist<br \/>\n10:33:06 SQL&gt;<br \/>\n<\/code><br \/>\nNow if we check the status of our dataguard in the broker, we have errors<br \/>\n<code><br \/>\n12\/20\/2017 10:23:07 DGMGRL&gt; show configuration;<br \/>\nConfiguration - MYCONT_DR<br \/>\nProtection Mode: MaxPerformance<br \/>\nMembers:<br \/>\nMYCONT_SITE  - Primary database<br \/>\nMYCONT_SITE1 - Physical standby database<br \/>\nError: ORA-16810: multiple errors or warnings detected for the member<br \/>\nFast-Start Failover: DISABLED<br \/>\nConfiguration Status:<br \/>\nERROR   (status updated 48 seconds ago)<br \/>\n12\/20\/2017 10:34:40 DGMGRL&gt;<br \/>\n<\/code><br \/>\nThe status of the Primary database is fine<br \/>\n<code><br \/>\n12\/20\/2017 10:34:40 DGMGRL&gt; show database 'MYCONT_SITE';<br \/>\nDatabase - MYCONT_SITE<br \/>\nRole:               PRIMARY<br \/>\nIntended State:     TRANSPORT-ON<br \/>\nInstance(s):<br \/>\nMYCONT<br \/>\nDatabase Status:<br \/>\nSUCCESS<br \/>\n<\/code><br \/>\nBut the standby status is returning some errors<br \/>\n<code>12\/20\/2017 10:35:11 DGMGRL&gt; show database 'MYCONT_SITE1';<br \/>\nDatabase - MYCONT_SITE1<br \/>\nRole:               PHYSICAL STANDBY<br \/>\nIntended State:     APPLY-ON<br \/>\nTransport Lag:      0 seconds (computed 1 second ago)<br \/>\nApply Lag:          3 minutes 10 seconds (computed 1 second ago)<br \/>\nAverage Apply Rate: 7.00 KByte\/s<br \/>\nReal Time Query:    OFF<br \/>\nInstance(s):<br \/>\nMYCONT<br \/>\nDatabase Error(s):<br \/>\nORA-16766: Redo Apply is stopped<br \/>\nDatabase Warning(s):<br \/>\nORA-16853: apply lag has exceeded specified threshold<br \/>\nDatabase Status:<br \/>\nERROR<br \/>\n12\/20\/2017 10:35:15 DGMGRL&gt;<br \/>\n<\/code><br \/>\nAnd if we check the alert log of the standby dataset we can find following errors<br \/>\n<code><br \/>\n<strong>(3):Recovery of pluggable database PDB1 aborted due to pluggable database open resetlog marker.<\/strong><br \/>\n<strong>(3):To continue recovery, restore all data files for this PDB to checkpoint SCN lower than 2518041, or timestamp before 12\/20\/2017 10:16:01, and restart recovery<\/strong><br \/>\nMRP0: Background Media Recovery terminated with error 39874<br \/>\n2017-12-20T10:32:05.565085+01:00<br \/>\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/mycont_site1\/MYCONT\/trace\/MYCONT_mrp0_1590.trc:<br \/>\nORA-39874: Pluggable Database PDB1 recovery halted<br \/>\nORA-39873: Restore all data files to a checkpoint SCN lower than 2518041.<br \/>\nManaged Standby Recovery not using Real Time Apply<br \/>\nRecovery interrupted!<br \/>\nRecovered data files to a consistent state at change 2520607<br \/>\n2017-12-20T10:32:05.612394+01:00<br \/>\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/mycont_site1\/MYCONT\/trace\/MYCONT_mrp0_1590.trc:<br \/>\nORA-39874: Pluggable Database PDB1 recovery halted<br \/>\nORA-39873: Restore all data files to a checkpoint SCN lower than 2518041.<br \/>\n2017-12-20T10:32:05.612511+01:00<br \/>\nMRP0: Background Media Recovery process shutdown (MYCONT)<br \/>\n<\/code><br \/>\nOn the primary PDB, we can can query the current INCARNATION_SCN in the v$pdb_incarnation view. And we can remark that the current SCN is the same that the one specified in the standby alert log <strong>2518041<\/strong><br \/>\n<code><br \/>\n11:08:11 SQL&gt; show con_name<br \/>\nCON_NAME<br \/>\n------------------------------<br \/>\nPDB1<br \/>\n11:08:56 SQL&gt; select status,INCARNATION_SCN from v$pdb_incarnation;<br \/>\nSTATUS  INCARNATION_SCN<br \/>\n------- ---------------<br \/>\nCURRENT         2518041<br \/>\nPARENT          2201909<br \/>\nPARENT          1396169<br \/>\n11:08:59 SQL&gt;<br \/>\n<\/code><br \/>\nAnd then as specified in the alert log we have to flashback the standby pdb to a SCN lower than 2518041<br \/>\nFirst let\u2019s stop the redo apply on the standby<br \/>\n<code><br \/>\n12\/20\/2017 11:13:14 DGMGRL&gt; edit database 'MYCONT_SITE1' set state='APPLY-OFF';<br \/>\nSucceeded.<br \/>\n12\/20\/2017 11:13:59 DGMGRL&gt;<br \/>\n<\/code><br \/>\nAnd then let\u2019s flashback to 2518039 ( i.e 2518041 -2 ) for example<br \/>\nLet\u2019s shutdown the standby container MYCONT and startup it in a mount state<br \/>\n<code><br \/>\n11:18:42 SQL&gt; shut immediate;<br \/>\nDatabase closed.<br \/>\nDatabase dismounted.<br \/>\nORACLE instance shut down.<br \/>\n.<br \/>\n11:19:10 SQL&gt; startup mount<br \/>\nORACLE instance started.<br \/>\nTotal System Global Area  956301312 bytes<br \/>\nFixed Size                  8799656 bytes<br \/>\nVariable Size             348129880 bytes<br \/>\nDatabase Buffers          595591168 bytes<br \/>\nRedo Buffers                3780608 bytes<br \/>\nDatabase mounted.<br \/>\n11:19:50 SQL&gt;<br \/>\n.<br \/>\n11:19:50 SQL&gt; select name,open_mode from v$pdbs;<br \/>\nNAME                 OPEN_MODE<br \/>\n-------------------- ----------<br \/>\nPDB$SEED             MOUNTED<br \/>\nPDB1                 MOUNTED<br \/>\nPDB2                 MOUNTED<br \/>\n<\/code><br \/>\nNow let\u2019s flashback PDB1 on the standby<br \/>\n<code><br \/>\n11:20:19 SQL&gt; flashback pluggable database PDB1 to SCN 2518039;<br \/>\nFlashback complete.<br \/>\n11:20:40 SQL&gt;<br \/>\n<\/code><br \/>\nThe last step is to enable again the redo apply for the standby container<br \/>\n<code><br \/>\n12\/20\/2017 11:13:59 DGMGRL&gt; edit database 'MYCONT_SITE1' set state='APPLY-ON';<br \/>\nSucceeded.<br \/>\n12\/20\/2017 11:23:08 DGMGRL&gt;<br \/>\n<\/code><br \/>\nAnd then we can verify that the configuration is now fine<br \/>\n<code><br \/>\n12\/20\/2017 11:25:05 DGMGRL&gt; show configuration;<br \/>\nConfiguration - MYCONT_DR<br \/>\nProtection Mode: MaxPerformance<br \/>\nMembers:<br \/>\nMYCONT_SITE  - Primary database<br \/>\nMYCONT_SITE1 - Physical standby database<br \/>\nFast-Start Failover: DISABLED<br \/>\nConfiguration Status:<br \/>\nSUCCESS   (status updated 1 second ago)<br \/>\n12\/20\/2017 11:25:07 DGMGRL&gt;<br \/>\n<\/code><br \/>\n<strong>Conclusion<\/strong><br \/>\nIn this article we saw that the flashback in a dataguard environment is working in the same way for a container or a non container. The only difference is the SCN we must consider to flashback the pluggable database. This SCN should be queried fom the v$pdb_incarnation and not from the v$database as we usually do for a non container database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Mouhamadou Diaw The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog. Below our broker configuration. Oracle 12.2 is used. DGMGRL&gt; show configuration; Configuration &#8211; MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE &#8211; Primary [&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,524,988],"type_dbi":[],"class_list":["post-10704","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dataguard-12-2","tag-flashback","tag-oracle-12-2"],"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>Oracle 12.2 Dataguard : PDB Flashback on the Primary - dbi Blog<\/title>\n<meta name=\"description\" content=\"oracle 12.2, dataguard, flashback\" \/>\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\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12.2 Dataguard : PDB Flashback on the Primary\" \/>\n<meta property=\"og:description\" content=\"oracle 12.2, dataguard, flashback\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-20T17:12:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T14:49:56+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\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12.2 Dataguard : PDB Flashback on the Primary\",\"datePublished\":\"2017-12-20T17:12:36+00:00\",\"dateModified\":\"2023-06-09T14:49:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/\"},\"wordCount\":372,\"commentCount\":0,\"keywords\":[\"Dataguard 12.2\",\"flashback\",\"Oracle 12.2\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/\",\"name\":\"Oracle 12.2 Dataguard : PDB Flashback on the Primary - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-12-20T17:12:36+00:00\",\"dateModified\":\"2023-06-09T14:49:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"oracle 12.2, dataguard, flashback\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12.2 Dataguard : PDB Flashback on the Primary\"}]},{\"@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":"Oracle 12.2 Dataguard : PDB Flashback on the Primary - dbi Blog","description":"oracle 12.2, dataguard, flashback","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\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12.2 Dataguard : PDB Flashback on the Primary","og_description":"oracle 12.2, dataguard, flashback","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/","og_site_name":"dbi Blog","article_published_time":"2017-12-20T17:12:36+00:00","article_modified_time":"2023-06-09T14:49:56+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\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12.2 Dataguard : PDB Flashback on the Primary","datePublished":"2017-12-20T17:12:36+00:00","dateModified":"2023-06-09T14:49:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/"},"wordCount":372,"commentCount":0,"keywords":["Dataguard 12.2","flashback","Oracle 12.2"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/","name":"Oracle 12.2 Dataguard : PDB Flashback on the Primary - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-12-20T17:12:36+00:00","dateModified":"2023-06-09T14:49:56+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"oracle 12.2, dataguard, flashback","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12-2-dataguard-pdb-flashback-on-the-primary\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12.2 Dataguard : PDB Flashback on the Primary"}]},{"@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\/10704","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=10704"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10704\/revisions"}],"predecessor-version":[{"id":25758,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10704\/revisions\/25758"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10704"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}