\n
![\"CapturePoorManSBY\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png\")
<\/a>\n<\/p>\n
Primary PRDPDB<\/h3>\n
On my primary server, I have a CDB1 container database in Standard Edition with one Pluggable Database: PDRDPDB:<\/p>\n
\n21:36:45 SQL> connect sys\/oracle@\/\/192.168.78.105\/CDB1 as sysdba\nConnected.\n \n21:36:46 SQL> show pdbs\n \n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 PRDPDB READ WRITE NO\n<\/code><\/pre>\nI need a user there to be able to remote clone from it:<\/p>\n
\n21:36:46 SQL> grant create session, sysoper, dba to C##DBA identified by oracle container=all;\nGrant succeeded.\n<\/code><\/pre>\nStandby server<\/h3>\n
On my standby server, I have a CDB1 container database in Standard Edition, where I create a database link to the production CDB using the user created above to connect to it:<\/p>\n
\n21:36:46 SQL> connect sys\/oracle@\/\/192.168.78.106:1522\/CDB1 as sysdba\nConnected.\n21:36:46 SQL> create database link CDB1A connect to C##DBA identified by oracle using '\/\/192.168.78.105\/CDB1A';\nDatabase link created.\n<\/code><\/pre>\nMy standby server runs Grid Infrastructure and has the database created on \/acfs which is an ACFS filesystem. We will see the reason later when we will need to create a PDB snapshot copy. Any filesystem where you can use PDB snapshot copy would be fine.<\/p>\n
Standby SBYPDB<\/h3>\n
The creation of the ‘standby’ pluggable database is done with a simple remote clone command and can be run in 12c<\/i>R2 with the source PRDPDB still opened read write:<\/p>\n\n21:36:46 SQL> create pluggable database SBYPDB from PRDPDB@CDB1A\n21:36:46 2 file_name_convert=('\/u01\/oradata\/CDB1A\/PRDPDB','\/acfs\/oradata\/CDB1\/SBYPDB')\n21:36:46 3 refresh mode every 1 minutes;\n \nPluggable database created.\n<\/code><\/pre>\nThe REFRESH MODE is a 12c<\/i>R2 feature which primary goal is to maintain and refresh a master clone for further provisioning of thin clones. This clone is refreshed every 1 minute, which means that I expect to have at most a one minute gap between PRDPDB and SBYPDB data, with the additional time to apply the 1 minute redo, of course.<\/p>\nActivity on the source<\/h3>\n
I will simulate a crash of the primary server and a failover to the standby, when transactions are running. I’ll run this activity on the SCOTT.EMP table:<\/p>\n
\n21:39:03 SQL> connect scott\/tiger@\/\/192.168.78.105\/PRDPDB;\nConnected.\n \n21:39:04 SQL> select * from emp where ename='KING';\n \n EMPNO ENAME JOB MGR HIREDATE SAL\n---------- ---------- --------- ---------- -------------------- ----------\n 7839 KING PRESIDENT 17-nov-1981 00:00:00 5000\n<\/code><\/pre>\nI’m now updating the date and incrementing the number each second.<\/p>\n
\n21:39:09 SQL> exec for i in 1..150 loop update emp set hiredate=sysdate, sal=sal+1; dbms_lock.sleep(1); commit; end loop\n \nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\nHere is the latest data on the primary server:<\/p>\n
\n21:41:39 SQL> select * from emp where ename='KING';\n \n EMPNO ENAME JOB MGR HIREDATE SAL\n---------- ---------- --------- ---------- -------------------- ----------\n 7839 KING PRESIDENT 11-jun-2017 21:41:38 5150\n<\/code><\/pre>\nCrash the primary<\/h3>\n
The primary server is not supposed to be accessible in case of Disaster Recovery, so I’m crashing it:<\/p>\n
\n21:41:39 SQL> disconnect\nDisconnected from Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production\n21:41:39 SQL> connect \/ as sysdba\nConnected.\n21:41:39 SQL> shutdown abort\nORACLE instance shut down.\n<\/code><\/pre>\nActivate the standby<\/h3>\n
The datafiles are up to date, with a maximum 1 minute gap and all I want is open it and have the application re-connect to it. However a refreshable clone can be opened only read-only. This makes sense: you cannot apply more redo from source once opened read-write. So my first idea was to stop the refresh mode:<\/p>\n
\n21:41:45 SQL> connect sys\/oracle@\/\/192.168.78.106:1522\/CDB1 as sysdba\nConnected.\n21:41:45 SQL> alter session set container=SBYPDB;\nSession altered.\n \n21:41:45 SQL> alter pluggable database SBYPDB refresh mode none;\nalter pluggable database SBYPDB refresh mode none\n*\nERROR at line 1:\nORA-17627: ORA-12514: TNS:listener does not currently know of service requested\nin connect descriptor\nORA-17629: Cannot connect to the remote database server\n<\/code><\/pre>\nIt seems that Oracle tries to do one last refresh when you stop the refresh mode, but this fails here because the source is not accessible. I think that it should be possible to open read-write without applying more redo. However, these refreshable clones were not designed for failover. <\/p>\n
I hope that one day we will just be able to end refresh mode without connecting to source, accepting to lose the latest transactions. <\/p>\n
Open Read Only<\/h3>\n
Without an access to the source, I stay in refresh mode and I can only open read only:<\/p>\n
21:41:45 SQL> alter pluggable database SBYPDB open read-only;\nPluggable database altered.\n \n21:41:47 SQL> alter session set container=SBYPDB;\nSession altered.\n&nsbp;\n21:41:47 SQL> alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';\nSession altered.\n \n21:41:47 SQL> select * from scott.emp where ename='KING';\n \n EMPNO ENAME JOB MGR HIREDATE SAL\n---------- ---------- --------- ---------- -------------------- ----------\n 7839 KING PRESIDENT 11-jun-2017 21:41:01 5113\n<\/code><\/pre>\nMy data is there, with my less than one minute gap, but that’s not sufficient for me. I want to run my application on it.<\/p>\n
Snapshot Clone<\/h3>\n
My first idea to get the PDB read write on the standby server is to clone it. Of course, the failover time should not depend on the size of the database, so my idea is to do a snapshot copy, and this is why I’ve setup my standby CDB on ACFS. Here I’m cloning the SBYPDB to the same name as the primary: PRDPDB <\/p>\n
\n21:41:47 SQL> alter session set container=CDB$ROOT;\nSession altered.\n \n21:41:47 SQL> create pluggable database PRDPDB from SBYPDB file_name_convert=('SBYPDB','PRDPDB') snapshot copy;\nPluggable database created.\n \n21:42:03 SQL> alter pluggable database PRDPDB open;\nPluggable database altered.\n<\/code><\/pre>\nI have now my new PRDPDB opened read write with the latest data that was refreshed:<\/p>\n
\n21:42:26 SQL> alter session set container=PRDPDB;\nSession altered.\n \n21:42:26 SQL> alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';\nSession altered.\n \n21:42:26 SQL> select * from scott.emp where ename='KING';\n \n EMPNO ENAME JOB MGR HIREDATE SAL\n---------- ---------- --------- ---------- -------------------- ----------\n 7839 KING PRESIDENT 11-jun-2017 21:41:01 5113\n<\/code><\/pre>\nI’m running on a snapshot here. I can stay like that, or plan to move it out of the snapshot in the future. There is no online datafile move in Standard Edition, but there is the online pluggable database relocate. Anyway, running the database in a snapshot is sufficient to run a production after a Disaster Recovery and I can remove the SBYPRD so that there is no need to copy the ACFS extents on future writes.<\/p>\n
Keep the snapshot<\/h3>\n
At that point, you should tell me that I cannot snapshot copy a PDB within the same CDB here because I’m in Standard Edition. And that’s right: you can create only one PDB there and you are supposed to get a ‘feature not enabled’. But I was able to do it here in my lab, with a small trick to inverse the CON_ID sequence:<\/p>\n
\nConnected to:\nOracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production\n \nSQL> show pdbs\n \n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 PRDPDB READ WRITE NO\n 4 SBYPDB MOUNTED\n<\/code><\/pre>\nRemote snapshot clone should be possible as well. But there’s another licensing issue here. Using ACFS snapshots for the database is not allowed in Standard Edition. This means that this solution probably requires another snapshot solution than the one I’m using here in my lab.<\/p>\n
If you don’t fear to violate the single-tenant rules, you may prefer to keep the SBYPRD for a while. Imagine that you are able to restart the crashed server for a few minutes, then you can do the last refresh of SBYPRD to have a look at the transactions that were lost in the 1 minute window.<\/p>\n
I re-start the crashed CDB:<\/p>\n
\n21:42:26 SQL> connect \/ as sysdba\nConnected to an idle instance.\n21:42:27 SQL> startup\nORACLE instance started.\n \nTotal System Global Area 859832320 bytes\nFixed Size 8798552 bytes\nVariable Size 356519592 bytes\nDatabase Buffers 486539264 bytes\nRedo Buffers 7974912 bytes\nDatabase mounted.\nDatabase opened.\n<\/code><\/pre>\nand now, on my standby server, I can finally stop the refresh mode:<\/p>\n
\n21:42:51 SQL> connect sys\/oracle@\/\/192.168.78.106:1522\/CDB1 as sysdba\nConnected.\n21:42:52 SQL> alter pluggable database SBYPDB close;\nPluggable database altered.\n \n21:42:52 SQL> alter session set container=SBYPDB;\nSession altered.\n \n21:42:52 SQL> alter pluggable database SBYPDB refresh mode none;\nPluggable database altered.\n<\/code><\/pre>\nBe careful not to have jobs or services starting here because your production is now on the snapshot clone PRDPDB running on the same server. Let’s open it:<\/p>\n
\n21:43:02 SQL> alter pluggable database SBYPDB open restricted;\nPluggable database altered.\n \n21:43:24 SQL> select * from scott.emp where ename='KING';\n \n EMPNO ENAME JOB MGR HIREDATE SAL\n---------- ---------- --------- ---------- -------------------- ----------\n 7839 KING PRESIDENT 11-jun-2017 21:41:38 5150\n<\/code><\/pre>\nAnd here we are with the data at the moment of the crash. Then, the application owner can manually check what was missed between the last refresh (which made its way to PRDPDB) and the crash (visible in SBYPDB).<\/p>\n
Unplug\/Plug<\/h3>\n
I was not very satisfied by the snapshot clone because of the limitations in Standard Edition, which is where this solution may be interesting. I have the datafiles but cannot open the SBYPDB read write. I tried to unplug them but cannot because of the refresh mode:<\/p>\n
\nSQL> alter pluggable database SBYPDB unplug into '\/tmp\/tmp.xml';\n \nError starting at line : 1 in command -\nalter pluggable database SBYPDB unplug into '\/tmp\/tmp.xml'\nError report -\nORA-01113: file 23 needs media recovery\nORA-01110: data file 23: '\/acfs\/oradata\/CDB1\/SBYPDB\/undotbs01.dbf'\n01113. 00000 - \"file %s needs media recovery\"\n*Cause: An attempt was made to online or open a database with a file that\n is in need of media recovery.\n*Action: First apply media recovery to the file.\n<\/code><\/pre>\nI know that I don’t need more recovery. So let’s unplug it in another way:<\/p>\n
\nSQL> alter pluggable database SBYPDB open read only;\nPluggable database SBYPDB altered.\n \nSQL> exec dbms_pdb.describe('\/tmp\/tmp.xml','SBYPDB');\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\nThen drop it but keep the datafiles:<\/p>\n
\nSQL> alter pluggable database SBYPDB close;\nPluggable database SBYPDB altered.\n \nSQL> drop pluggable database SBYPDB;\nPluggable database SBYPDB dropped.\n<\/code><\/pre>\nAnd plug it back:<\/p>\n
\nSQL> create pluggable database SBYPDB using '\/tmp\/tmp.xml';\nPluggable database SBYPDB created.\n \nSQL> alter pluggable database SBYPDB open;\nPluggable database SBYPDB altered.\n<\/code><\/pre>\nHere it is. This takes a bit longer than the snapshot solution but still ready to activate the ‘standby’ PDB without copying datafiles.<\/p>\n
So what?<\/h3>\n
All the new 12c<\/i>R2 multitenant features are available in all Editions, which is very good. Here with ALTER PLUGGABLE DATABASE … REFRESH we have log shipping and apply, for free in Standard Edition, at PDB level. And I’ve tested two ways to open this standby PDB in case of disaster recovery. I’m using only supported features here, but be careful that those features were not designed for this goal. The normal operations on refreshable clone require that the remote CDB is accessible. But there are workarounds here because you can describe\/drop\/plug or snapshot clone from a PDB that you can open read only.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . Disclaimer My goal here is only to show that the Refreshable PDB feature works by shipping and applying redo, and then can synchronize a copy of the datafiles. I do not recommend to use it for disaster recovery in any production environment yet. Even if I’m using only supported features, those […]<\/p>\n","protected":false},"author":27,"featured_media":10245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[220,64,96,209,66,223,1121],"type_dbi":[],"class_list":["post-10244","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-cdb","tag-multitenant","tag-oracle","tag-oracle-12c","tag-pdb","tag-pluggable-databases","tag-single-tenant"],"acf":[],"yoast_head":"\n
12cR2 PDB refresh as a poor-man standby? - 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\/12cr2-pdb-refresh-as-a-poor-man-standby\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"12cR2 PDB refresh as a poor-man standby?\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Disclaimer My goal here is only to show that the Refreshable PDB feature works by shipping and applying redo, and then can synchronize a copy of the datafiles. I do not recommend to use it for disaster recovery in any production environment yet. Even if I’m using only supported features, those […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-12T18:04:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png\" \/>\n\t<meta property=\"og:image:width\" content=\"592\" \/>\n\t<meta property=\"og:image:height\" content=\"286\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"10 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\/12cr2-pdb-refresh-as-a-poor-man-standby\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"12cR2 PDB refresh as a poor-man standby?\",\"datePublished\":\"2017-06-12T18:04:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/\"},\"wordCount\":1203,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png\",\"keywords\":[\"CDB\",\"multitenant\",\"Oracle\",\"Oracle 12c\",\"PDB\",\"Pluggable Databases\",\"single-tenant\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/\",\"name\":\"12cR2 PDB refresh as a poor-man standby? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png\",\"datePublished\":\"2017-06-12T18:04:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png\",\"width\":592,\"height\":286},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"12cR2 PDB refresh as a poor-man 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":"12cR2 PDB refresh as a poor-man standby? - 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\/12cr2-pdb-refresh-as-a-poor-man-standby\/","og_locale":"en_US","og_type":"article","og_title":"12cR2 PDB refresh as a poor-man standby?","og_description":"By Franck Pachot . Disclaimer My goal here is only to show that the Refreshable PDB feature works by shipping and applying redo, and then can synchronize a copy of the datafiles. I do not recommend to use it for disaster recovery in any production environment yet. Even if I’m using only supported features, those […]","og_url":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/","og_site_name":"dbi Blog","article_published_time":"2017-06-12T18:04:49+00:00","og_image":[{"width":592,"height":286,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"12cR2 PDB refresh as a poor-man standby?","datePublished":"2017-06-12T18:04:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/"},"wordCount":1203,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png","keywords":["CDB","multitenant","Oracle","Oracle 12c","PDB","Pluggable Databases","single-tenant"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/","url":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/","name":"12cR2 PDB refresh as a poor-man standby? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png","datePublished":"2017-06-12T18:04:49+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePoorManSBY.png","width":592,"height":286},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-pdb-refresh-as-a-poor-man-standby\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"12cR2 PDB refresh as a poor-man 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\/10244","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=10244"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10244\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10245"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10244"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}