{"id":9985,"date":"2017-05-01T06:21:47","date_gmt":"2017-05-01T04:21:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/"},"modified":"2017-05-01T06:21:47","modified_gmt":"2017-05-01T04:21:47","slug":"12cr2-partial-pdb-backup","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/","title":{"rendered":"12cR2 partial PDB backup"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nI had a recent question about the following mention from the <a href=\"https:\/\/www.amazon.com\/Oracle-Database-Release-Multitenant-Press\/dp\/1259836096\" target=\"_blank\" rel=\"noopener noreferrer\">12<em>c<\/em>R2 Multitenant<\/a> book, about Partial PDB backups:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png\" alt=\"CapturePArtialPDBBackup\" width=\"706\" height=\"198\" class=\"alignnone size-full wp-image-16100\" \/><\/a>.<br \/>\nHere is an example in 12.2 with local undo to illustrate the answer, which may help to understand what is a partial PDB backup.<br \/>\n<!--more--><br \/>\nOf course, since 12<em>c<\/em>R1 you can backup PDB individually, without the CDB$ROOT, in the same way you can backup only a few tablespaces subset of a CDB. It can be part of your backup strategy, but it is not to be considered as a backup that you can restore elsewhere later. A PDB is not self-consistent without the PDB$ROOT except if is has been closed and unplugged. In 12.1 you cannot restore a partial PDB backup if you don&#8217;t have the CDB$ROOT at the same point in time, because the recovery phase will need to rollback the ongoing transactions, and this requires to have the UNDO tablespace recovered at the same point in time.<\/p>\n<p>However, in 12.2 with LOCAL UNDO, the partial PDB backup contains the local UNDO tablespace and then it can be sufficient to do a PDB Point In Time Recovery within the same CDB. And, in this case only, it is not required to have a backup of the root.<\/p>\n<p>Let&#8217;s test it. I explicitly delete all backups<\/p>\n<pre><code>\nRecovery Manager: Release 12.2.0.1.0 - Production on Sun Apr 30 22:11:38 2017\n&nbsp;\nCopyright (c) 1982, 2017, Oracle and\/or its affiliates.  All rights reserved.\n&nbsp;\nRMAN&gt;\necho set on\n&nbsp;\nRMAN&gt; connect target \/\nconnected to target database: CDB1 (DBID=914521258)\n&nbsp;\nRMAN&gt; delete noprompt backup;\n&nbsp;\nusing channel ORA_DISK_1\nusing channel ORA_DISK_2\nusing channel ORA_DISK_3\nusing channel ORA_DISK_4\nspecification does not match any backup in the repository\n&nbsp;\n&nbsp;\nRMAN&gt; list backup;\nspecification does not match any backup in the repository\n<\/code><\/pre>\n<h3>No backup<\/h3>\n<p>I have only one PDB here:<\/p>\n<pre><code>\nRMAN&gt; report schema;\nReport of database schema for database with db_unique_name CDB1A\n&nbsp;\nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace           RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1    820      SYSTEM               YES     \/u01\/oradata\/CDB1A\/system01.dbf\n3    630      SYSAUX               NO      \/u01\/oradata\/CDB1A\/sysaux01.dbf\n4    70       UNDOTBS1             YES     \/u01\/oradata\/CDB1A\/undotbs01.dbf\n5    250      PDB$SEED:SYSTEM      NO      \/u01\/oradata\/CDB1A\/pdbseed\/system01.dbf\n6    330      PDB$SEED:SYSAUX      NO      \/u01\/oradata\/CDB1A\/pdbseed\/sysaux01.dbf\n7    5        USERS                NO      \/u01\/oradata\/CDB1A\/users01.dbf\n8    100      PDB$SEED:UNDOTBS1    NO      \/u01\/oradata\/CDB1A\/pdbseed\/undotbs01.dbf\n103  250      PDB1:SYSTEM          YES     \/u01\/oradata\/CDB1A\/PDB1\/system01.dbf\n104  350      PDB1:SYSAUX          NO      \/u01\/oradata\/CDB1A\/PDB1\/sysaux01.dbf\n105  100      PDB1:UNDOTBS1        YES     \/u01\/oradata\/CDB1A\/PDB1\/undotbs01.dbf\n&nbsp;\nList of Temporary Files\n=======================\nFile Size(MB) Tablespace           Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1    131      TEMP                 32767       \/u01\/oradata\/CDB1A\/temp01.dbf\n2    64       PDB$SEED:TEMP        32767       \/u01\/oradata\/CDB1A\/pdbseed\/temp012017-04-08_22-24-09-441-PM.dbf\n4    64       PDB1:TEMP            32767       \/u01\/oradata\/CDB1A\/PDB1\/temp012017-04-08_22-24-09-441-PM.dbf\n<\/code><\/pre>\n<p>all datafiles need backup:<\/p>\n<pre><code>\nRMAN&gt; report need backup;\nRMAN retention policy will be applied to the command\nRMAN retention policy is set to redundancy 1\nReport of files with less than 1 redundant backups\nFile #bkps Name\n---- ----- -----------------------------------------------------\n1    0     \/u01\/oradata\/CDB1A\/system01.dbf\n3    0     \/u01\/oradata\/CDB1A\/sysaux01.dbf\n4    0     \/u01\/oradata\/CDB1A\/undotbs01.dbf\n5    0     \/u01\/oradata\/CDB1A\/pdbseed\/system01.dbf\n6    0     \/u01\/oradata\/CDB1A\/pdbseed\/sysaux01.dbf\n7    0     \/u01\/oradata\/CDB1A\/users01.dbf\n8    0     \/u01\/oradata\/CDB1A\/pdbseed\/undotbs01.dbf\n103  0     \/u01\/oradata\/CDB1A\/PDB1\/system01.dbf\n104  0     \/u01\/oradata\/CDB1A\/PDB1\/sysaux01.dbf\n105  0     \/u01\/oradata\/CDB1A\/PDB1\/undotbs01.dbf\n<\/code><\/pre>\n<h3>Partial backup not including the root<\/h3>\n<p>I backup only the pluggable database PDB1<\/p>\n<pre><code>\nRMAN&gt; backup pluggable database PDB1;\nStarting backup at 30-APR-17\nusing channel ORA_DISK_1\nusing channel ORA_DISK_2\nusing channel ORA_DISK_3\nusing channel ORA_DISK_4\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00104 name=\/u01\/oradata\/CDB1A\/PDB1\/sysaux01.dbf\nchannel ORA_DISK_1: starting piece 1 at 30-APR-17\nchannel ORA_DISK_2: starting full datafile backup set\nchannel ORA_DISK_2: specifying datafile(s) in backup set\ninput datafile file number=00103 name=\/u01\/oradata\/CDB1A\/PDB1\/system01.dbf\nchannel ORA_DISK_2: starting piece 1 at 30-APR-17\nchannel ORA_DISK_3: starting full datafile backup set\nchannel ORA_DISK_3: specifying datafile(s) in backup set\ninput datafile file number=00105 name=\/u01\/oradata\/CDB1A\/PDB1\/undotbs01.dbf\nchannel ORA_DISK_3: starting piece 1 at 30-APR-17\nchannel ORA_DISK_1: finished piece 1 at 30-APR-17\npiece handle=\/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk827s_.bkp tag=TAG20170430T221146 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nchannel ORA_DISK_3: finished piece 1 at 30-APR-17\npiece handle=\/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk83go_.bkp tag=TAG20170430T221146 comment=NONE\nchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:03\nchannel ORA_DISK_2: finished piece 1 at 30-APR-17\npiece handle=\/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk830z_.bkp tag=TAG20170430T221146 comment=NONE\nchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:03\nFinished backup at 30-APR-17\n&nbsp;\nStarting Control File and SPFILE Autobackup at 30-APR-17\npiece handle=\/u01\/fast_recovery_area\/CDB1A\/autobackup\/2017_04_30\/o1_mf_s_942703909_djdk85m1_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 30-APR-17\n<\/code><\/pre>\n<p>Here is the proof that only PDB1 has a backup, the CDB$ROOT has no backup:<\/p>\n<pre><code>\nRMAN&gt; report need backup;\nRMAN retention policy will be applied to the command\nRMAN retention policy is set to redundancy 1\nReport of files with less than 1 redundant backups\nFile #bkps Name\n---- ----- -----------------------------------------------------\n1    0     \/u01\/oradata\/CDB1A\/system01.dbf\n3    0     \/u01\/oradata\/CDB1A\/sysaux01.dbf\n4    0     \/u01\/oradata\/CDB1A\/undotbs01.dbf\n5    0     \/u01\/oradata\/CDB1A\/pdbseed\/system01.dbf\n6    0     \/u01\/oradata\/CDB1A\/pdbseed\/sysaux01.dbf\n7    0     \/u01\/oradata\/CDB1A\/users01.dbf\n8    0     \/u01\/oradata\/CDB1A\/pdbseed\/undotbs01.dbf\n<\/code><\/pre>\n<h3>Restore the PDB<\/h3>\n<p>I will do PDB Point In Time Recovery, using a restore point<\/p>\n<pre><code>\nRMAN&gt; create restore point RP;\nStatement processed\n&nbsp;\nRMAN&gt; alter pluggable database PDB1 close;\nStatement processed\n&nbsp;\n<\/code><\/pre>\n<p>Here is the restore<\/p>\n<pre><code>\nRMAN&gt; restore pluggable database PDB1 until restore point RP;\nStarting restore at 30-APR-17\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=15 device type=DISK\nallocated channel: ORA_DISK_2\nchannel ORA_DISK_2: SID=149 device type=DISK\nallocated channel: ORA_DISK_3\nchannel ORA_DISK_3: SID=268 device type=DISK\nallocated channel: ORA_DISK_4\nchannel ORA_DISK_4: SID=398 device type=DISK\n&nbsp;\nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00104 to \/u01\/oradata\/CDB1A\/PDB1\/sysaux01.dbf\nchannel ORA_DISK_1: reading from backup piece \/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk827s_.bkp\nchannel ORA_DISK_2: starting datafile backup set restore\nchannel ORA_DISK_2: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_2: restoring datafile 00105 to \/u01\/oradata\/CDB1A\/PDB1\/undotbs01.dbf\nchannel ORA_DISK_2: reading from backup piece \/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk83go_.bkp\nchannel ORA_DISK_3: starting datafile backup set restore\nchannel ORA_DISK_3: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_3: restoring datafile 00103 to \/u01\/oradata\/CDB1A\/PDB1\/system01.dbf\nchannel ORA_DISK_3: reading from backup piece \/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk830z_.bkp\nchannel ORA_DISK_2: piece handle=\/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk83go_.bkp tag=TAG20170430T221146\nchannel ORA_DISK_2: restored backup piece 1\nchannel ORA_DISK_2: restore complete, elapsed time: 00:00:03\nchannel ORA_DISK_3: piece handle=\/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk830z_.bkp tag=TAG20170430T221146\nchannel ORA_DISK_3: restored backup piece 1\nchannel ORA_DISK_3: restore complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: piece handle=\/u01\/fast_recovery_area\/CDB1A\/4E68DF57035A648FE053684EA8C01C78\/backupset\/2017_04_30\/o1_mf_nnndf_TAG20170430T221146_djdk827s_.bkp tag=TAG20170430T221146\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:07\nFinished restore at 30-APR-17\n<\/code><\/pre>\n<p>and the recover<\/p>\n<pre><code>\nRMAN&gt; recover pluggable database PDB1 until restore point RP;\nStarting recover at 30-APR-17\nusing channel ORA_DISK_1\nusing channel ORA_DISK_2\nusing channel ORA_DISK_3\nusing channel ORA_DISK_4\n&nbsp;\nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n&nbsp;\nFinished recover at 30-APR-17\n<\/code><\/pre>\n<p>Fimnally, I open resetlogs<\/p>\n<pre><code>\nRMAN&gt; alter pluggable database PDB1 open resetlogs;\nStatement processed\n<\/code><\/pre>\n<p>Thanks to LOCAL UNDO there is no need to restore the CDB$ROOT into an auxiliary instance, as it was the case for PDBPITR in 12.1 and then we can do PDBPITR without a backup of the root.<\/p>\n<h3>So what?<\/h3>\n<p>In theory, and as demonstrated above, including CDB$ROOT into a partial PDB backup is not mandatory in 12<i>c<\/i>R2 in local undo mode. However, keep in mind that this is for academic purpose only, not for real-life production. For short-term point in time, you will not use backups but flashback. For long-term restore, then you may have different reasons to restore the PDB elsewhere with its CDB$ROOT at the same point in time: some common objects (users, roles, directories, etc) may have changed. And anyway, your backup strategy should be at CDB level.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . I had a recent question about the following mention from the 12cR2 Multitenant book, about Partial PDB backups: . Here is an example in 12.2 with local undo to illustrate the answer, which may help to understand what is a partial PDB backup.<\/p>\n","protected":false},"author":27,"featured_media":9986,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[656,220,64,96,209,66,223],"type_dbi":[],"class_list":["post-9985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-12-2","tag-cdb","tag-multitenant","tag-oracle","tag-oracle-12c","tag-pdb","tag-pluggable-databases"],"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>12cR2 partial PDB backup - 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-partial-pdb-backup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"12cR2 partial PDB backup\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . I had a recent question about the following mention from the 12cR2 Multitenant book, about Partial PDB backups: . Here is an example in 12.2 with local undo to illustrate the answer, which may help to understand what is a partial PDB backup.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-01T04:21:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png\" \/>\n\t<meta property=\"og:image:width\" content=\"706\" \/>\n\t<meta property=\"og:image:height\" content=\"198\" \/>\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=\"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\/12cr2-partial-pdb-backup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"12cR2 partial PDB backup\",\"datePublished\":\"2017-05-01T04:21:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/\"},\"wordCount\":422,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png\",\"keywords\":[\"12.2\",\"CDB\",\"multitenant\",\"Oracle\",\"Oracle 12c\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/\",\"name\":\"12cR2 partial PDB backup - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png\",\"datePublished\":\"2017-05-01T04:21:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png\",\"width\":706,\"height\":198},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"12cR2 partial PDB backup\"}]},{\"@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 partial PDB backup - 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-partial-pdb-backup\/","og_locale":"en_US","og_type":"article","og_title":"12cR2 partial PDB backup","og_description":"By Franck Pachot . I had a recent question about the following mention from the 12cR2 Multitenant book, about Partial PDB backups: . Here is an example in 12.2 with local undo to illustrate the answer, which may help to understand what is a partial PDB backup.","og_url":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/","og_site_name":"dbi Blog","article_published_time":"2017-05-01T04:21:47+00:00","og_image":[{"width":706,"height":198,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png","type":"image\/png"}],"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\/12cr2-partial-pdb-backup\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"12cR2 partial PDB backup","datePublished":"2017-05-01T04:21:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/"},"wordCount":422,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png","keywords":["12.2","CDB","multitenant","Oracle","Oracle 12c","PDB","Pluggable Databases"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/","url":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/","name":"12cR2 partial PDB backup - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png","datePublished":"2017-05-01T04:21:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CapturePArtialPDBBackup.png","width":706,"height":198},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-partial-pdb-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"12cR2 partial PDB backup"}]},{"@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\/9985","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=9985"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9985\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9986"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9985"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}