{"id":11257,"date":"2018-05-15T13:53:57","date_gmt":"2018-05-15T11:53:57","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/"},"modified":"2018-05-15T13:53:57","modified_gmt":"2018-05-15T11:53:57","slug":"pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/","title":{"rendered":"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c"},"content":{"rendered":"

With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB.<\/p>\n

In my environment, my original CDB is DB18, with the PDB named pdborig. The target CDB is PSI18.<\/p>\n

The first step consist in running a rman backup on pdborig:<\/p>\n

oracle@localhost:\/u00\/app\/oracle\/ [DB18] rman target sys\/manager@pdborig\nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 15 10:57:38 2018\nVersion 18.1.0.0.0\nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: DB18:PDBORIG (DBID=3031125269)\n\nRMAN> backup pluggable database pdborig plus archivelog;\n\nStarting backup at 15-MAY-2018 10:57:55\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=80 device type=DISK\nskipping archived logs when connected to a PDB\nbackup cancelled because there are no files to backup\nFinished backup at 15-MAY-2018 10:57:56\n\nStarting backup at 15-MAY-2018 10:57:56\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00029 name=\/u00\/app\/oracle\/oradata\/DB18\/pdborig\/undotbs01.dbf\ninput datafile file number=00027 name=\/u00\/app\/oracle\/oradata\/DB18\/pdborig\/system01.dbf\ninput datafile file number=00028 name=\/u00\/app\/oracle\/oradata\/DB18\/pdborig\/sysaux01.dbf\ninput datafile file number=00030 name=\/u00\/app\/oracle\/oradata\/DB18\/pdborig\/users01.dbf\nchannel ORA_DISK_1: starting piece 1 at 15-MAY-2018 10:57:56\nchannel ORA_DISK_1: finished piece 1 at 15-MAY-2018 10:57:59\npiece handle=\/u00\/app\/oracle\/fast_recovery_area\/DB18\/DB18\/\n6C3BAD3B7C73354AE0530100007F9AD9\/backupset\/\n2018_05_15\/o1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp \ntag=TAG20180515T105756 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 15-MAY-2018 10:57:59\n\nStarting backup at 15-MAY-2018 10:57:59\nusing channel ORA_DISK_1\nskipping archived logs when connected to a PDB\nbackup cancelled because there are no files to backup\nFinished backup at 15-MAY-2018 10:57:59\n\n<\/pre>\n
Then we have to export the RMAN backup metadata for the non CDB into its dictionary using dbms_pdb.exportrmanbackup()<\/p>\n
oracle@localhost:\/u00\/app\/oracle\/ [DB18] sqlplus sys\/manager@pdborig as sysdba\n\nSQL*Plus: Release 18.0.0.0.0 Production on Tue May 15 11:00:38 2018\nVersion 18.1.0.0.0\n\nCopyright (c) 1982, 2017, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.1.0.0.0\n\nSQL> execute dbms_pdb.exportrmanbackup();\n\nPL\/SQL procedure successfully completed.\n\n<\/pre>\n
As my environment is configured with TDE, in order to unplug the pdborig, we need to export the master key of the container database otherwise we will receive the following error message:<\/p>\n
SQL> alter pluggable database pdborig \nunplug into '\/home\/oracle\/pdborig.xml';\nalter pluggable database pdborig unplug into '\/home\/oracle\/pdborig.xml'\n*\nERROR at line 1:\nORA-46680: master keys of the container database must be exported\n\nWe export the master key:\n\nSQL> alter session set container=PDBORIG;<\/pre>\n
Session altered\n\nSQL> administer key management \n  2  export encryption keys with secret \"manager_cdb\" \n  3  to '\/home\/oracle\/pdborig.p12'\n  4  identified by manager_cdb;\n\nkeystore altered.\n\nSQL> alter pluggable database PDBORIG close immediate;\n\nPluggable database altered.\n\nSQL> alter pluggable database PDBORIG unplug into '\/home\/oracle\/pdborig.xml';\n\nPluggable database altered.\n\nFinallly on the target CDB named PSI18, we first have to create a wallet and \nopen the keystore. Just remember you have to define wallet_root and \ntde_configuration in your CDB environment in order to use TDE:\n\n\n<\/pre>\n
SQL> show parameter wallet\n\nNAME\t\t       TYPE\t    VALUE\n-------------------- ----------- -------------------------------------\nwallet_root\t       string\t \/u00\/app\/oracle\/admin\/PSI18\/walletcdb\n\nSQL> alter system set tde_configuration=\"keystore_configuration=file\";\nSystem altered.\n\n<\/pre>\n
We create and open the keystore on the target CDB and we import the master key:<\/p>\n
SQL> administer key management create keystore identified by manager_cdb;\n\nkeystore altered.\n\nSQL> administer key management set keystore open \nidentified by manager_cdb container=all;\n\nkeystore altered.\n\nSQL> alter session set container=pdb1;\n\nSession altered.\n\nSQL> administer key management import encryption keys \n     with secret \"manager_cdb\" from '\/home\/oracle\/pdborig.p12'\n     identified by \"manager_cdb\" with backup;\n\nkeystore altered.\n\n<\/pre>\n
We create pdbnew on the target CDB using pdborig.xml:<\/p>\n
SQL> create pluggable database pdbnew using '\/home\/oracle\/pdborig.xml'\nfile_name_convert=\n('\/u00\/app\/oracle\/oradata\/DB18\/pdborig','\/home\/oracle\/oradata\/PSI18\/pdbnew');\n\nPluggable database created.\n\n<\/pre>\n
We open the pluggable database pdbnew:<\/p>\n
SQL> alter pluggable database pdbnew open;\n\nPluggable database altered.\n\nSQL> show pdbs\n\n    CON_ID CON_NAME\t\t\t  OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n\t 2 PDB$SEED\t\t\t  READ ONLY  NO\n\t 4 PDBNEW\t\t\t  READ WRITE NO\n\n<\/pre>\n
And now the non CDB PDBNEW has been plugged in the target CDB, we can ask if the rman backups are visible because we had exported the rman metadata backup. To visualize that we have to use the preplugin clause:<\/p>\n
RMAN> list preplugin backup of pluggable database pdbnew;\n\n\nList of Backup Sets\n===================\n\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time     \n------- ---- -- ---------- ----------- ------------ --------------------\n9       Full    463.15M    DISK        00:00:01     15-MAY-2018 10:56:51\n        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105650\n        Piece Name: \/u00\/app\/oracle\/fast_recovery_area\/DB18\/DB18\/\n6C3BAD3B7C73354AE0530100007F9AD9\/backupset\/2018_05_15\/\no1_mf_nnndf_TAG20180515T105650_fho86ltx_.bkp\n  List of Datafiles in backup set 9\n  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- -------------------- ----------- ------ ----\n  20 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/system01.dbf\n  21 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/sysaux01.dbf\n  22 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/undotbs01.dbf\n  23 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/users01.dbf\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time     \n------- ---- -- ---------- ----------- ------------ --------------------\n10      Full    463.15M    DISK        00:00:01     15-MAY-2018 10:57:57\n        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105756\n        Piece Name: \/u00\/app\/oracle\/fast_recovery_area\/DB18\/DB18\/6C3BAD3B7C73354AE0530100007F9AD9\/backupset\/2018_05_15\/o1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp\n  List of Datafiles in backup set 10\n  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- -------------------- ----------- ------ ----\n  20 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/system01.dbf\n  21 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/sysaux01.dbf\n  22 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/undotbs01.dbf\n  23 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/users01.dbf\n\nWe can also display the archive logs preplugin backups:\n\n<\/pre>\n
RMAN> list preplugin archivelog all;\n\nList of Archived Log Copies for database with db_unique_name PSI18\n=====================================================================\n\nKey     Thrd Seq     S Low Time            \n------- ---- ------- - --------------------\n.....\n\n6       1    16      A 15-MAY-2018 10:08:53\n\/u00\/app\/oracle\/fast_recovery_area\/archivelog\/2018_05_15\/o1_mf_1_16_fho5r944_.a\n...<\/pre>\n
So let\u2019s see if we can make a restore and recover test:<\/p>\n
We delete the user01.dbf datafile:<\/p>\n
oracle@localhost:\/u00\/app\/oracle\/ [PSI18] rm \/home\/oracle\/oradata\/PSI18\/pdbnew\/users01.dbf\n\noracle@localhost:\/u00\/app\/oracle\/oradata\/DB18\/pdbseed\/ [PSI18] sq\n\nSQL*Plus: Release 18.0.0.0.0 Production on Tue May 15 11:20:47 2018\nVersion 18.1.0.0.0\n\nCopyright (c) 1982, 2017, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.1.0.0.0\n\nSQL> alter pluggable database pdbnew close;\n\nPluggable database altered.\n\nSQL> alter pluggable database pdbnew open;\nalter pluggable database pdbnew open\n*\nERROR at line 1:\nORA-01157: cannot identify\/lock data file 23 - see DBWR trace file\n\n<\/pre>\n
Now we try to restore: we connect with rman to the target CDB and we set the PDB that needs to be restored with the command set preplugin container=pdbnew:<\/p>\n
oracle@localhost:\/u00\/app\/oracle\/ [PSI18] rman target sys\/manager@psi18\n\nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 15 11:25:06 2018\nVersion 18.1.0.0.0\n\nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: PSI18 (DBID=3896993764)\n\nRMAN> set preplugin container=pdbnew;\n\nexecuting command: SET PREPLUGIN CONTAINER\nusing target database control file instead of recovery catalog\n\nRMAN> list preplugin backup of pluggable database pdbnew;\n\n\nList of Backup Sets\n===================\n\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time     \n------- ---- -- ---------- ----------- ------------ --------------------\n9       Full    463.15M    DISK        00:00:01     15-MAY-2018 10:56:51\n        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105650\n        Piece Name: \/u00\/app\/oracle\/fast_recovery_area\/\n\/6C3BAD3B7C73354AE0530100007F9AD9\/backupset\/\n2018_05_15\/o1_mf_nnndf_TAG20180515T105650_fho86ltx_.bkp\n  List of Datafiles in backup set 9\n  Container ID: 4, PDB Name: PDBNEW\n  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- -------------------- ----------- ------ ----\n  20 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/system01.dbf\n  21 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/sysaux01.dbf\n  22 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/undotbs01.dbf\n  23 Full 1081248 15-MAY-2018 10:56 \/home\/oracle\/oradata\/PSI18\/pdbnew\/users01.dbf\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time     \n------- ---- -- ---------- ----------- ------------ --------------------\n10      Full    463.15M    DISK        00:00:01     15-MAY-2018 10:57:57\n        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105756\n        Piece Name: \/u00\/app\/oracle\/fast_recovery_area\n\/6C3BAD3B7C73354AE0530100007F9AD9\/backupset\/2018_05_15\/\no1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp\n  List of Datafiles in backup set 10\n  Container ID: 4, PDB Name: PDBNEW\n  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- -------------------- ----------- ------ ----\n  20 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/system01.dbf\n  21 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/sysaux01.dbf\n  22 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/undotbs01.dbf\n  23 Full 1081326 15-MAY-2018 10:57 \/home\/oracle\/oradata\/PSI18\/pdbnew\/users01.dbf\n\nWe run the restore command with the preplugin clause:\n\n<\/pre>\n
RMAN> restore pluggable database pdbnew from preplugin;\n\nStarting restore at 15-MAY-2018 11:26:23\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=108 device type=DISK\n\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 00020 to \n\/home\/oracle\/oradata\/PSI18\/pdbnew\/system01.dbf\nchannel ORA_DISK_1: restoring datafile 00021 to \n\/home\/oracle\/oradata\/PSI18\/pdbnew\/sysaux01.dbf\nchannel ORA_DISK_1: restoring datafile 00022 to \n\/home\/oracle\/oradata\/PSI18\/pdbnew\/undotbs01.dbf\nchannel ORA_DISK_1: restoring datafile 00023 to \n\/home\/oracle\/oradata\/PSI18\/pdbnew\/users01.dbf\nchannel ORA_DISK_1: reading from backup piece \/u00\/app\/oracle\/fast_recovery_area\/\nDB18\/DB18\/6C3BAD3B7C73354AE0530100007F9AD9\/backupset\/2018_05_15\/\no1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp\nchannel ORA_DISK_1: piece handle=\/u00\/app\/oracle\/fast_recovery_area\/DB18\/DB18\/\n6C3BAD3B7C73354AE0530100007F9AD9\/backupset\/2018_05_15\/\no1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp tag=TAG20180515T105756\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:03\nFinished restore at 15-MAY-2018 11:26:28\n\n<\/pre>\n
We run the recover command with the preplugin clause:<\/p>\n
RMAN> recover pluggable database pdbnew from preplugin;\n\nStarting recover at 15-MAY-2018 11:27:02\nusing channel ORA_DISK_1\n\nstarting media recovery\n\nunable to find archived log\narchived log thread=1 sequence=17\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of recover command at 05\/15\/2018 11:27:03\nRMAN-06054: media recovery requesting unknown archived log \nfor thread 1 with sequence 17 and starting SCN of 1081326\n\n<\/pre>\n
We have to catalog the archive logs generated after the backup into the target CDB by issuing the catalog preplugin archivelog command :<\/p>\n
RMAN> catalog preplugin archivelog '\/u00\/app\/oracle\/fast_recovery_area\/\nDB18\/DB18\/archivelog\/2018_05_15\/o1_mf_1_17_fhob69t7_.arc';\n\ncataloged archived log\narchived log file name=\/u00\/app\/oracle\/fast_recovery_area\/DB18\/DB18\/\narchivelog\/2018_05_15\/o1_mf_1_17_fhob69t7_.arc RECID=7 STAMP=0\n\n<\/pre>\n
Finally the recover command runs successfully:<\/p>\n
RMAN> recover pluggable database pdbnew from preplugin;\n\nStarting recover at 15-MAY-2018 11:32:25\nusing channel ORA_DISK_1\n\nstarting media recovery\n\narchived log for thread 1 with sequence 17 is already on disk as file \n\/u00\/app\/oracle\/fast_recovery_area\/DB18\/DB18\/archivelog\/2018_05_15\/\no1_mf_1_17_fhob69t7_.arc\nmedia recovery complete, elapsed time: 00:00:00\nFinished recover at 15-MAY-2018 11:32:26<\/pre>\n
We finish the recover and open the target PDB:<\/p>\n
RMAN> recover pluggable database pdbnew;\n\nStarting recover at 15-MAY-2018 11:33:10\nusing channel ORA_DISK_1\n\nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n\nFinished recover at 15-MAY-2018 11:33:10\n\nRMAN> alter pluggable database pdbnew open;\n\nStatement processed\n\nRMAN> exit\n\n\nRecovery Manager complete.\n\nAs far we can see, the target PDB has been successfully restored and recovered:\n\n<\/pre>\n
oracle@localhost:\/u00\/app\/oracle\/oradata\/DB18\/\/ [PSI18] sq\n\nSQL*Plus: Release 18.0.0.0.0 Production on Tue May 15 11:33:37 2018\nVersion 18.1.0.0.0\n\nCopyright (c) 1982, 2017, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.1.0.0.0\n\nSQL> show pdbs\n\n    CON_ID CON_NAME\t\t\t  OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n\t 2 PDB$SEED\t\t\t  READ ONLY  NO\n\t 4 PDBNEW\t\t\t  READ WRITE NO\n\n<\/pre>\n
The preplugin clause can be used on the target CDB with rman commands like restore, recover, crosscheck, list and delete.<\/p>\n
This new feature helps to maintain the backup compliance after moving to a new target CDB.<\/p>\n","protected":false},"excerpt":{"rendered":"
With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with the PDB named pdborig. The target CDB is PSI18. The first step consist in running […]<\/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":[220,96,66,270],"type_dbi":[],"class_list":["post-11257","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-cdb","tag-oracle","tag-pdb","tag-rman"],"acf":[],"yoast_head":"\nPDB RMAN backups available after plugging in on a new CDB with Oracle 18c - 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\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c\" \/>\n<meta property=\"og:description\" content=\"With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with the PDB named pdborig. The target CDB is PSI18. The first step consist in running […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-15T11:53:57+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=\"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\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c\",\"datePublished\":\"2018-05-15T11:53:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/\"},\"wordCount\":329,\"commentCount\":0,\"keywords\":[\"CDB\",\"Oracle\",\"PDB\",\"RMAN\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/\",\"name\":\"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2018-05-15T11:53:57+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c\"}]},{\"@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":"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c - 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\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/","og_locale":"en_US","og_type":"article","og_title":"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c","og_description":"With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with the PDB named pdborig. The target CDB is PSI18. The first step consist in running […]","og_url":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/","og_site_name":"dbi Blog","article_published_time":"2018-05-15T11:53:57+00:00","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\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c","datePublished":"2018-05-15T11:53:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/"},"wordCount":329,"commentCount":0,"keywords":["CDB","Oracle","PDB","RMAN"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/","url":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/","name":"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-05-15T11:53:57+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-rman-backups-available-after-plugging-in-on-a-new-cdb-with-oracle-18c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PDB RMAN backups available after plugging in on a new CDB with Oracle 18c"}]},{"@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\/11257","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=11257"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11257\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11257"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}